Re: Can't switch the postgres user..

From: "Marvin" <magosoft(at)gmx(dot)net>
To: <postgresql(at)ackroyd(dot)freeserve(dot)co(dot)uk>
Cc: <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: Can't switch the postgres user..
Date: 2003-07-24 20:21:53
Message-ID: 3F203FE1.000005.02528@guaj215desa
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

Ok, I have downloaded and decompress the file:

cygwin1-20030710.dll.bz2

From the snapshot link indicated in footnote [10]
-Stopped and remove the services (ipc-daemon & postmaster)
-Rename the dll to cygwin1.dll
-Reinstall and restart the services.
-chown postgres /usr/share/postgresql/data
-Logout and login with postgres account
-initdb -D /usr/share/postgresql/data

Got the following error:

postgres(at)guaj215desa ~
$ initdb -D /usr/share/postgresql/data
The files belonging to this database system will be owned by user "postgres"

This user must also own the server process.

The database cluster will be initialized with locale C.

Fixing permissions on existing directory /usr/share/postgresql/data...
chmod: ch
anging permissions of `/usr/share/postgresql/data': Permission denied

initdb failed.

What can I do.

MAGO

-------Mensaje original-------

De: Roger Ackroyd
Fecha: Jueves, 24 de Julio de 2003 12:11:53 p.m.
A: pgsql-cygwin(at)postgresql(dot)org
Asunto: Re: [CYGWIN] Can't switch the postgres user..

Marvin
Are you using the following readme?
http://archives.postgresql.org/pgsql-cygwin/2003-07/msg00004.php
If so, read footnote [16] try that, and then see if you can proceed further.
Get Back.
Roger
----- Original Message -----
From: Marvin
To: postgresql(at)ackroyd(dot)freeserve(dot)co(dot)uk
Cc: pgsql-cygwin(at)postgresql(dot)org
Sent: Thursday, July 24, 2003 7:01 PM
Subject: Re: [CYGWIN] Can't switch the postgres user..

File version: 1003.22.0.0
API version: 0.78
Buil date: 2003-03-18 09:20
Product version: 1.3.22-dontuse-21


MAGO
-------Mensaje original-------

De: Roger Ackroyd
Fecha: Jueves, 24 de Julio de 2003 11:53:51 a.m.
A: pgsql-cygwin(at)postgresql(dot)org
Asunto: Re: [CYGWIN] Can't switch the postgres user..

Marvin
Look in your ../cygwin/bin and check the version of your cygwin1.dll. Let me
know.

[Jason] this might help clarify the answer to my own question on the other
matter.
Roger
----- Original Message -----
From: Marvin
To: pgsql-cygwin(at)postgresql(dot)org
Sent: Thursday, July 24, 2003 6:42 PM
Subject: [CYGWIN] Can't switch the postgres user..

Thank you Roger and Jason.
I downloaded the cygipc-1-14.1 and installed on my XP
Everything goes fine until I do the step:
8. Initialize PostgreSQL (*when running under the "postgres" account*):
mgonzalez(at)guaj215desa ~
$ initdb -D /usr/share/postgresql/data
The files belonging to this database system will be owned by user "mgonzalez
.
This user must also own the server process.
The database cluster will be initialized with locale C.
Fixing permissions on existing directory /usr/share/postgresql/data... ok
creating directory /usr/share/postgresql/data/base... mkdir: cannot create
direc
tory `/usr/share/postgresql/data/base': Permission denied
initdb failed.
mgonzalez(at)guaj215desa ~
$ su postgres
Password:
su: incorrect password
As you see, I tried to change the current user to postgres. I left the
password blank by pressin ENTER twice.
What I am doing wrong (again).
Thank you in advanced for your patience.

MAGO

In response to

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Roger Ackroyd 2003-07-24 20:50:27 Re: Can't switch the postgres user..
Previous Message Roger Ackroyd 2003-07-24 18:10:28 Re: Can't switch the postgres user..