Re: Can't switch the postgres user.. - Mailing list pgsql-cygwin

From Roger Ackroyd
Subject Re: Can't switch the postgres user..
Date
Msg-id 012401c35225$36ef0ed0$b200a8c0@mydomain.com
Whole thread Raw
In response to Re: Can't switch the postgres user..  ("Roger Ackroyd" <postgresql@ackroyd.freeserve.co.uk>)
List pgsql-cygwin
 Starting from Owner account delete and recreate any .../usr/share/postgresql/data folder and its contents created before i.e. proceed from step 5)
 
at step 8 Switch to your postgres account and try the following
 
chmod 777 /usr/share/postgresql/data
chmod a+rwx /usr/share/postgresql/data
initdb /usr/share/postgresql/data
 
Switch back to Owner account
chmod 777 /usr/share/postgresql/data
chmod a+rwx /usr/share/postgresql/data
net start postmaster
 
See if that works and let me know.
Roger
 
If it does you should be able to do step 10. 
----- Original Message -----
From: Marvin
Sent: Thursday, July 24, 2003 9:21 PM
Subject: Re: [CYGWIN] Can't switch the postgres user..

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@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-------
 
Fecha: Jueves, 24 de Julio de 2003 12:11:53 p.m.
Asunto: Re: [CYGWIN] Can't switch the postgres user..
 
Marvin
Are you using the following readme?
If so, read footnote [16] try that, and then see if you can proceed further. Get Back.
Roger
----- Original Message -----
From: Marvin
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-------
 
Fecha: Jueves, 24 de Julio de 2003 11:53:51 a.m.
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
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@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@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

 
 
_________________________________________________________________
  IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
Attachment

pgsql-cygwin by date:

Previous
From: "Marvin"
Date:
Subject: Re: Can't switch the postgres user..
Next
From: "Sexton, Joe"
Date:
Subject: UNSUBSCRIBE