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

Re: [GENERAL] Error message

From: James Olin Oden <joden(at)Lee(dot)k12(dot)nc(dot)us>
To: Kevin Heflin <kheflin(at)shreve(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Error message
Date: 1998-06-29 12:24:34
Message-ID: 81Jun28.071644edt.35713@gateway.lee.k12.nc.us (view raw or flat)
Thread:
Lists: pgsql-general
> I was working in the psql command line on a particular database, when
> things started to work real slow??
>
> Afterwards, I noticed when ever I tried executing anything on a different
> database, I was receiving the follow error message.. pertaining to the
> original database I had been working on previously:
>
> WARNING: Unable to connect to PostgresSQL server: ERROR cannont write
> block 431 of users [shrevenet_linklist] blind in
> /pathtofilename/file.php3 on line 4
> An error occurred.
>
> the first two links of this error are referencing the origal database I
> had been working in. The last two are in reference to the database I was
> trying to access just now.
>
> Any suggestions to reason for this? And suggestions on how to track down
> such an error? or someway to monitor in real time the POstgres server?
>
> Any suggestions would be appreciated.
>
> Kevin

Kevin,

Have you tried killing the postmaster process and restarting.  It sounds like
something gone south in it or more likely a back end postgress process has
got hung.  Anyway, killing the postmaster process should get rid of child
processes also, and when you restart it everything should be OK with your
database.  This is just a hunch but I think it will fix your immeadiate
problem.

As to why its happening, your going to have get someone much more familiar
with the source than I to answer that.

...james


In response to

pgsql-general by date

Next:From: James Olin OdenDate: 1998-06-29 12:29:23
Subject: Re: [GENERAL] vacuuming
Previous:From: Roman VolkoffDate: 1998-06-29 09:57:32
Subject: unsubscribe

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