Unable to start postgres 8.0 after bad shut down

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

Unable to start postgres 8.0 after bad shut down

Postby Tracing » Mon May 11, 2009 1:03 am

I am unable to start postgresql. I cannot start it from PT2 or from pgAdmin III not can I start the service. I am using postgres 8.0 on an XP.

Here is a copy of the log file attempting to start ipostgres:

2009-05-11 00:31:48 LOG: database system was interrupted while in recovery at 2009-05-10 02:14:05 Eastern Daylight Time
2009-05-11 00:31:48 HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2009-05-11 00:31:49 LOG: checkpoint record is at 33/71533738
2009-05-11 00:31:49 LOG: redo record is at 33/71533738; undo record is at 0/0; shutdown FALSE
2009-05-11 00:31:49 LOG: next transaction ID: 49470763; next OID: 2410317
2009-05-11 00:31:49 LOG: database system was not properly shut down; automatic recovery in progress
2009-05-11 00:31:49 LOG: redo starts at 33/71533778
2009-05-11 00:32:02 PANIC: could not read block 574 of relation 1663/1312090/1916124: Permission denied

This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
2009-05-11 00:32:02 LOG: startup process (PID 2700) was terminated by signal 3
2009-05-11 00:32:02 LOG: aborting startup due to startup process failure
2009-05-11 00:32:03 LOG: logger shutting down

What can I do to fix the problem?
Tracing
 
Posts: 7
Joined: Tue May 20, 2008 10:45 pm

Re: Unable to start postgres 8.0 after bad shut down

Postby ptrack pat » Mon May 11, 2009 8:51 am

Go to the c:\program files\postgresql\8.0\data folder. Is there a file called postmaster.pid there? If so, delete that file and then try to restart the service.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Unable to start postgres 8.0 after bad shut down

Postby Tracing » Mon May 11, 2009 9:05 am

ptrack pat wrote:Go to the c:\program files\postgresql\8.0\data folder. Is there a file called postmaster.pid there? If so, delete that file and then try to restart the service.


There is no file called postmaster.pid in c:\program files\postgresql\8.0\data or in any subdirectory of c:\program files\postgresql\8.0\.
Tracing
 
Posts: 7
Joined: Tue May 20, 2008 10:45 pm

Re: Unable to start postgres 8.0 after bad shut down

Postby ptrack pat » Mon May 11, 2009 12:19 pm

I don't know what else to tell you then. When was the last time you backed up this database?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Unable to start postgres 8.0 after bad shut down

Postby Tracing » Mon May 11, 2009 2:47 pm

If have a collection of databases, of which only two are active. My oldest backup is about one week old, so if I could restore my data, I would be okay. A problem is that I cannot restore anything because I postgres finds a bad block and asks to be terminated.

Does anyone know what this
"block 574 of relation 1663/1312090/1916124"
means? What is block 574 of relation 1663/1312090/1916124?

Does relation 1663/1312090/1916124 refer to a database? Which one? How can one find out?

How can I get postgres to skip its restore process?
Tracing
 
Posts: 7
Joined: Tue May 20, 2008 10:45 pm

Re: Unable to start postgres 8.0 after bad shut down

Postby ptrack pat » Mon May 11, 2009 3:30 pm

I'm not certain what those numbers mean, PostgreSQL isn't very intuitive in that way. Given that the service won't even start, it may be the error is with one of the PostgreSQL db system files and not with one of your PT databases.

What I would suggest is you install PostgreSQL 8.2, you can find a download file here...

http://www.postgresql.org/ftp/binary/v8.2.13/win32/

Then in PT, open the Utilities > PostgreSQL Settings window and add an entry for the 8.2 install there and then use the Utilities > PostgreSQL Database Functions window to try to do the restore of your database into 8.2 (you can restore an 8.0 db into 8.2 with no problems).
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm


Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 0 guests

cron