Thread: Debian stable install problems

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:


Script started on Fri Apr 13 09:50:33 2001
postgres@yogi:~$ psql
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

template1=# \q
postgres@yogi:~$ /usr/local/pgsql/bin/createuser
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'?
createuser: creation of user "stan" failed
postgres@yogi:~$
Script done on Fri Apr 13 09:51:13 2001

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

--
Stan Brown     stanb@awod.com                                    843-745-3154
Charleston SC.
--
Windows 98: n.
    useless extension to a minor patch release for 32-bit extensions and
    a graphical shell for a 16-bit patch to an 8-bit operating system
    originally coded for a 4-bit microprocessor, written by a 2-bit
    company that can't stand for 1 bit of competition.
-
(c) 2000 Stan Brown.  Redistribution via the Microsoft Network is prohibited.

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!