Re: backup postgresql to remote server

Eman Gardaya Calso <[email protected]> Mon, 14 Nov 2005 22:54:26 +0800
Newsgroups gmane.org.user-groups.linux.philippine.newbies
Message-ID <[email protected]>
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 --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

_________________________________________________________
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
signature.asc (application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQBDeKUiLVRiw0xoPkwRAjIDAJ9FWQ4o1wqco49Bh1UmLwnM7j+nKwCfV+Ga
jGNCYi2foq/nil55lKqhh0I=
=sdTw
-----END PGP SIGNATURE-----
smime.p7s (application/x-pkcs7-signature, 3.2 KB) - not displayed