Skip site navigation (1) Skip section navigation (2)

Re: psql command error.

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Henshall, Stuart - WCP'" <SHenshall(at)westcountrypublications(dot)co(dot)uk>, "'Anil Jangam'" <anilj(at)indts(dot)com>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: psql command error.
Date: 2001-12-21 14:18:13
Message-ID: FED2B709E3270E4B903EB0175A49BCB10473B2@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-cygwin
You might also try setting $PGHOST=localhost - this can make life easier.

Regards, Dave.

> -----Original Message-----
> From: Henshall, Stuart - WCP 
> [mailto:SHenshall(at)westcountrypublications(dot)co(dot)uk] 
> Sent: 21 December 2001 14:01
> To: 'Anil Jangam'
> Cc: pgsql-cygwin(at)postgresql(dot)org
> Subject: Re: [CYGWIN] psql command error.
> 
> 
> Have you set permissions set up on /tmp that would stop it 
> being created? Also I don't know wether putting in the 
> postgresql.conf file: tcpip_socket = True would help. Also 
> there are some unix socket option in postgresql.conf (namely: 
> #unix_socket_directory = ''
> #unix_socket_group = ''
> #unix_socket_permissions = 0777
> ) Good luck on finding the problem
> - Stuart
> 
> -----Original Message-----
> From: Anil Jangam [mailto:anilj(at)indts(dot)com]
> Sent: 21 December 2001 11:01
> To: pgsql-cygwin(at)postgresql(dot)org
> Subject: [CYGWIN] psql command error.
> Importance: High
> 
> 
> Hi,
> 
> I am stuck with an error as follows. I am trying to create a 
> user with 'createuser' command. Also the same error is thrown 
> even when I am trying to run the 'psql' command.
> 
> $ createuser uss
> 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) n
> 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 "uss" failed
> 
> Administrator(at)ANILJ ~
> $ psql
> psql: connectDBStart() -- connect() failed: No such file or directory
>         Is the postmaster running locally
>         and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
> 
> Administrator(at)ANILJ ~
> $
> 
> I searched the directory /tmp/, but the .S.PGSQL.5432 file 
> doesn't exist.
> 
> regds,
> -anil.
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
http://www.postgresql.org/users-lounge/docs/faq.html

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

pgsql-cygwin by date

Next:From: Jake HelfertDate: 2001-12-21 17:52:57
Subject: error running postgresql on WinXP
Previous:From: Henshall, Stuart - WCPDate: 2001-12-21 14:00:42
Subject: Re: psql command error.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group