0

postgresql 9.1 Multiple Cluster on same host

view story
linux-howto

http://serverfault.com – 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, (HowTos)

u85500's picture
Submitted by u85500 on 10/19/2012

Stories similar to postgresql 9.1 Multiple Cluster on same host

Hi,

I am trying to set up a dev environment and I have Ubuntu server (10.16.1.92) and a CentOS VM (10.16.3.235) on this. On the CentOS I have a program running on port 5433.

I had problem with my VPN network in which my server with sql databse using ports 5432/5433 has to be hosted on public network. My server requires 5432/5433 port opened for data updates from public sector. But our VPN network administrators does not allow 5432/5433 to be opened due to security reasons. Kindly help us in this regards.

There can be more than one instance of ssh running:

$ ps aux | grep ssh cpn 6098 0.0 0.0 58196 2032 ? S 10:08 0:01 ssh cz -nNCTR 5433:localhost4:5432 root 6313 0.0 0.0 64072 1168 ? Ss 12:22 0:00 /usr/sbin/sshd root 6504 0.0 0.0 97816 3856 ? Ss 15:48 0:00 sshd: cpn [priv] cpn 6508 0.0 0.0 97816 1780 ?

I am running a GUI app (Gnucash) that connects to a remote Postgres database via a secure shell session. I can use the SSH -L command to tunnel a local port and then separately run Gnucash and this works fine.

What I'd like to do is use a single shell script that sets up the tunnel and then calls Gnucash. Is that possible?

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM with port 5432 mapped between host and VM.

pgAdmin Error:

Error connecting to the server: could not receive data from server: Software caused connection abortion (0x00002745/10053)

postgresql.conf

#------------------------------------------------------------------------------ # CONNECTIO

I upgraded a server with a Rails application to Ubuntu 12.04 from 10.04 and cannot connect to Postgresql database now...

Here is the error message from Rails app:

could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"

Also the pg_ctl start is not recognized as a command.

EDIT:

Tur

Hi,

i encounter a problem upgrading Fedora from 17 to 18

i need to Upgrade Postgresql from 9.1 to 9.2

For doing so i run

postgresql-setup upgrade

with some trust in place of md5 in pg_hba.conf and .pgpass file with option PGPASSFILE in script postgresql-setup to connect easily to database

In /var/lib/pgsql/pg_upgrade.log ii get :

Performing Consistency Checks -----------------------------

everyone,,i got stag when i configure my wifidog,,that is after step database acces.. i can't acces the localhost,,when i try to access the localhost, the result is like this :

I am unable to retrieve the schema version.

hallo everyone,,i have installed wifidog on my ubuntu,, i'm using ubuntu 11.04,, but when i'am configure wifidog i got errors on step database connection..this is the result after configure database acces :

Trying to open a Postgresql database connection : Unable to connect to database! Please make sure the server is online and the database "wifidog" exists.