Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread Shaun Thomas
On 10/19/2012 09:38 AM, GMAIL wrote: but if i connect from another pc, with pgadmin 1.16 or other software, to the host with postgresql i get a "connection refused" message Ok. That narrows it down slightly. If you check your PG logs for FATAL messages, and you don't see anything complaining

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread Shaun Thomas
On 10/19/2012 09:52 AM, GMAIL wrote: using ping i receive a connection timed out Yep. You've got a firewall between you and your server. Somewhere. Good luck tracking that down, sir. Everything should clear up when/if that gets resolved. -- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd.

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread Raymond O'Donnell
On 19/10/2012 15:38, GMAIL wrote: > Il 19/10/2012 16:33, Shaun Thomas ha scritto: >> >> If you don't get any error message from the client or the server, are >> you sure it didn't work? >> >> I only ask because 1.8 was so old, I'm surprised it even worked with >> the version you had before. The cat

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread Shaun Thomas
On 10/19/2012 09:59 AM, GMAIL wrote: i think that the problem should be the service iptables. what i have to change if i want to accept all request to the port 5433? iptables only affects the machine your server is running on. There can be a firewall literally *anywhere* between your client a

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread Shaun Thomas
On 10/19/2012 09:14 AM, GMAIL wrote: i try the version 1.16 but it doesn't work. i don't get any error message If you don't get any error message from the client or the server, are you sure it didn't work? I only ask because 1.8 was so old, I'm surprised it even worked with the version you

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread GMAIL
Il 19/10/2012 16:45, Shaun Thomas ha scritto: On 10/19/2012 09:38 AM, GMAIL wrote: but if i connect from another pc, with pgadmin 1.16 or other software, to the host with postgresql i get a "connection refused" message Ok. That narrows it down slightly. If you check your PG logs for FATAL me

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread Shaun Thomas
On 10/19/2012 09:06 AM, GMAIL wrote: i use postgresql 9.1 and pgadmin 1.8.4 Yeah, that version of pgAdmin is *way* too old. 1.16 was released fairly recently, and it works great. -- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-444-8534 stho...@options

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread Chris Ernst
On 10/19/2012 08:06 AM, GMAIL wrote: > Il 19/10/2012 16:05, Chris Ernst ha scritto: >> On 10/19/2012 07:50 AM, GMAIL wrote: >>> Il 19/10/2012 15:40, Chris Ernst ha scritto: On 10/19/2012 07:24 AM, GMAIL wrote: What happens when you try to connect? Any error message? Log entries? - Ch

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread GMAIL
Il 19/10/2012 16:55, Shaun Thomas ha scritto: Yep. You've got a firewall between you and your server. Somewhere. Good luck tracking that down, sir. Everything should clear up when/if that gets resolved. i think that the problem should be the service iptables. what i have to change if i want to

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread GMAIL
Il 19/10/2012 16:33, Shaun Thomas ha scritto: If you don't get any error message from the client or the server, are you sure it didn't work? I only ask because 1.8 was so old, I'm surprised it even worked with the version you had before. The catalog has changed a lot since then, and the err

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread GMAIL
Il 19/10/2012 16:11, Shaun Thomas ha scritto: On 10/19/2012 09:06 AM, GMAIL wrote: i use postgresql 9.1 and pgadmin 1.8.4 Yeah, that version of pgAdmin is *way* too old. 1.16 was released fairly recently, and it works great. i try the version 1.16 but it doesn't work. i don't get any erro

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread GMAIL
Il 19/10/2012 15:40, Chris Ernst ha scritto: On 10/19/2012 07:24 AM, GMAIL wrote: Il 19/10/2012 15:24, Chris Ernst ha scritto: On 10/19/2012 07:02 AM, GMAIL wrote: I have 2 cluster databases, running on the same host, Ubuntu. My fist database port is set to default but my second database port

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread GMAIL
postgresql 9.1 and pgadmin 1.8.4 And there it is. You'll need pgAdmin >= 1.12.x to work with PostgreSQL 9.1. - Chris can be a firewall problem? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/m

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread GMAIL
Il 19/10/2012 16:05, Chris Ernst ha scritto: On 10/19/2012 07:50 AM, GMAIL wrote: Il 19/10/2012 15:40, Chris Ernst ha scritto: On 10/19/2012 07:24 AM, GMAIL wrote: What happens when you try to connect? Any error message? Log entries? - Chris now i be able to connect, after update pgAdmin, but

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread Chris Ernst
On 10/19/2012 07:50 AM, GMAIL wrote: > Il 19/10/2012 15:40, Chris Ernst ha scritto: >> On 10/19/2012 07:24 AM, GMAIL wrote: >> What happens when you try to connect? Any error message? Log entries? >> - Chris > now i be able to connect, after update pgAdmin, but i receive the > following error: > "

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread GMAIL
Il 19/10/2012 15:40, Chris Ernst ha scritto: On 10/19/2012 07:24 AM, GMAIL wrote: What happens when you try to connect? Any error message? Log entries? - Chris now i be able to connect, after update pgAdmin, but i receive the following error: "ERROR: column "datconfig" does not exist LINE 1:

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread Chris Ernst
On 10/19/2012 07:24 AM, GMAIL wrote: > Il 19/10/2012 15:24, Chris Ernst ha scritto: >> On 10/19/2012 07:02 AM, GMAIL wrote: >>> I have 2 cluster databases, running on the same host, Ubuntu. My fist >>> database port is set to default but my second database port is set to >>> 5433 in the postgresql.

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread GMAIL
Il 19/10/2012 15:24, Chris Ernst ha scritto: On 10/19/2012 07:02 AM, GMAIL wrote: I have 2 cluster databases, running on the same host, Ubuntu. My fist database port is set to default but my second database port is set to 5433 in the postgresql.conf file. While everything is ok with local connec

Re: [GENERAL] Multiple Cluster on same host

2012-10-19 Thread Chris Ernst
On 10/19/2012 07:02 AM, GMAIL wrote: > I have 2 cluster databases, running on the same host, Ubuntu. My fist > database port is set to default but my second database port is set to > 5433 in the postgresql.conf file. While everything is ok with local > connections, I cannot connect using any of my

[GENERAL] Multiple Cluster on same host

2012-10-19 Thread GMAIL
I have 2 cluster databases, running on the same host, Ubuntu. My fist database port is set to default but my second database port is set to 5433 in the postgresql.conf file. While everything is ok with local connections, I cannot connect using any of my tools to the second database with port 54