Postgres Pro
Downloads
Home   >   mailing lists

Thread: psql command error.

psql command error.

From
Anil Jangam
Date:
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@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@ANILJ ~
$

I searched the directory /tmp/, but the .S.PGSQL.5432 file doesn't exist.

regds,
-anil.

Re: psql command error.

From
"Henshall, Stuart - WCP"
Date:
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@indts.com]
Sent: 21 December 2001 11:01
To: pgsql-cygwin@postgresql.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@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@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

Re: psql command error.

From
Dave Page
Date:
You might also try setting $PGHOST=localhost - this can make life easier.

Regards, Dave.

> -----Original Message-----
> From: Henshall, Stuart - WCP
> [mailto:SHenshall@westcountrypublications.co.uk]
> Sent: 21 December 2001 14:01
> To: 'Anil Jangam'
> Cc: pgsql-cygwin@postgresql.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@indts.com]
> Sent: 21 December 2001 11:01
> To: pgsql-cygwin@postgresql.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@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@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@postgresql.org)