Postgres Pro
Downloads
Home   >   mailing lists

Postgres startup - Mailing list pgsql-novice

From Andy Dunlop
Subject Postgres startup
Date
Msg-id 425A944C.4030001@infocus.co.za
Whole thread Raw
Responses Re: Postgres startup  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
After using the following:

nohup postmaster -i -D /var/lib/pgsql/data >logfile 2>&1 </dev/null &


I get this in the logfile:

DEBUG:  database system shutdown was interrupted at 2005-04-11 16:09:06 SAST
DEBUG:  ReadRecord: invalid resource manager id 155 at 0/766DB9C
DEBUG:  invalid primary checkpoint record
DEBUG:  ReadRecord: invalid resource manager id 159 at 0/766DB5C
DEBUG:  invalid secondary checkpoint record
FATAL 2:  unable to locate a valid checkpoint record
DEBUG:  startup process (pid 13807) exited with exit code 2
DEBUG:  aborting startup due to startup process failure
[1]+  Exit 1                  nohup postmaster -i -D /var/lib/pgsql/data
 >logfile 2>&1 </dev/null

Is there any way to get the db running?

Thanks
Andy

pgsql-novice by date:

Previous
From: Leena JAIN
Date:
Subject: Migration of postgres 7.3 to postgres 7.4 from one server to another server
Next
From: stig erikson
Date:
Subject: Re: what is command to view data inside the table