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
Thanks Shantanu,
But I specifically need the name of the
directory(with full path) where the postgressql
have been initialized.
Regards,
Amit
___
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com
: Re: [ilugd] Postgres..Urgent Help Required!!
Thanks Shantanu,
But I specifically need the name of the
directory(with full path) where the postgressql have been initialized.
Regards,
Amit
___
Do you Yahoo!?
Declare Yourself - Register online to vote
What this bloke wants is a File system level backup. So, the following is suggested:
tar -cf backup.tar /usr/local/pgsql/data
There are two restrictions, however, which make this method impractical, or at least
inferior to the pg_dump method:
1. The database server must be shut down in order