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 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. Looks like somebody deleted critical files to get some space back. > Can anyone help us ? Find the most recent backup ... -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
