| From: | "Javier Carlos" <nediam(at)nediam(dot)com(dot)mx> |
|---|---|
| To: | "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump, pg_restore |
| Date: | 2006-02-06 06:25:15 |
| Message-ID: | 20060206061711.M29081@nediam.com.mx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Basing on the way you did the pg_dump (without the -C option), I think you
should have created the database before you performed the pg_restore,
You can see some examples of database backup/restore in this page:
http://nediam.com.mx/en/tips/backups_pgsql.php
Regards,
Javier
On Mon, 6 Feb 2006 10:54:27 +0530, surabhi.ahuja wrote
> i am trying to do :
>
> pg_dump -f op.tar -F t database_name
>
> then i do
>
> dropdb database_name
>
> and then i do pg_restore op.tar
>
> and when i do psql database_name
>
> it says database does not exist.
>
> where am i going wrong?
>
> thanks,
>
> regards
>
> Surabhi
--
nediam.com.mx
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Sydney-Smith | 2006-02-06 09:35:25 | Re: Automating backup |
| Previous Message | indu ss | 2006-02-06 06:12:20 | Compile of Pgmail function fails |