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

2005-07-01 Thread Zlatko Matic
thanks. - Original Message - From: "Matt Van Mater" <[EMAIL PROTECTED]> To: "Zlatko Matic" <[EMAIL PROTECTED]> Cc: Sent: Thursday, June 30, 2005 7:25 PM Subject: Re: [GENERAL] how to use pg_dump and then restored onto development server On 6

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

2005-06-30 Thread Matt Van Mater
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 > > local

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

2005-06-29 Thread Douglas McNaught
"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

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

2005-06-29 Thread Zlatko Matic
sible? Thanks. - Original Message - From: "Douglas McNaught" <[EMAIL PROTECTED]> To: "Zlatko Matic" <[EMAIL PROTECTED]> Cc: "ketan shah" <[EMAIL PROTECTED]>; Sent: Wednesday, June 29, 2005 5:29 PM Subject: Re: [GENERAL] how to use pg_dump a

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

2005-06-29 Thread Douglas McNaught
"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

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

2005-06-29 Thread Douglas McNaught
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 restoratio

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

2005-06-29 Thread Zlatko Matic
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 D:\MYDB_BCP -Fc -c -x -h localhost -U pos