Обсуждение: Help
Hi,
I need help with finding some Documentation about how to install PostGerSQL on windows 2000
Step by step.
Thanks,
Ilan
Ilan,
On Thu, Jun 07, 2001 at 03:21:43PM +0300, Ilan Fait wrote:
> I need help with finding some Documentation about how to install PostGerSQL on
> windows 2000
>
> Step by step.
1. Install the pre-built PostgreSQL 7.1.2 that is automatically
installed when you install Cygwin (www.cygwin.com).
2. Read the README file that is installed in step 1.
/usr/doc/Cygwin/postgresql-7.1.2.README
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.Tishler@dothill.com
Hazlet, NJ 07730 USA WWW: http://www.dothill.com
Ilan, In the future, please post to pgsql-cygwin@postgresql.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.Tishler@dothill.com Hazlet, NJ 07730 USA WWW: http://www.dothill.com
Hi,
Thank you for all the help until now. I will send a summary to pgsql-cygwin@postgresql.org
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 speci
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,
Ilan
-----Original Message-----
From: Jason Tishler [mailto:Jason.Tishler@dothill.com]
Sent: Wednesday, June 13, 2001 3:31 PM
To: Ilan Fait
Cc: Pgsql-Cygwin
Subject: Re: [CYGWIN] Help
Ilan,
In the future, please post to pgsql-cygwin@postgresql.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.Tishler@dothill.com
Hazlet, NJ 07730 USA WWW: http://www.dothill.com
Ilan,
On Wed, Jun 13, 2001 at 05:29:49PM +0300, Ilan Fait wrote:
> $ postmaster
> postmaster does not know where to find the database system data. You must
> speci
> fy the directory that contains the database system either by specifying the -D
> i
> nvocation option or by setting the PGDATA environment variable.
Please read the Cygwin PostgreSQL README file:
/usr/doc/Cygwin/postgresql-7.1.2.README
it contains the step-by-step instructions for which you originally
requested.
Thanks,
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.Tishler@dothill.com
Hazlet, NJ 07730 USA WWW: http://www.dothill.com