Re: [ilugd] Postgres..Urgent Help Required!!

2004-10-06 Thread Shantanu Kumar
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

Re: [ilugd] Postgres..Urgent Help Required!!

2004-10-06 Thread amitflu
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!!

2004-10-06 Thread Freemail
: 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

Re: Re: [ilugd] Postgres..Urgent Help Required!!

2004-10-06 Thread Nishant Kavi
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