X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BDAF5329E4B for ; Tue, 14 Sep 2004 11:06:55 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84446-07 for ; Tue, 14 Sep 2004 10:06:50 +0000 (GMT) Received: from mail.netual.pt (unknown [62.48.217.134]) by svr1.postgresql.org (Postfix) with SMTP id 15B53329E23 for ; Tue, 14 Sep 2004 11:06:49 +0100 (BST) Received: (qmail 15191 invoked by uid 509); 14 Sep 2004 10:06:55 -0000 Received: from gamito@netual.pt by submarino by uid 0 with qmail-scanner-1.22 (f-prot: 4.4.1/3.14.11. spamassassin: 2.63. Clear:RC:1(10.10.2.101):. Processed in 0.351397 secs); 14 Sep 2004 10:06:55 -0000 Received: from unknown (HELO ?10.10.2.101?) (10.10.2.101) by 0 with SMTP; 14 Sep 2004 10:06:53 -0000 Message-ID: <4146C2B2.5080106@netual.pt> Date: Tue, 14 Sep 2004 11:06:42 +0100 From: =?ISO-8859-1?Q?M=E1rio_Gamito?= User-Agent: Mozilla Thunderbird 0.7.3 (X11/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Serious trouble with my postgresql X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/121 X-Sequence-Number: 14824 Hi, After i've imported a text file into postgresql, apparently with success, because it responded "COPY", postgresql died after i left its prompt and never restarted again. Meanwhile, i guess i've screwed up :( and erased two files with 0 bytes, something like 0000000000000001, i can't remember quite well. Now, if i run as user postgres the command: # [postgres@nau pg_xlog]$ /usr/bin/postmaster -D /usr/bin/postmaster -D /var/lib/pgsql/data i get this error: "LOG: could not create IPv6 socket: Address family not supported by protocol LOG: database system was shut down at 2004-09-08 16:09:16 WEST LOG: could not read from log file 0, segment 1 at offset 4153344: Success LOG: invalid primary checkpoint record LOG: could not read from log file 0, segment 1 at offset 4112384: Success LOG: invalid secondary checkpoint record PANIC: could not locate a valid checkpoint record LOG: startup process (PID 15082) was terminated by signal 6 LOG: aborting startup due to startup process failure [postgres@nau pg_xlog]$" Is this recoverable ? At least, can i recever the contents of the databases (remember i cannot start postgresql) in some way, so i can reinstall postgresql from scratch and insert the databases again ? How ? Any help would be appreciated. Warm Regards, Mário Gamito