Re: What is postgresql status? I'm not sure

[Lukasz Brodziak <lukasz.brodziak@xxxxxxxxx>]

First thing to check is wether the postmaster.pid file has been created in data folder. If so try to log into the server using pgAdmin (if You don't know the password to the server You can change authentication mode to trust in pg_hba.conf file). If not go to event viewer:

1. Click Start, and then click Control Panel. Click Performance and Maintenance, then click Administrative Tools, and then double-click Computer Management. Or, open the MMC containing the Event Viewer snap-in.
2. In the console tree, click Event Viewer. 

And look for eny errors regarding PostgreSQL. Feel free to post any of the errors here to find further support.

2011/8/24 Mcleod, John <johnm@xxxxxxxxxxxxxxx>

Hello all,

Don't shoot me, I'm just the fella sweeping up after a departure.

I'm supporting a web site with mapping features using Mapserver and PostgreSql 7.5 for windows.

Recently, my mapping features went down.

Error messages that display are the following…

 

 

Warning: pg_query(): Query failed: ERROR: xlog flush request 0/34D85078 is not satisfied --- flushed only to 0/34CD4518 CONTEXT: writing block 0 of relation 394198/412173 in C:\ms4w\Apache\htdocs\davison\mapping\gis1\viewparcel_nolink.php on line 10

 

Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource in C:\ms4w\Apache\htdocs\davison\mapping\gis1\viewparcel_nolink.php on line 12

 

 

It looks to me that the query failed based on a hard drive issue.  Well, over the weekend we swapped out the hard drive for new.  The site comes back fine but I'm still receiving the error. 

 

Another notice is when I shutdown and restart the database, I get this…

 

C:\ms4w\apps\pgsql75win>cd c:\

 

C:\>cd ms4w/apps/pgsql75win/data/

 

C:\ms4w\apps\pgsql75win\data>del postmaster.pid

Could Not Find C:\ms4w\apps\pgsql75win\data\postmaster.pid

LOG:  database system was shut down at 2011-08-24 17:30:14 Eastern Standard Time

 

LOG:  checkpoint record is at 0/34CD4078

LOG:  redo record is at 0/34CD4078; undo record is at 0/0; shutdown TRUE

LOG:  next transaction ID: 1198832; next OID: 1772830

LOG:  database system is ready

 

 

I'm not sure if the database is up or not.

I don't even see postgresql or mapserver as Windows services.

I'm very confused.

 

Thank you for any help with this continuing problem.

 

John

-- 
Łukasz Brodziak
"Do you bury me when I'm gone
Do you teach me while I'm here
Just as soon I belong
Then it's time I disappear"