From: | "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> |
---|---|
To: | "Douglas McNaught" <doug(at)mcnaught(dot)org> |
Cc: | "ketan shah" <ketan_dba(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: how to use pg_dump and then restored onto development server |
Date: | 2005-06-29 18:54:24 |
Message-ID: | 003801c57cdb$f9638c60$9d321dc3@zlatko58zaczpv |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 MYDB_BCP_2005-29-01, for
example. Is that possible?
Thanks.
----- Original Message -----
From: "Douglas McNaught" <doug(at)mcnaught(dot)org>
To: "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Cc: "ketan shah" <ketan_dba(at)yahoo(dot)com>; <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, June 29, 2005 5:29 PM
Subject: Re: [GENERAL] how to use pg_dump and then restored onto development
server
> "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> 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 D:\MYDB_BCP -Fc -c -x -h localhost -U postgres MYDB
>
> If you use any of the binary dump formats (-Fc or -Ft), use
> pg_restore. For text dumps (the default) use psql.
>
> -Doug
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
From | Date | Subject | |
---|---|---|---|
Next Message | Vivek Khera | 2005-06-29 18:59:46 | Re: PostgreSQL's vacuumdb fails to allocate memory for non-root users |
Previous Message | Matt Miller | 2005-06-29 18:53:58 | Re: CVS Build - No Doc |