Re: [GENERAL] how to use pg_dump and then restored onto development server

thanks. - Original Message - From: Matt Van Mater [EMAIL PROTECTED] To: Zlatko Matic [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Thursday, June 30, 2005 7:25 PM Subject: Re: [GENERAL] how to use pg_dump and then restored onto development server On 6/29/05, Douglas

Re: [GENERAL] how to use pg_dump and then restored onto development server

On 6/29/05, Douglas McNaught [EMAIL PROTECTED] wrote: Zlatko Matic [EMAIL PROTECTED] writes: OK..i get it. It works... My additional question is: how to incorporate timestamp in dumped file name ? Let's say, if we have script: pg_dump -f D:\MYDB_BCP -Fc -c -x -h localhost -U postgres

[GENERAL] how to use pg_dump and then restored onto development server

Hi, All , I am newbie to postgres database. How to take pg_dump from production database and restore into development server using pg_restore.. From documentation, I find that I have to use pg_dump for backup and pg_restore for restoration. My database name is otsdb.. For backup…I use

Re: [GENERAL] how to use pg_dump and then restored onto development server

postgresMYDB Thanks. - Original Message - From: ketan shah To: pgsql-general@postgresql.org Sent: Wednesday, June 29, 2005 4:48 PM Subject: [GENERAL] how to use pg_dump and then restored onto development server Hi, All , I am newbie

Re: [GENERAL] how to use pg_dump and then restored onto development server

ketan shah [EMAIL PROTECTED] writes: Hi, All , I am newbie to postgres database. How to take pg_dump from production database and restore into development server using pg_restore.. From documentation, I find that I have to use pg_dump for backup and pg_restore for restoration. My

Re: [GENERAL] how to use pg_dump and then restored onto development server

Zlatko Matic [EMAIL PROTECTED] writes: Concerning this question about pg_dump, I'm also confused and don't understand when to use pg_restore and when to use psql ? For example, how to restore in these two cases: A) pg_dump -f D:\MYDB_BCP -c -x -h localhost -U postgres MYDB B) pg_dump -f

Re: [GENERAL] how to use pg_dump and then restored onto development server

? Thanks. - Original Message - From: Douglas McNaught [EMAIL PROTECTED] To: Zlatko Matic [EMAIL PROTECTED] Cc: ketan shah [EMAIL PROTECTED]; pgsql-general@postgresql.org Sent: Wednesday, June 29, 2005 5:29 PM Subject: Re: [GENERAL] how to use pg_dump and then restored onto development

Re: [GENERAL] how to use pg_dump and then restored onto development server

Zlatko Matic [EMAIL PROTECTED] writes: OK..i get it. It works... My additional question is: how to incorporate timestamp in dumped file name ? Let's say, if we have script: pg_dump -f D:\MYDB_BCP -Fc -c -x -h localhost -U postgres MYDB, so that output file is named something like