Re: Need help to restore database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 2009-03-17 at 09:50 +0100, Lori, Giancarlo wrote:

> we are facing with a struggle problem with PostgreSql database
> production. 
> 
> A client system based on pgsql is down because the database raise an
> error message like “ no left space on device”. We have deleted some
> log files on this machine and after a system restart the db (and the
> system) was up&running. After two days the database has crashed again.
> Looking the postgres log there was an error on xlog file (I have
> inspected the directory pg_xlog and no files I found it). I’ll try to
> re-build the xlog file with pg_resetxlog. The utilities has created a
> new xlog file, the postmaster process run, but any command pg_dump,
> etc I try to execute failed. The system respond that there are not
> database in the system. Can anyone help us ?

2ndQuadrant has a lot of experience with helping people out with
problems like this, including data recovery from damaged databases.
Please let us know if we can be of any help. Apologies for mentioning
commercial matters on list, though this work helps fund further
developments in this area.

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux