From: | Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | pgAdmin hangs |
Date: | 2012-02-28 09:10:34 |
Message-ID: | CAD8_Uca_JApKP94LoYQRfMdajtN3NSWr5XrDp+q4CT9fqi4m1Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
hi,
I've tried to open SQL query tool using SQL button to see table definition
(Copy SQL from main window to query tool = TRUE) , but pgAdmin does not
reply.
Using other instance of pgAdmin on server side, I can see new process is
started for Query Tool (status <IDLE>) in server status window.
agAdmin logs:
2012-02-28 09:30:40 INFO : Opening connection with connection string:
host='myHost' dbname='myDB' user='postgres' password='XXXXXX' port=5432
sslmode=require application_name='pgAdmin III - Narzędzie Zapytania'
2012-02-28 09:30:41 QUERY : Scalar query (myHost:5432): SELECT version();
2012-02-28 09:30:41 QUERY : Query result: PostgreSQL 9.1.3, compiled by
Visual C++ build 1500, 64-bit
2012-02-28 09:30:41 QUERY : Set query (myHost:5432): SET DateStyle=ISO;
SET bytea_output=escape;
SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
FROM pg_database WHERE oid = 16651
2012-02-28 09:30:41 INFO : Setting client_encoding to 'UNICODE'
2012-02-28 09:30:41 SCRIPT : Application created
server logs (server is localized to polish):
2012-02-28 09:30:40.986 CET|[nieznany]||[nieznany]|[nieznany]|2844
DZIENNIK: odebrano połączenie: host=myHost.mydomain.pl port=54269
2012-02-28 09:30:41.016 CET|[nieznany]|myHost.mydomain.pl|postgres|myDB|2844
DZIENNIK: zautoryzowano połączenie: użytkownik=postgres baza danych=myDB
2012-02-28 09:30:41.021 CET|pgAdmin III - Narz??dzie Zapytania|myHost.
mydomain.pl|postgres|myDB|2844 DZIENNIK: wyraĹĽenie: SELECT version();
2012-02-28 09:30:41.025 CET|pgAdmin III - Narz??dzie Zapytania|myHost.
mydomain.pl|postgres|myDB|2844 DZIENNIK: wyraĹĽenie: SET DateStyle=ISO;
SET bytea_output=escape;
SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
FROM pg_database WHERE oid = 16651
2012-02-28 09:30:41.030 CET|pgAdmin III - Narz??dzie Zapytania|myHost.
mydomain.pl|postgres|myDB|2844 DZIENNIK: wyraĹĽenie: set client_encoding
to 'UNICODE'
I can't see nothing special in logs.
I tried to restart pgAdmin - same scenario every time, pgAdmin hangs when
SQL button is clicked.
SQL pane works fine - shows table definition, problem occurs for other
objects too (e.g. function, schema, operator). Strange thing for me is that
this works fine on server (pgAdmin 1.14.2 on Windows Server - installed
with new version of PostgreSQL)
pgAdmin 1.14.2 Windows 7 32 bit - installed outside server bundle
Server: 9.1.3 on Windows Server 2008 R2 64 bit.
Regards,
Bartek
From | Date | Subject | |
---|---|---|---|
Next Message | sbremal | 2012-02-28 10:33:08 | Re: pg_dump.exe - quotation marks in schema names |
Previous Message | Bartosz Dmytrak | 2012-02-28 08:22:05 | feature request - show role members |