dcsimg
Postgresql Backup & Dump!
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Gajanan_Choudhari
Posted On:   Friday, April 9, 2004 05:06 AM

Postgresql Backup & Dump Hi, In my application I need to use previous database prsent on postgersql. For that I have created dump using pg_dump -o db_name | gzip > db_dump command at the site and then downloaded the dump on local server. But when I am trying to restore, it only restore the empty database tables. I am using following to restore the database. /usr/local/pgsql/bin/psql db_name < db_dump So what shuold be right procedure to restore the database at my server from the remote server? Where I am going wrong? Thank! Regard, Gajanan S.    More>>
Postgresql Backup & Dump


Hi,
In my application I need to use previous database prsent on postgersql. For that I have created dump using
pg_dump -o db_name | gzip > db_dump
command at the site and then downloaded the dump on local server. But when I am trying to restore, it only restore the empty database tables. I am using following to restore the database.
/usr/local/pgsql/bin/psql db_name < db_dump
So what shuold be right procedure to restore the database at my server from the remote server?
Where I am going wrong?
Thank!
Regard,
Gajanan S.

   <<Less
About | Sitemap | Contact