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