From: | "Mcleod, John" <johnm(at)spicergroup(dot)com> |
---|---|
To: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
Subject: | What is postgresql status? I'm not sure |
Date: | 2011-08-24 18:09:02 |
Message-ID: | A2FA197FFED9FA42AD080EE933EFA8AE34C58D45@Spicer-mail.spicergroup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jorge Augusto Llamas Caamaño | 2011-08-24 18:51:37 | RV: Recuperar una base de datos en un tablespace en otro servidor |
Previous Message | John R Pierce | 2011-08-24 17:50:58 | Re: postgresql server crash on windows 7 when using plpython |