Re: Why can't I do this (setup question)

Quoting Tom Lane (tgl@sss.pgh.pa.us):
> Paul Tomblin <ptomblin@xcski.com> writes:
> > I've got PostgreSQL 7.1 installed from rpms on a RedHat 6.2 system.  I
> > want the data directory on a separate partition, so I shut down, tar the
> > whole directory into the other directory, mount it, and when I start up
> > postgresSQL it says it's up, but I can't connect to any databases using
> > psql.
> > psql: connectDBStart() -- connect() failed: Connection refused
> >         Is the postmaster running locally
> >         and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
> > There is a postmaster running, but no socket in /tmp/
>
> Odd.  Seems unlikely that that has anything to do with your having moved
> the data directory.  Any interesting messages in the postmaster log?
> Can you connect via TCP?

Is there a postmaster log other than what's in /var/log/messages?
Because there is nothing useful in there other than a message that it
started successfully.

--
Paul Tomblin <ptomblin@xcski.com>, not speaking for anybody
"All life is transitory. A dream. We all come together in the same place at
the end of time. If I don't see you again here, I will see you in a little
while in the place where no shadows fall." - Delenn