Thread: swith version use, can't connect to database
hello, I have some trouble to connect to a database with the versions 1.14.1, 1.14.0 and 1.12 of pgAdmin III but the connection is ok with v1.8 and v1.10.5 log : 2012-01-27 09:43:57 INFO : Attempting to create a connection object... 2012-01-27 09:43:57 STATUS : Connexion à la base de données... 2012-01-27 09:43:57 INFO : Opening connection with connection string: host='localhost' dbname='postgres' user='postgres' password='XXXXXX' port=10031 sslmode=disable application_name='pgAdmin III - Navigateur' 2012-01-27 09:43:57 STATUS : Connexion à la base de données... (0,29 secondes) 2012-01-27 09:43:57 ERROR : Error connecting to the server:
On Fri, 2012-01-27 at 10:24 +0100, romain rolland wrote: > hello, > > I have some trouble to connect to a database with the versions 1.14.1, > 1.14.0 and 1.12 of pgAdmin III > but the connection is ok with v1.8 and v1.10.5 > > log : > > 2012-01-27 09:43:57 INFO : Attempting to create a connection object... > 2012-01-27 09:43:57 STATUS : Connexion à la base de données... > 2012-01-27 09:43:57 INFO : Opening connection with connection > string: host='localhost' dbname='postgres' user='postgres' > password='XXXXXX' port=10031 sslmode=disable application_name='pgAdmin > III - Navigateur' > 2012-01-27 09:43:57 STATUS : Connexion à la base de données... (0,29 secondes) > 2012-01-27 09:43:57 ERROR : Error connecting to the server: > The most interesting thing to know would be the error message. "Error connecting to the server" doesn't give us any clue to be able to help you. What appears after this message in the log? Do you have anything recorded in PostgreSQL log files? -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.postgresql-sessions.org
nothing after this message I have try this morning and I have the same issue 2012-01-30 14:58:26 INFO : Attempting to create a connection object... 2012-01-30 14:58:31 STATUS : Connexion à la base de données... 2012-01-30 14:58:31 INFO : Opening connection with connection string: host='localhost' dbname='postgres' user='postgres' password='XXXXXX' port=10067 sslmode=disable application_name='pgAdmin III - Navigateur' 2012-01-30 14:58:31 STATUS : Connexion à la base de données... (0,27 secondes) 2012-01-30 14:58:31 ERROR : Error connecting to the server: maybe it's when I try to connect to 8.2.9 database On Fri, Jan 27, 2012 at 11:34 AM, Guillaume Lelarge <guillaume@lelarge.info> wrote: > On Fri, 2012-01-27 at 10:24 +0100, romain rolland wrote: >> hello, >> >> I have some trouble to connect to a database with the versions 1.14.1, >> 1.14.0 and 1.12 of pgAdmin III >> but the connection is ok with v1.8 and v1.10.5 >> >> log : >> >> 2012-01-27 09:43:57 INFO : Attempting to create a connection object... >> 2012-01-27 09:43:57 STATUS : Connexion à la base de données... >> 2012-01-27 09:43:57 INFO : Opening connection with connection >> string: host='localhost' dbname='postgres' user='postgres' >> password='XXXXXX' port=10031 sslmode=disable application_name='pgAdmin >> III - Navigateur' >> 2012-01-27 09:43:57 STATUS : Connexion à la base de données... (0,29 secondes) >> 2012-01-27 09:43:57 ERROR : Error connecting to the server: >> > > The most interesting thing to know would be the error message. "Error > connecting to the server" doesn't give us any clue to be able to help > you. What appears after this message in the log? Do you have anything > recorded in PostgreSQL log files? > > > -- > Guillaume > http://blog.guillaume.lelarge.info > http://www.dalibo.com > PostgreSQL Sessions #3: http://www.postgresql-sessions.org >
On Mon, 2012-01-30 at 15:03 +0100, romain rolland wrote: > nothing after this message > I have try this morning and I have the same issue > 2012-01-30 14:58:26 INFO : Attempting to create a connection object... > 2012-01-30 14:58:31 STATUS : Connexion à la base de données... > 2012-01-30 14:58:31 INFO : Opening connection with connection > string: host='localhost' dbname='postgres' user='postgres' > password='XXXXXX' port=10067 sslmode=disable application_name='pgAdmin > III - Navigateur' > 2012-01-30 14:58:31 STATUS : Connexion à la base de données... (0,27 secondes) > 2012-01-30 14:58:31 ERROR : Error connecting to the server: > > maybe it's when I try to connect to 8.2.9 database > pgAdmin surely shows you an error message. What does it say? -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.postgresql-sessions.org
On Mon, 2012-01-30 at 17:16 +0100, romain rolland wrote: > It just show me a popup with the following text : > > >Une erreur s'est produite : > > > >Error connecting to the server: > > And in the postgresql log files? If you cannot tell me the error message, there's nothing I can do to fix something here. PS : please stop top posting. It makes it hard to follow the thread. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.postgresql-sessions.org
On Mon, 2012-01-30 at 17:32 +0100, romain rolland wrote: > on the server side I have the following message in the postgresql log file > > > 2012-01-30 17:30:55 FATAL: unrecognized configuration parameter > "application_name" > OK. 1.12 and 1.14 use the new application_name connection parameter. Every recent PostgreSQL branch knows this connection parameter, but you need the right minor release. 8.2.9 is definitely prior to the right release. You need at least 8.2.15. PS : reply to the list, and stop top posting. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.postgresql-sessions.org
It just show me a popup with the following text : >Une erreur s'est produite : > >Error connecting to the server: On Mon, Jan 30, 2012 at 5:09 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote: > On Mon, 2012-01-30 at 15:03 +0100, romain rolland wrote: >> nothing after this message >> I have try this morning and I have the same issue >> 2012-01-30 14:58:26 INFO : Attempting to create a connection object... >> 2012-01-30 14:58:31 STATUS : Connexion à la base de données... >> 2012-01-30 14:58:31 INFO : Opening connection with connection >> string: host='localhost' dbname='postgres' user='postgres' >> password='XXXXXX' port=10067 sslmode=disable application_name='pgAdmin >> III - Navigateur' >> 2012-01-30 14:58:31 STATUS : Connexion à la base de données... (0,27 secondes) >> 2012-01-30 14:58:31 ERROR : Error connecting to the server: >> >> maybe it's when I try to connect to 8.2.9 database >> > > pgAdmin surely shows you an error message. What does it say? > > > -- > Guillaume > http://blog.guillaume.lelarge.info > http://www.dalibo.com > PostgreSQL Sessions #3: http://www.postgresql-sessions.org >