Hi Guys,
I'm trying to allow a remote host on our 10.3.55.X network remote access to
a Postgres Database on the same network.
We're running Solaris 10 with Postgres 83
My postgresql.conf looks like this;
listen_addresses = '*' # what IP address(es) to listen on;
Both the below were ran on the Postgres Server.
$ telnet 5432
Trying ...
telnet: Unable to connect to remote host: Connection refused
$ psql -h -U post_owner -d post_db
psql: could not connect to server: Connection refused
Is the server running on host "" and accepting
TCP/IP
Hi,
Thanks for the reply.
Nope, not a Firewall problem.
I also get connection refused if I telnet by IP address on the Postgres
server.
I can telnet localhost 5432
But not telnet 5432
Anything else I can try here? I'm not sure my pg_hba.conf is correct, what
do you think?
--
View this mess
To confirm, 10.3.55.182 is the Postgres Server
$ telnet 10.3.55.182 5432
Trying ...
telnet: Unable to connect to remote host: Connection refused
$ telnet localhost 5432
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
$ psql -h 10.3.55.182 -U post_owner -d post_db
psql:
Hi,
I've checked IP Filter is disabled...
Also this is Solaris 10 - netstat -lnp is not recognised. Here is netstat
-np without my macs :)
I'm using vnet3 so looks like I'm using the wrong netmask, tried editing
pg_hba.conf to 255.255.255.255 instead but still no joy...
Device IP Address
Here you go.
Explains why locahost is OK, but how do I get PM to listen on *.5432
Thanks for your help
# netstat -a | grep LISTEN
localhost.5999 *.*0 0 49152 0 LISTEN
*.ssh*.*0 0 49152 0 LISTEN
*.telnet
To confirm, the below would indicate PM is not listening on *.5432
How do I change this?
# netstat -a | grep LISTEN
localhost.5999 *.*0 0 49152 0 LISTEN
*.ssh*.*0 0 49152 0 LISTEN
*.telnet *
Guys,
Thanks for your help.
When I saw that netstat was not listening as *.5432 I decided to;
svcadm disable svc:/application/database/postgresql_83:default_64bit
Then;
pg_ctl -D /var/lib/pgsql/data -l postmaster.log start
This fixed the problem.
You guys were right on the money, looks like
