Re: Database handle destroyed without explicit disconnect

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: peter(at)vfemail(dot)net
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Database handle destroyed without explicit disconnect
Date: 2010-01-27 23:50:55
Message-ID: 16854.1264636255@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

peter(at)vfemail(dot)net writes:
> Maybe. How would I do that? I'm running whatever version of PostgreSQL was current in mid-2004.

2004 was a very long time ago :-(. A quick look at the release history
suggests that you could not be running anything newer than about 7.4.2,
and it could easily be a 7.3.x release or something even older instead.
You really ought to update the server version before expending any
additional thought on this, since the odds are reasonably good that that
crash is something we fixed long since.

Do "select version();" to see exactly what version you have got, and
then see about updating to the latest minor release in that major
release series. Such an update should be relatively painless (no dump
and reload) though it'd still be smart to peruse the release notes to
see if there were any small behavioral changes that might affect your
applications:
http://developer.postgresql.org/pgdocs/postgres/release.html

If you still see the crash on the latest minor version, it'd be worth
probing deeper.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Didier Gasser-Morlay 2010-01-28 06:46:00 PpgSQL Autovacuum
Previous Message peter 2010-01-27 23:23:42 Re: Database handle destroyed without explicit disconnect