Re: Debian stable install problems

Stan Brown <stanb@awod.com> wrote:
>I am having a bit of trouble geting PostgreSQL working quite corectly on my
>fresh Debian "stable" istall.
>
>I installed it using the Debina dselect tool. Now, If I su - postgres, I
>can use psql to connect to the db, so I know that that part of the install
>went OK. However I am having a problem adding users. See below:

>postgres@yogi:~$ /usr/local/pgsql/bin/createuser
                  ^^^^^^^^^^
That's probably not the 'creatuser' binary from the Debian package
"postgresql-client".

The Debian packages of PostgreSQL were changed to look for the PostgreSQL
socket in /var/run/postgresql rather than /tmp.

>Enter name of user to add: stan
>Shall the new user be allowed to create databases? (y/n) y
>Shall the new user be allowed to create more new users? (y/n) y
>psql: connectDBStart() -- connect() failed: No such file or directory
>    Is the postmaster running locally
>    and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?

The psql started by createuser was built to look for the PostgreSQL socket
in /tmp.

>    Any sugestions as to what I can do to fix this?

Make sure the Debian package versions of "postgresql" and
"postgresql-client" match exactly, and make sure you're not mixing a
home-built version with the Debian packages.

HTH,
Ray
--
What is this talk of software 'releases'? Klingons do not 'release'
software; our software ESCAPES, leaving a bloody trail of designers and
quality assurance people in its wake!