Backup / Restore

From: Eduardo S(dot) Fontanetti <dufuzzy(at)yahoo(dot)com(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: Backup / Restore
Date: 2004-06-23 11:40:34
Message-ID: 20040623114034.29844.qmail@web40705.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

What is the most recommended way to backup a
PostgreSQL database?

And to restore it?

I would like to get ALL the data and properties
possible, because if I have a problem, and I lost my
current database, I can just restore it, and will be
all exactly like was before.

What is the best way? pg_dump? If yes, what options I
need to use?

Thanks a lot!!

Eduardo S. Fontanetti

______________________________________________________________________

Yahoo! Mail - agora com 100MB de espaço, anti-spam e antivírus grátis!
http://br.info.mail.yahoo.com/

Responses

  • Re: Backup / Restore at 2004-06-23 13:27:57 from V i s h a l Kashyap @ [Sai Hertz And Control Systems]

Browse pgsql-admin by date

  From Date Subject
Next Message juanmime 2004-06-23 11:43:25 Asunto: Re: Problems restoring a DB with oids
Previous Message juanmime 2004-06-23 10:27:11 Asunto: Re: Problems restoring a DB with oids