ketan shah <ketan_dba@xxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
