Re: R: [ADMIN] Need help to restore database

2009-03-17 Thread Ray Stell
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

R: [ADMIN] Need help to restore database

2009-03-17 Thread Lori, Giancarlo
@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 me

Re: [ADMIN] Need help to restore database

2009-03-17 Thread Simon Riggs
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

Re: [ADMIN] Need help to restore database

2009-03-17 Thread Ray Stell
On Tue, Mar 17, 2009 at 12:01:01PM +0100, ad...@informatyka.gdansk.pl wrote: > On Tue, 17 Mar 2009 09:50:55 +0100, "Lori, Giancarlo" > wrote: > > 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.

Re: [ADMIN] Need help to restore database

2009-03-17 Thread Alvaro Herrera
Lori, Giancarlo wrote: > 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 crash

Re: [ADMIN] Need help to restore database

2009-03-17 Thread adamr
On Tue, 17 Mar 2009 09:50:55 +0100, "Lori, Giancarlo" wrote: > Hi all, > 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 >

[ADMIN] Need help to restore database

2009-03-17 Thread Lori, Giancarlo
Hi all, 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) w