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 | 001201c57cbc$55d27940$c5861dc3@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 |
----- Original Message -----From: ketan shahSent: Wednesday, June 29, 2005 4:48 PMSubject: [GENERAL] how to use pg_dump and then restored onto development serverHi,
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 command
Pg_dump otsdb > /home/Ketan/otsdbbkp.out
But after successfully dump I cant see the otsdbbkp.out file in /home/Ketan/
If I get otsdbbkp.out file then I copy this file on my development server and then I issue the following command
Psql d otsdb f otsdbbkp.out
(my development server database name is otsdb)
pl. help me .
If any thing wrong pl. guide me..
Ketan shah
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
В списке pgsql-general по дате отправления: