amitflu wrote:
I need "DATADIR"(database directory) of a
postgres database from a different machine. I
have all the information like
Port,DatabaseName,Host,Username,Password.
This is not a PostgreSQL issue. You only want data from another machine.
You could take backup on CDs or a Flash disk and restore on the target.
Or get it tar+[g|b]zipped via HTTP/S, or S/FTP or NFS of even SSH. Over
long distance, SSH is recommended as it's fast and secure.
Let's say you want contents of dir /var/lib/pgsql downloaded. Do as follows:
ssh [EMAIL PROTECTED] "tar cj /var/lib/pgsql" > dump.tar.bz2
Replace "user" and "host" as appropriate.
Regards,
Shantanu
_______________________________________________
ilugd mailinglist -- [EMAIL PROTECTED]
http://frodo.hserus.net/mailman/listinfo/ilugd
Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi
http://www.mail-archive.com/[EMAIL PROTECTED]/
