Skip site navigation (1) Skip section navigation (2)

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

From: Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com>
To: "Mcleod, John" <johnm(at)spicergroup(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: What is postgresql status? I'm not sure
Date: 2011-08-26 07:00:48
Message-ID: CAGWYGjUPgRCMNCBiROFjRHLiajguc8D7xqF6KF65_mnJengneQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)spicergroup(dot)com>

> 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"

In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2011-08-26 15:25:22
Subject: Re: problem during installation of pgpool-Admin-3.0.3
Previous:From: Craig RingerDate: 2011-08-26 04:14:25
Subject: Re: Question on Postgres Index internals

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group