Re: restart postgres 7.3.2 problem

Saranya Sivakumar <sarlavk@yahoo.com> writes:
> Thanks for your input. Meanwhile, we tried starting postgres using this command and were successful according to the
log:

>  su postgres -c "/usr/bin/pg_ctl start -D /db/data"

> pg_ctl: another postmaster may be running; trying to start postmaster anyway

> LOG: could not create IPv6 socket: Address family not supported by protocol

You seem to be rather seriously confused --- that is certainly not a 7.3
postmaster, because there was no IPv6 support in PG 7.3; nor was there a
writer subprocess before 8.0, so I'm betting this is actually 8.0.something.

It would appear that you've got two different generations of Postgres
installed on that machine, and they are fighting over which one owns the
database directory.  In fact, you may have pieces of *three* versions,
because it says here that RHL 7.3 shipped with Postgres 7.2.something.
This is a recipe for shooting yourself in the foot :-(.  I'd suggest
figuring out which version you actually wish to be running, and removing
all traces of the other version(s), and then making sure that the system
boot process correctly starts the version you want to run.

> Though the log messages say that posgtres has started and is running,
> when we try to access the database from the web, we get an error
> message saying that Postgres is not running and accepting connections
> on port 5432.

8.0 defaults to accepting only local TCP connections; if you want it to
accept remote connections, set listen_addresses to '*' in
postgresql.conf (and restart the postmaster).  Pre-8.0, set tcpip_socket
to true, instead.

            regards, tom lane