[newbie] server startup
Hi ..
I am just playing with PostgreSQL 8.0.1 The server is running on a
Solaris 8 platform with the kernel parameters tweaked as suggested.
When I start the server, the logfile reports:
$ pg_ctl start -l logfile
postmaster starting
$ cat logfile
LOG: could not bind IPv6 socket: Cannot assign requested address
HINT: Is another postmaster already running on port 5432? If not,
wait a few seconds and retry.
LOG: could not bind socket for statistics collector: Cannot
assign requested address
..
LOG: database system is ready
SO, the db is up and running locally but I can't get to it from the
network.
$ psql -l -h dbhost
psql: could not connect to server: Connection refused
Is the server running on host "dbhost" and accepting
TCP/IP connections on port 5432?
The build is from sunfreeware. Any thoughts on how to get my config up
and working across the network?
TIA,
--
-mark. (probertm at acm dot org)
Hi ..
On Tue, 2005-08-23 at 14:45 -0700, Mark Probert wrote:
SO, the db is up and running locally but I can't get to it from the
network.
With a friend's help, I worked out that I need to edit two files:
postgresql.conf (listen_address = '*')
pg_hba.conf (add "host all all 192.168.0.0/16 trust")
Now it is working.
Thanks,
--
-mark. (probertm at acm dot org)