pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedR: Need help to restore database
2+ messages / 2 participants
[nested] [flat]
* R: Need help to restore database
@ 2009-03-17 14:27 Lori, Giancarlo <giancarlo.lori@eds.com>
0 siblings, 1 reply; 2+ messages in thread
From: Lori, Giancarlo @ 2009-03-17 14:27 UTC (permalink / raw)
To: Simon Riggs <simon@2ndQuadrant.com>; +Cc: pgsql-admin
Thanks to all, I have solved, I have been able to restart the Postgres db, and then after a pg-dump I have created a new one.
Thanks again
-----Messaggio originale-----
Da: Simon Riggs [mailto:simon@2ndQuadrant.com]
Inviato: martedì 17 marzo 2009 15.10
A: Lori, Giancarlo
Cc: pgsql-admin@postgresql.org
Oggetto: Re: [ADMIN] Need help to restore database
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: R: Need help to restore database
@ 2009-03-17 14:39 Ray Stell <stellr@cns.vt.edu>
parent: Lori, Giancarlo <giancarlo.lori@eds.com>
0 siblings, 0 replies; 2+ messages in thread
From: Ray Stell @ 2009-03-17 14:39 UTC (permalink / raw)
To: Lori, Giancarlo <giancarlo.lori@eds.com>; +Cc: Simon Riggs <simon@2ndQuadrant.com>; pgsql-admin
On Tue, Mar 17, 2009 at 03:27:42PM +0100, Lori, Giancarlo wrote:
> Thanks to all, I have solved, I have been able to restart the Postgres db, and then after a pg-dump I have created a new one.
> Thanks again
I'd like to learn from your experience. Perhaps you would be willing to
expand on the events and your actions.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2009-03-17 14:39 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-03-17 14:27 R: Need help to restore database Lori, Giancarlo <giancarlo.lori@eds.com>
2009-03-17 14:39 ` Ray Stell <stellr@cns.vt.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox