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