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