ketan shah <ketan_dba@yahoo.com> writes:
> 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/
Do you get any error messages?
> 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
Are those really asterisks rather than dashes?
What error message do you get?
-Doug