Multiple Cluster on same host
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 5433, including pgAdmin. Please help. Any parameter
that I need to modify for the new database with port 5433?
|netstat -an | grep 5433|shows,
|tcp 0 0 0.0.0.0:5433 0.0.0.0:* LISTEN
tcp6 0 0 :::5433 :::* LISTEN
unix 2 [ ACC ] STREAM LISTENING 72842 /var/run/postgresql/.s.PGSQL.5433
|
|iptables -L|shows,
|Chain INPUT (policy ACCEPT)
target prot opt source destination
Chain FORWARD (policy ACCEPT)
target prot opt source destination
Chain OUTPUT (policy ACCEPT)
target prot opt source destination|
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 tools to the second
database with port 5433, including pgAdmin. Please help. Any parameter
that I need to modify for the new database with port 5433?
Is pg_hba.conf for the second cluster set up to allow access from
wherever you are connecting from?
- Chris
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
connections, I cannot connect using any of my tools to the second
database with port 5433, including pgAdmin. Please help. Any parameter
that I need to modify for the new database with port 5433?Is pg_hba.conf for the second cluster set up to allow access from
wherever you are connecting from?- Chris
yes
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.conf file. While everything is ok with local
connections, I cannot connect using any of my tools to the second
database with port 5433, including pgAdmin. Please help. Any parameter
that I need to modify for the new database with port 5433?Is pg_hba.conf for the second cluster set up to allow access from
wherever you are connecting from?yes
What happens when you try to connect? Any error message? Log entries?
- Chris
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: ...b.dattablespace AS spcoid, spcname, datallowconn, datconfig,..."
"Column not found in pgSet:rolconfig"
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 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 5433, including pgAdmin. Please help. Any parameter
that I need to modify for the new database with port 5433?Is pg_hba.conf for the second cluster set up to allow access from
wherever you are connecting from?yes
What happens when you try to connect? Any error message? Log entries?
- Chris
sorry I was confused. i don't receive any message
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?
- Chrisnow i be able to connect, after update pgAdmin, but i receive the
following error:
"ERROR: column "datconfig" does not exist
LINE 1: ...b.dattablespace AS spcoid, spcname, datallowconn, datconfig,...""Column not found in pgSet:rolconfig"
You didn't mention the versions of either PostgreSQL or pgAndmin, but
that sounds like you're using a newer version of PostgreSQL (9.1.x ?)
with and older version on pgAdmin (< 1.12.x ?). You may simply need to
upgrade pgAdmin (>= 1.12.x).
- Chris
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?
- Chrisnow i be able to connect, after update pgAdmin, but i receive the
following error:
"ERROR: column "datconfig" does not exist
LINE 1: ...b.dattablespace AS spcoid, spcname, datallowconn, datconfig,...""Column not found in pgSet:rolconfig"
You didn't mention the versions of either PostgreSQL or pgAndmin, but
that sounds like you're using a newer version of PostgreSQL (9.1.x ?)
with and older version on pgAdmin (< 1.12.x ?). You may simply need to
upgrade pgAdmin (>= 1.12.x).- Chris
i use postgresql 9.1 and pgadmin 1.8.4
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
sthomas@optionshouse.com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
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?
- Chrisnow i be able to connect, after update pgAdmin, but i receive the
following error:
"ERROR: column "datconfig" does not exist
LINE 1: ...b.dattablespace AS spcoid, spcname, datallowconn,
datconfig,...""Column not found in pgSet:rolconfig"
You didn't mention the versions of either PostgreSQL or pgAndmin, but
that sounds like you're using a newer version of PostgreSQL (9.1.x ?)
with and older version on pgAdmin (< 1.12.x ?). You may simply need to
upgrade pgAdmin (>= 1.12.x).i use 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
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 error message
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?
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 had before. The catalog has changed a lot since then, and
the error you reported is pretty much exactly what you'd expect by using
an old pgAdmin with a new Postgres due to missing entries.
You might think about deleting the pgAdmin entry and re-entering it from
scratch to make sure all the settings are as you expect. There should be
some kind of hint from the database log, too.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
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 error you reported is pretty much exactly what you'd expect by
using an old pgAdmin with a new Postgres due to missing entries.You might think about deleting the pgAdmin entry and re-entering it
from scratch to make sure all the settings are as you expect. There
should be some kind of hint from the database log, too.
if i connect with pgadmin from the host where i've created the two
clusters it does work
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
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 about pg_hba.conf not
having an entry for your host, it's probably a firewall issue.
For reference, the firewall can be anywhere between you and your host.
Try to ping the host and port where your PG server is running. If you
can't even get that far, I'd inquire to your Infrastructure department.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
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" messageOk. That narrows it down slightly. If you check your PG logs for FATAL
messages, and you don't see anything complaining about pg_hba.conf not
having an entry for your host, it's probably a firewall issue.For reference, the firewall can be anywhere between you and your host.
Try to ping the host and port where your PG server is running. If you
can't even get that far, I'd inquire to your Infrastructure department.
using ping i receive a connection timed out
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. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
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 accept all request to the port 5433?
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 and the host
server. You may need to search farther than the local server, especially
since I think you copied your firewall settings in the first message,
and they were all empty.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
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 catalog has changed a lot since then,
and the error you reported is pretty much exactly what you'd expect by
using an old pgAdmin with a new Postgres due to missing entries.You might think about deleting the pgAdmin entry and re-entering it
from scratch to make sure all the settings are as you expect. There
should be some kind of hint from the database log, too.if i connect with pgadmin from the host where i've created the two
clusters it does work
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
Is the server actually listening on any interface other than localhost?
What's in the listen_addresses entry in postgresql.conf for the cluster
on port 5433?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie