Re: Why can't I do this (setup question) - Mailing list pgsql-general

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?

            regards, tom lane