Re: how to use pg_dump and then restored onto development server
От | Zlatko Matic |
---|---|
Тема | Re: how to use pg_dump and then restored onto development server |
Дата | |
Msg-id | 003801c57cdb$f9638c60$9d321dc3@zlatko58zaczpv обсуждение исходный текст |
Ответ на | how to use pg_dump and then restored onto development server (ketan shah <ketan_dba@yahoo.com>) |
Ответы |
Re: how to use pg_dump and then restored onto development server
|
Список | 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@mcnaught.org> To: "Zlatko Matic" <zlatko.matic1@sb.t-com.hr> Cc: "ketan shah" <ketan_dba@yahoo.com>; <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 server > "Zlatko Matic" <zlatko.matic1@sb.t-com.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
В списке pgsql-general по дате отправления: