Postgres Pro
Downloads
Home   >   mailing lists

Thread: Can't switch the postgres user..

Can't switch the postgres user..

From
"Marvin"
Date:
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

Re: Can't switch the postgres user..

From
"Roger Ackroyd"
Date:
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

Re: Can't switch the postgres user..

From
"Marvin"
Date:

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

Re: Can't switch the postgres user..

From
"Roger Ackroyd"
Date:
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

Re: Can't switch the postgres user..

From
"Marvin"
Date:
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

Re: Can't switch the postgres user..

From
"Roger Ackroyd"
Date:
 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

Re: Can't switch the postgres user..

From
"Marvin"
Date:
-I did the steps 5, 6 & 7
-Logged out and login as the postgres user.
-When I execute the command:
 
postgres@guaj215desa ~
$ chmod 777 /usr/share/postgresql/data
chmod: changing permissions of `/usr/share/postgresql/data': Permission denied
What can I do.
 
 
 
MAGO
(I have been installing this CygWin version for 4 days, please help.)
 
-------Mensaje original-------
 
Fecha: Jueves, 24 de Julio de 2003 02:51:32 p.m.
Asunto: Re: [CYGWIN] Can't switch the postgres user..
 
 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

Re: Can't switch the postgres user..

From
"Roger Ackroyd"
Date:
Marvin
Little more that I can help you with. What you need get are sufficent create permissions for postgres account in order for initdb to create the database.
I managed to get mine working the way I have suggested to you. I am not saying it is the right way, just that it works.
Careful perseverence and elimination on your part will find you the solution. I cannot not give you the magic bullet for this one.
 
Check that from the windows services log on tab that 'Log on as' 'this account' is selected with postgres as user and and password. On the dependencies tag check that postmaster is shown as dependent on Cygipc Daemon.
Try the procedure again after a clean boot up.
Now nothing more that I can suggest.
Roger
   
 
----- Original Message -----
From: Marvin
Sent: Friday, July 25, 2003 10:41 PM
Subject: Re: [CYGWIN] Can't switch the postgres user..

-I did the steps 5, 6 & 7
-Logged out and login as the postgres user.
-When I execute the command:
 
postgres@guaj215desa ~
$ chmod 777 /usr/share/postgresql/data
chmod: changing permissions of `/usr/share/postgresql/data': Permission denied
What can I do.
 
 
 
MAGO
(I have been installing this CygWin version for 4 days, please help.)
 
-------Mensaje original-------
 
Fecha: Jueves, 24 de Julio de 2003 02:51:32 p.m.
Asunto: Re: [CYGWIN] Can't switch the postgres user..
 
 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

Re: Can't switch the postgres user..

From
"Roger Ackroyd"
Date:
Marvin ( you are posting everthing twice)
 
Re:
-------------------------------------
When I execute the command:
 
postgres@guaj215desa ~
$ chmod 777 /usr/share/postgresql/data
chmod: changing permissions of `/usr/share/postgresql/data': Permission denied
-------------------------
You also might try granting postres account administrator status when you perform the procedures.
 
Essentially give the postgres account all the rights and permissions you can, that enable you to succesfully run initdb, start the postmaster and connect to the database back in the Owner account
Worry afterwards about getting all the folder/file rights and permissions set correctly.
 
Looks like you already installed things right but JIC:
 
Make sure that you have done step 4 correctly (if necessary, re-install everthing from a clean machine startup, delete and recreate the postgres account again (with adminsistrator rights etc.) and the ../data and is subfolders. Check 'login-as' setting in windows services (as per last post)
Try the chmods i suggested again with administrator rights on postgres.
Make sure you have done footnote [13] (but i dont think it is that)
Ensure that you started the ipc-daemon from the Owner account before you try to create database.
Fiddle around 5,6,7,8, from there.
Remember that if the ../postgresql/data folder is not empty then initdb will not run.
Do'nt forget to at least let Jason know, if you identify the key step/action that clears the problem.
If all else fails
Read ALL of the footnotes again for clues, stand back from problem and to try understand what it is you are actually trying to do.
Remember that if you are doing this on XP Home you are trying to do something that Microsoft were hoping you would upgrade to XP Professional for. Only 170GBP about 300USD (here anyway). That would 'fix' it right away and is the means by which Microsoft makes a lot of its money. 
There are also some cygwin/postgresql upgrades in the pipeline I think, that should eradicate the problem for XP Home users. Remember that this is open source and that things get fixed when the expert (Jason) and his team has 'spare' time to fix them and does not expect to get paid. Be thankful to the expert groups and help them all you can.
I understand your frustration with all this.
 
Roger
 

Re: Can't switch the postgres user..

From
"George Weaver"
Date:
Marvin,
 
I'm not sure if its been mentioned before in the exchanged of e-mails relating to your problem, but from my experience you MUST have a password associated with the login account in Windows - the password cannot be blank.  This applies to the "Log On - This Account" component of the install.
 
George
 
----- Original Message -----
From: Marvin
Sent: Friday, July 25, 2003 4:41 PM
Subject: Re: [CYGWIN] Can't switch the postgres user..

-I did the steps 5, 6 & 7
-Logged out and login as the postgres user.
-When I execute the command:
 
postgres@guaj215desa ~
$ chmod 777 /usr/share/postgresql/data
chmod: changing permissions of `/usr/share/postgresql/data': Permission denied
What can I do.
 
 
 
MAGO
(I have been installing this CygWin version for 4 days, please help.)
 
-------Mensaje original-------
 
Fecha: Jueves, 24 de Julio de 2003 02:51:32 p.m.
Asunto: Re: [CYGWIN] Can't switch the postgres user..
 
 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

Re: Can't switch the postgres user..

From
"Marvin"
Date:
Ok, I will try to uninstall everything and do it agan from the start
following your comments and tips. I think that I'm missing something
or doing something wrong.
 
Anyway thak you for all your help and patience.
 
Regards,
 
Marvin
 
-------Mensaje original-------
 
Fecha: Sábado, 26 de Julio de 2003 04:03:43 a.m.
Asunto: Re: [CYGWIN] Can't switch the postgres user..
 
Marvin
Little more that I can help you with. What you need get are sufficent create permissions for postgres account in order for initdb to create the database.
I managed to get mine working the way I have suggested to you. I am not saying it is the right way, just that it works.
Careful perseverence and elimination on your part will find you the solution. I cannot not give you the magic bullet for this one.
 
Check that from the windows services log on tab that 'Log on as' 'this account' is selected with postgres as user and and password. On the dependencies tag check that postmaster is shown as dependent on Cygipc Daemon.
Try the procedure again after a clean boot up.
Now nothing more that I can suggest.
Roger
   
 
----- Original Message -----
From: Marvin
Sent: Friday, July 25, 2003 10:41 PM
Subject: Re: [CYGWIN] Can't switch the postgres user..

-I did the steps 5, 6 & 7
-Logged out and login as the postgres user.
-When I execute the command:
 
postgres@guaj215desa ~
$ chmod 777 /usr/share/postgresql/data
chmod: changing permissions of `/usr/share/postgresql/data': Permission denied
What can I do.
 
 
 
MAGO
(I have been installing this CygWin version for 4 days, please help.)
 
-------Mensaje original-------
 
Fecha: Jueves, 24 de Julio de 2003 02:51:32 p.m.
Asunto: Re: [CYGWIN] Can't switch the postgres user..
 
 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