Re: Help

Ilan,

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

--
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: http://www.dothill.com