Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 4F60C9FB551 for ; Wed, 7 Nov 2007 11:16:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 10414-06-3 for ; Wed, 7 Nov 2007 11:16:15 -0400 (AST) Received: from mail.promotux.lab (217-133-70-144.b2b.tiscali.it [217.133.70.144]) by postgresql.org (Postfix) with ESMTP id 352039F94A2 for ; Wed, 7 Nov 2007 11:16:21 -0400 (AST) Received: from [192.168.0.207] (unknown [192.168.0.207]) by mail.promotux.lab (Postfix) with ESMTP id 79B7E51406E for ; Wed, 7 Nov 2007 16:20:29 +0100 (CET) Message-ID: <4731D772.2000003@promotux.it> Date: Wed, 07 Nov 2007 16:19:14 +0100 From: Dario Fadda User-Agent: Thunderbird 2.0.0.6 (X11/20071008) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: dump from /var/lib/postgresql to recovery Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.101 tagged_above=0 required=5 tests=BAYES_50=0.001, RDNS_DYNAMIC=0.1 X-Spam-Level: X-Archive-Number: 200711/63 X-Sequence-Number: 27306 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@promotux.it