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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
- Re: [pgadmin-support] pgAdminII 1.4.12 crash with PostgreSQL ... Didier Moens
