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
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
"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
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
"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
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
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