Thread: recovery in postgresql

Hi,

How to do recovery in postgreSQL?
i have looked in manual, but there's nothing there
would someone show me how to recovery?

TIA
Didi

On Sat, 21 Apr 2001, Muhammad Rusydi wrote:

> Hi,
>
> How to do recovery in postgreSQL?
> i have looked in manual, but there's nothing there
> would someone show me how to recovery?
>

What exactly are you recovering from?

THe way I have recovered when need was:

dropdb <brokendb>
createdb <brokendb>
cat database_backup_file | psql <brokendb>

Where database_backup_file is the file produced by
dbdump.

HTH,

Benno

Muhammad Rusydi wrote:
>
> Hi,
>
> How to do recovery in postgreSQL?
> i have looked in manual, but there's nothing there
> would someone show me how to recovery?
>
> TIA
> Didi
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html


Backup all yours data bases with
pg_dumpall > backup.sql   (or another name)

and recover this way...
psql template1 -f backup.sql


And all your Data Bases will be restored, with all datas...

Regards,

Tulio


--
Tulio Oliveira
Akácia Tecnologia
www.akacia.com.br
tulio@akacia.com.br