how to use pg_dump and then restored onto development server

Поиск
Список
Период
Сортировка
От ketan shah
Тема how to use pg_dump and then restored onto development server
Дата
Msg-id 20050629144801.92169.qmail@web51502.mail.yahoo.com
обсуждение исходный текст
Ответы Re: how to use pg_dump and then restored onto development server  (Douglas McNaught <doug@mcnaught.org>)
Список pgsql-general

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 restoration.

My database name is otsdb..

 For backup…I use command

    Pg_dump otsdb > /home/Ketan/otsdbbkp.out

 But after successfully dump…I can’t 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 по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: faking writable views as tables
Следующее
От: D A GERM
Дата:
Сообщение: Need help writing SQL statement