From: | peter(at)vfemail(dot)net |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Database handle destroyed without explicit disconnect |
Date: | 2010-02-06 14:11:36 |
Message-ID: | 20100206142521.7C6D06325CB@mail.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
It took me a week to figure out how to figure out how and where to enter that "select version();" command.
I've figured out that I am running PostgreSQL 7.4.3 on i386-portbld-freebsd4.10, compiled by GCC 2.95.4.
I'm guessing, after looking at <http://www.postgresql.org/>http://www.postgresql.org/ that I should upgrade to Version 7.4.27, correct? This upgrade won't confuse old shell, PHP and Perl scripts or otherwise confuse FreeBSD, correct?
Can you point me to novice-friendly step-by-step instructions?
--------
At 06:50 PM 1/27/2010, Tom Lane wrote:
>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 | peter | 2010-02-06 15:08:50 | Incomplete pg_dump operation |
Previous Message | Mladen Gogala | 2010-02-05 23:07:57 | Re: trouble with an older version of postgresql |