pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Serious trouble with my postgresql
2+ messages / 2 participants
[nested] [flat]

* Serious trouble with my postgresql
@ 2004-09-14 10:06  Mário Gamito <gamito@netual.pt>
  0 siblings, 1 reply; 2+ messages in thread

From: Mário Gamito @ 2004-09-14 10:06 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Serious trouble with my postgresql
@ 2004-09-14 14:31  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Mário Gamito <gamito@netual.pt>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-09-14 14:31 UTC (permalink / raw)
  To: Mário Gamito <gamito@netual.pt>; +Cc: pgsql-admin

=?ISO-8859-1?Q?M=E1rio_Gamito?= <gamito@netual.pt> writes:
> Meanwhile, i guess i've screwed up :( and erased two files with 0 bytes, 
> something like 0000000000000001, i can't remember quite well.

That was a bad move.  Start over, and next time don't assume that you
can remove random pieces of the database without consequence.

(You could possibly try pg_resetxlog, but given that you were having
problems before you did that, I wouldn't care to assume that you'll get
a consistent database that way.)

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-09-14 14:31 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-14 10:06 Serious trouble with my postgresql Mário Gamito <gamito@netual.pt>
2004-09-14 14:31 ` Tom Lane <tgl@sss.pgh.pa.us>

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