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