Re: backup postgresql to remote server
John Peter Loh <[email protected]> Tue, 15 Nov 2005 20:52:27 +0800
| Newsgroups | gmane.org.user-groups.linux.philippine.newbies |
|---|---|
| Message-ID | <[email protected]> |
Also, you might want to try phpPgAdmin. On 11/14/05, Eman Gardaya Calso <[email protected]> wrote: > > On Mon, 2005-11-14 at 00:56 +0000, Ogie Sarmiento wrote: > > yes,i see that but this command your backup save on a localhost, iwant > > to save my backup to a remote host.. thanks > > > > After running pg_dump to backup dbname to outfile, you'll just have to > transfer that outfile to your remote host, then run: > $ psql -d dbname -f outfile > > Please read the manual pages. Refer to pg_dump(1) and psql(1) for more > details. > > HTH > > -- > eman > http://www.bloodpet.tk/ || http://www.bloodpet.dsl.ph/ > gpg --keyserver pgp.mit.edu <http://pgp.mit.edu> --recv-keys 4C683E4C > Registered Linux User #287022 > +63(2)455-3222 > Books just wanna be FREE! > See what I mean at: > http://bookcrossing.com/friend/bloodpet > > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (GNU/Linux) > > iD8DBQBDeKUiLVRiw0xoPkwRAjIDAJ9FWQ4o1wqco49Bh1UmLwnM7j+nKwCfV+Ga > jGNCYi2foq/nil55lKqhh0I= > =sdTw > -----END PGP SIGNATURE----- > > > _________________________________________________________ > Philippine Linux Users' Group (PLUG) Newbie Mailing List > [email protected] (#PLUG @ irc.free.net.ph<http://irc.free.net.ph> > ) > Read the Guidelines: http://linux.org.ph/lists > Searchable Archives: http://archives.free.net.ph > > > -- John Peter Loh http://www.jploh.com/ _________________________________________________________ Philippine Linux Users' Group (PLUG) Newbie Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph