From: | Kawecki_Lewis(at)emc(dot)com |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Correct configuration to access Postgres 7.3 from remote client? |
Date: | 2007-07-04 00:42:27 |
Message-ID: | 21503149CFC0C74B9982D9275EDEA06C03CA34C0@CORPUSMX10A.corp.emc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
First, I modified these lines in the postgresql.conf file:
tcpip_socket = true
port = 5432
virtual_host = '20.20.20.4, localhost'
where 20.20.20.4 is the address of the postgres server. Is this needed?
Second, I modified pg_hba.conf and added this line:
host all all 20.20.20.5 255.255.255.0 trust
where 20.20.20.5 is the client machine that I need to access the
database from.
Then I call "pg_ctl reload -D data_directory" to reload the config file
changes.
Then from the client I issue:
pg_dump --host=20.20.20.4 -o mydb > remotedump
pg_dump: [archiver (db)] connection to database "mydb" failed: could not
connect to server: Connection refused
Is the server running on host "10.10.18.53" and accepting
TCP/IP connections on port 5432?
It looks like the server is not configured properly. Does anyone know
what I am missing?
One strange thing is the postmaster.opts file contains the following:
cat postmaster.opts
/usr/bin/postmaster '-i' '-h' '127.0.0.1'
I though it would contain '-h' '20.20.20.4, 127.0.0.1' because of my
virtual_host setting.
Any help would be greatly appreciated.
Lewis Kawecki
E: kawecki_lewis(at)emc(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-07-04 01:57:20 | Re: hot restart of posgtresql |
Previous Message | ngaleyev | 2007-07-03 23:35:26 | hot restart of posgtresql |