Re: recovery in postgresql

From: Ben Leslie <benno(at)sesgroup(dot)net>
To: Muhammad Rusydi <rusydi(at)cbn(dot)net(dot)id>
Cc: postgres general <pgsql-general(at)postgresql(dot)org>
Subject: Re: recovery in postgresql
Date: 2001-04-21 04:41:32
Message-ID: 20010421144132.A30560@sesgroup.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Poet/Joshua Drake 2001-04-21 05:30:39 Terra Soft to Include LXP with YDL 2.0
Previous Message August Zajonc 2001-04-21 03:49:18 Sourceforge PG crash