Stan Brown <[EMAIL PROTECTED]> 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! ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html