Re: Dump and Restore

From: Secrétariat <ets(at)rolland-fr(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dump and Restore
Date: 2004-08-24 13:57:03
Message-ID: 005901c489e2$3cc51660$0a00a8c0@lrp43008
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

One way is to create another instance of your PG server,
using a different PGDATA path.
So your actual data won't be overwriten.

Luc

> 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
> sometime?
>
> Thanks for all of you!
>
> Eduardo S. Fontanetti
>
>
>
>
>
> _______________________________________________________
> Yahoo! Acesso Grátis - navegue de graça com conexão de qualidade!
> http://br.acesso.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Antonis Antoniou 2004-08-24 14:47:03 Re: pg dump restore
Previous Message Eduardo S. Fontanetti 2004-08-24 13:40:32 Dump and Restore

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2004-08-24 13:57:09 Re: Unsupported 3rd-party solutions (Was: Few questions
Previous Message Josué Maldonado 2004-08-24 13:56:48 Re: pg_dump/psql fails on win32 beta 8.0