Skip site navigation (1) Skip section navigation (2)

Re: Dump and Restore

From: Ron St-Pierre <rstpierre(at)syscor(dot)com>
To: "Eduardo S(dot) Fontanetti" <dufuzzy(at)yahoo(dot)com(dot)br>,pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dump and Restore
Date: 2004-08-24 16:28:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-general
Eduardo S. Fontanetti wrote:

>How can I do a test if my dumping is really working, I
>can't apply the dump in my database, because it will
>overwrite a lot of data. I was thinking about restore
>in another database name, but I can't, it always
>restore on the original database.
>Somebody have a cooking recipe about to test if my
>backup is working fine, and will help if I need
OK here's a recipe:
If you're using  pg_dump as in:
    pg_dump dbName > fileName
create your new database:
   createdb myNewDB (don't forget your encoding)
and then restore from the dump:
   psql -d myNewDB -f fileName


In response to

pgsql-admin by date

Next:From: Eduardo S. FontanettiDate: 2004-08-24 16:36:18
Subject: Re: [GENERAL] Dump and Restore
Previous:From: Thilina GunasekaraDate: 2004-08-24 15:38:19
Subject: Re: [GENERAL] Dump and Restore

pgsql-general by date

Next:From: Tom LaneDate: 2004-08-24 16:30:57
Subject: Re: Invalid input for integer on VIEW
Previous:From: Tom LaneDate: 2004-08-24 16:17:50
Subject: Re: No connection to a PG 8.0 Beta 1 win32 server

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group