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

RE: Help

From: Ilan Fait <ilan(at)iweb(dot)com>
To: "'Jason Tishler'" <Jason(dot)Tishler(at)dothill(dot)com>
Cc: "'pgsql-cygwin(at)postgresql(dot)org'" <pgsql-cygwin(at)postgresql(dot)org>
Subject: RE: Help
Date: 2001-06-13 14:29:49
Message-ID: C9E46ACE328FD311B70200508B91AD8CA8FE8C@EXCHANGE (view raw, whole thread or download thread mbox)
Lists: pgsql-cygwin


  Thank you for all the help until now. I will send a summary to
  when I succeed in creating a database on win 2000 O/S with the  Cygwin.

 Only to update you I reinstall all on my computer.
 Running the commands  id and pg_id I get

 $ id
  uid=1001(ilan) gid=513(None) groups=513(None)

 But I can not create a db  the error that I get 
$ createdb iweb
psql: connectDBStart() -- connect() failed: No such file or directory
        Is the postmaster running locally
        and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
createdb: database creation failed

 I can not start the postmaster  I get .

 $ postmaster
postmaster does not know where to find the database system data.  You must
fy the directory that contains the database system either by specifying the
-D i
nvocation option or by setting the PGDATA environment variable.

 Best Regards,

-----Original Message-----
From: Jason Tishler [mailto:Jason(dot)Tishler(at)dothill(dot)com]
Sent: Wednesday, June 13, 2001 3:31 PM
To: Ilan Fait
Cc: Pgsql-Cygwin
Subject: Re: [CYGWIN] Help


In the future, please post to pgsql-cygwin(at)postgresql(dot)org instead of
sending private email so others can benefit too.

On Wed, Jun 13, 2001 at 10:19:37AM +0300, Ilan Fait wrote:
> $ createdb iweb
> psql: FATAL: PQsetdbLogin(): Unable to determine a Postgres username!
> createdb: database creation failed
> So I try to create a user I get:
> $ createuser iweb
> 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: FATAL: PQsetdbLogin(): Unable to determine a Postgres username!
> createuser: creation of user "iweb" failed

The above indicates that your Cygwin setup is not correct.  Did you
create a /etc/passwd or /etc/group file via mkpasswd -l >/etc/passwd and
mkgroup -l >/etc/group, respectively?  What happens when you execute id
or pg_id?

A temporary workaround to your Cygwin setup problem is to use the
PGUSER environment variable or the -U option to createdb (and other
PostgreSQL commands).  However, you really need to rectify your Cygwin
setup problem(s).

>  If I try to logon I get:
>  $ su administrator
> Password:
> LogonUser error! (rc=1722)
> The RPC server is unavailable

Cygwin support for su is very recent and requires some effort to setup;
otherwise, su will *not* work as under UNIX.  Nevertheless, proper su
operation is not necessary to get PostgreSQL to run under Cygwin.


Jason Tishler
Director, Software Engineering       Phone: 732.264.8770 x235
Dot Hill Systems Corp.               Fax:   732.264.8798
82 Bethany Road, Suite 7             Email: Jason(dot)Tishler(at)dothill(dot)com
Hazlet, NJ 07730 USA                 WWW:


  • Re: Help at 2001-06-13 14:58:56 from Jason Tishler

pgsql-cygwin by date

Next:From: Jason TishlerDate: 2001-06-13 14:58:56
Subject: Re: Help
Previous:From: Jason TishlerDate: 2001-06-13 12:30:56
Subject: Re: Help

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