how use pg_dump/pg_restore

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

how use pg_dump/pg_restore

Ketan S Shah

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