Re: Trouble with Connection

Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> Robby Tanner wrote:
>> I think the server engine is Postgres95.

> The current odbc driver doesn't support Postgres95.

I'm amazed there are still any running copies of Postgres95.  Are you
holding it till the Smithsonian comes for it?  :-)

Anyway, you should certainly not think in terms of using ODBC for an
upgrade.  pg_dump, install new version, run pg_dump script is the thing
to do.  Be advised that Postgres95 -> current is a large jump.  There is
probably no hope that your dump script will load without manual editing.
(If the PG95 pg_dump supports dumping schema and data separately, I'd
advise doing it that way, since your editing will probably all be of
the schema declarations.)

            regards, tom lane