ODBC message "server closed the connection unexpectedly" when accessing a PG/11.3 DB

From: David Gauthier <davegauthierpg(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: ODBC message "server closed the connection unexpectedly" when accessing a PG/11.3 DB
Date: 2021-02-14 00:09:23
Message-ID: CAMBRECCwBgePSp=6ixuJ84ptHdOpOOb47LhCic08Y1mkbGFvEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We are using MS-Access as a front-end to work with tables served by
a Postrges/11.3 DB on linux as the MS-Access backend through ODBC. I have
my users install on their Windows laptops a PG driver for ODBC from here...
https://www.postgresql.org/ftp/odbc/versions/msi and selecting
psqlodbc-12_02_0000.zip. This setup seems to work fine for me. However...

I have a user who got a "server closed the connection unexpectedly" after
trying the "Test Connection" feature in ODBC. The "server closed the
connection". Hmmmmm.... . Is this saying that the user was connected, then
the connection was closed ?

I'm not the DB Admin but I had them give me the contents of the instance
log for the time period in question. There's nothing in there that would
indicate that the server closed a connection.

This user is on the other side of the world and there's a possibility that
a firewall is in play. But I wouldn't expect to see a closed connection
error for something like that. More like a message saying that it couldn't
make the connection in the first place.

I asked the user to recreate the error while running the Tracing facility
in ODBC, then send me the logs. But in the meantime, has anyone heard of
problems like this using ODBC (on Windows if that matters) ?

Thanks in Advance !

Browse pgsql-general by date

  From Date Subject
Next Message Seamus Abshere 2021-02-14 03:10:43 700% faster (was: Re: Why is Postgres only using 8 cores for partitioned count? [Parallel append])
Previous Message Seamus Abshere 2021-02-14 00:09:11 Re: Why is Postgres only using 8 cores for partitioned count? [Parallel Append]