dump from /var/lib/postgresql to recovery

From: Dario Fadda <dario(at)promotux(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: dump from /var/lib/postgresql to recovery
Date: 2007-11-07 15:19:14
Message-ID: 4731D772.2000003@promotux.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
i've a database that work perfectly until yesterday, that when i try to
access into database from every commands like:
"psql -U postgres db_name"
Postgresql gives me an error:
"server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
"
This happens only when i try to access into this database, because when
i try to access into "template1" database it works perfectly, without
errors.

My question is this: There is a method to recovery, dump, check... or
other, my database from "/var/lib/postgresql" cluster directory, without
using service/daemon applications?

Thank you.

--
Area tecnica - Dario Fadda
Promotux Informatica
Via G. Deledda, 40
09047 - Selargius (CA)
Tel. 0708474056
www.promotux.it
assistenza(at)promotux(dot)it

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Steben 2007-11-07 20:34:55 Maintenance_work_mem question
Previous Message rloefgren 2007-11-07 14:01:44 Re: Source of pgpool2 manual