[GENERAL] What is postgresql status?

2011-08-24 Thread Mcleod, John
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

Re: [GENERAL] pgsql error

2011-07-26 Thread Mcleod, John
When I go to "C:\ms4w\apps\pgsql75win\bin" in the command line, and run "postgres --version", I get the following... "postgres (PostgreSQL) 7.5devel" John -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Tuesday, July 26, 20

Re: [GENERAL] pgsql error

2011-07-26 Thread Mcleod, John
John -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Monday, July 25, 2011 11:20 PM To: Merlin Moncure Cc: Mcleod, John; pgsql-general@postgresql.org Subject: Re: [GENERAL] pgsql error Merlin Moncure writes: > On Mon, Jul 25, 2011 at 3:05 PM, Mcleod, John w

[GENERAL] pgsql error

2011-07-25 Thread Mcleod, John
Hello all, I'm new to pgsql and I'm taking over for a project manager that left the company. I'm receiving the following error... CONTEXT: writing block 614 of relation 394198/412175 WARNING: could not write block 614 of 394198/412175 DETAIL: Multiple failures --- write error may be permanent. ER