Re: how to use pg_dump and then restored onto development server

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