Re: Snapshot is not working

On Tue, 23 Oct 2001, Tille, Andreas wrote:

> On Fri, 19 Oct 2001, Tom Lane wrote:
>
> > "Tille, Andreas" <TilleA@rki.de> writes:
> > > psql: connectDBStart() -- connect() failed: No such file or directory
> > >         Is the postmaster running locally
> > >         and accepting connections on Unix socket '/var/run/postgresql/.s.PGSQL.5432'?
> >
> > That's not the usual location for a PG socket file.  How did you tell
> > psql to look there, and are you sure the postmaster thinks the same?
> > (If there's a socket file present in /tmp rather than
> > /var/run/postgresql, it's a strong tipoff that you've gotten this
> > wrong...)
> This is in fact the case.  I wrote an /etc/init.postgresql script
> which does at start:
>
>
>     touch ${POSTGRES_LOG:=/var/log/postgres.log}
>     chown postgres.postgres $POSTGRES_LOG
>     su - postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data  >$POSTGRES_LOG 2>&1 &"
>
> which is in my opinion what the INSTALL file suggests.  I don�t know
> why the socket is created as /tmp/.s.PGSQL.5432 ?  Any idea what could
> be wrong?

Is it possible that you've got two versions of the libraries/programs
running around, maybe one from the RPMs (I think that'd probably be where
the RPMs would put the socket file).