Re: Snapshot is not working

From: "Tille, Andreas" <TilleA(at)rki(dot)de>
To:
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Snapshot is not working
Date: 2001-10-25 12:07:57
Message-ID: Pine.LNX.4.33.0110251405220.10175-100000@wr-linux02.rki.ivbb.bund.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 24 Oct 2001, Tom Lane wrote:

> "Tille, Andreas" <TilleA(at)rki(dot)de> writes:
> > No I did not. Even if I set
> > unix_socket_directory = '/tmp'
> > explicitely in /usr/local/pgsql/data/postgresql.conf but this doesn´t
> > change anything.
>
> No, because that's telling the postmaster to put the socket in /tmp,
> which is what it was doing anyway. Your problem is that psql is doing
> something different from the postmaster.
Well OK, than it works with

unix_socket_directory = '/var/run/postgresql'

now. Thanks for the hint. On the other hand: How can I really make sure
that my postgresql snapshot is running. I´m afraid that there are some
remainders from my 7.1.3 installation which might has caused this trouble.

> > and I do not see any remander from the Debian settings but the problem
> > remains that the socket is created under /tmp but from postgres
> > expected to be under /var/run/postgresql/.s.PGSQL.5432.
>
> Do you perhaps have PGHOST set to /var/run/postgresql in psql's
> environment?
No, it´s empty.

Kind regards

Andreas.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tille, Andreas 2001-10-25 12:14:13 Re: Snapshot is not working (Solution)
Previous Message steve boyle 2001-10-25 12:06:36 Re: Importing Access 97 Database into 7.1.3