recovery in postgresql

Поиск
Список
Период
Сортировка
Искать

recovery in postgresql

От:
"Muhammad Rusydi" <rusydi@cbn.net.id>
Дата:
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

Re: recovery in postgresql

От:
Ben Leslie <benno@sesgroup.net>
Дата:
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 
createdb 
cat database_backup_file | psql 

Where database_backup_file is the file produced by
dbdump.

HTH,

Benno

Re: recovery in postgresql

От:
Tulio Oliveira <tulio@akacia.com.br>
Дата:
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
FAQ