Re: recovery in postgresql

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