Hi,
My PostgreSQL 7.3 setup seems to crash all versions of pgAdminII (tested
versions : 1.2, 1.4.2, 1.4.12), immediately after pgAdmin2 connects to
the database.
(Connections to pre-7.3 PostgreSQL db's work OK).
I tested this on both WinME and Win2K/SP3, with both an older and the
most recent psqlODBC version (07.02.0005).
PostgreSQL is the version from RedHat RawHide (postgresql-7.3-2). I
tried both my upgraded 7.2 databases, and a freshly created one ('initdb').
Please note I can connect and execute queries using the psql console.
Transcript from a pgAdmin2 connect session :
Dec 22 22:19:12 lmb042 postgres[3041]: [1] LOG: connection received:
host=172.16.117.129 port=1128
Dec 22 22:19:12 lmb042 postgres[3041]: [2] LOG: connection authorized:
user=postgres database=template1
Dec 22 22:19:12 lmb042 postgres[3041]: [3] LOG: query: select version()
Dec 22 22:19:12 lmb042 postgres[3041]: [4] LOG: duration: 0.000920 sec
Dec 22 22:19:12 lmb042 postgres[3041]: [5] LOG: query: set DateStyle to
'ISO'
Dec 22 22:19:12 lmb042 postgres[3041]: [6] LOG: duration: 0.000896 sec
Dec 22 22:19:12 lmb042 postgres[3041]: [7] LOG: query: set geqo to 'OFF'
Dec 22 22:19:12 lmb042 postgres[3041]: [8] LOG: duration: 0.000228 sec
Dec 22 22:19:12 lmb042 postgres[3041]: [9] LOG: query: select oid from
pg_type where typname='lo'
Dec 22 22:19:12 lmb042 postgres[3041]: [10] LOG: duration: 0.002523 sec
Dec 22 22:19:12 lmb042 postgres[3041]: [11] LOG: query: select
pg_client_encoding()
Dec 22 22:19:12 lmb042 postgres[3041]: [12] LOG: duration: 0.000511 sec
Dec 22 22:19:12 lmb042 postgres[3041]: [13] LOG: query: SELECT version()
Dec 22 22:19:12 lmb042 postgres[3041]: [14] LOG: duration: 0.002683 sec
Dec 22 22:19:12 lmb042 postgres[3041]: [15] LOG: query: SELECT
datlastsysoid FROM pg_database WHERE datname = 'template1'
Dec 22 22:19:12 lmb042 postgres[3041]: [16] LOG: duration: 0.005259 sec
Dec 22 22:19:17 lmb042 postgres[3041]: [17] LOG: pq_recvbuf: recv()
failed: Connection reset by peer
Executing query [15] in psql yields :
template1=# SELECT datlastsysoid FROM pg_database WHERE datname =
'template1';
datlastsysoid
---------------
16974
(1 row)
HTH.
This is a major PITA, as I expected to migrate my Access2000 database to
PostgreSQL 7.3. :-/
Kind regards,
Didier
--
Didier Moens
-----
RUG/VIB - Dept. Molecular Biomedical Research - Core IT
tel ++32(9)2645309 fax ++32(9)2645348
http://www.dmb.rug.ac.be