Обсуждение: 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!