Hello
If your listen_addresses is wrong,the same error can occur.
example)
$ cat postgresql.conf |grep listen_addresses
#listen_addresses = '*' # what IP address(es) to listen on;
$ psql -h 192.168.23.133
psql: could not connect to server: Connection refused
Is the server running on host "192.168.23.133" and accepting
TCP/IP connections on port 1844?
Is your listen_addresses right?
(2010/10/01 13:10), Tena Sakai wrote:
Hi everybody,
Sorry, I previously didn’t put subject line.
I recently built postgres 8.4.4 from source and tested it.
It seemed to work fine then, but I cannot seem to run psql
today. I built it to run on port 6543. Do I need to specify the
port number when I start it?
Here’s the session dialog:
bash-3.2$ pg_ctl stop -D /usr/local/pgsql/data
LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
waiting for server to shut down....LOG: database system is shut down
done
server stopped
bash-3.2$
bash-3.2$ pg_ctl start -D /usr/local/pgsql/data
server starting
bash-3.2$ LOG: database system was shut down at 2010-09-30 20:38:47 PDT
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
bash-3.2$
bash-3.2$ psql canon
psql: could not connect to server: Connection refused
Is the server running on host "172.16.0.151" and accepting
TCP/IP connections on port 6543?
bash-3.2$
Thank you for your help.
Regards,
Tena Sakai
_tsa...@gallo.ucsf.edu_
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
