pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mário Gamito <gamito@netual.pt>
To: pgsql-admin@postgresql.org
Subject: Serious trouble with my postgresql
Date: Tue, 14 Sep 2004 11:06:42 +0100
Message-ID: <4146C2B2.5080106@netual.pt> (raw)

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



view thread (2+ messages)  latest in thread

Message-ID: <4146C2B2.5080106@netual.pt>
Permalink:  ../4146C2B2.5080106@netual.pt/
Also on:    postgresql.org/message-id/4146C2B2.5080106@netual.pt

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: gamito@netual.pt
  Subject: Re: Serious trouble with my postgresql
  In-Reply-To: <4146C2B2.5080106@netual.pt>
  References: <4146C2B2.5080106@netual.pt>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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