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

Paul Tomblin <ptomblin(at)xcski(dot)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