Re: recovery in postgresql

From: Tulio Oliveira <tulio(at)akacia(dot)com(dot)br>
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-20 21:20:43
Message-ID: 3AE0A82B.14F3AFA3@akacia.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)akacia(dot)com(dot)br

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joel Burton 2001-04-20 21:27:58 Re: Views...
Previous Message Christian Marschalek 2001-04-20 20:43:39 Views...