Hi,
Here's what happens when I specify the port number
[EMAIL PROTECTED] ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123
psql: could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5000?
I have the listen_address in
postgresql.conf
file set as follows:
#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------
# - Connection Settings -
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
#port = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
-Bhavana
chris smith wrote:
On 5/31/07, Bhavana.Rakesh <[EMAIL PROTECTED]> wrote:
Ok,
I confirmed that I'm editing the right pg_hba.conf file. I made
sure that
there are no other postmasters running. I made sure that there is a
user
called 'brakesh'. I restart the postmaster everytime I make any
changes to
pg_hba.conf file. But still same results!
[EMAIL PROTECTED] ~/db_connect]$ psql -U brakesh -h 127.0.0.1 -d
testing123
psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user
"brakesh",
database "testing123", SSL off
[EMAIL PROTECTED] ~/db_connect]$ psql -p 5000 testing123
Welcome to psql 7.4.17, the PostgreSQL interactive terminal.
Why are you specifying the port number when you don't include the host?
What happens if you do include the port:
psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
