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

----- Original Message -----

From: Marvin

To: postgresql@ackroyd.freeserve.co.uk

Cc: pgsql-cygwin@postgresql.org

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-------   De: Roger Ackroyd Fecha: Jueves, 24 de Julio de 2003 12:11:53 p.m. A: pgsql-cygwin@postgresql.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@ackroyd.freeserve.co.uk Cc: pgsql-cygwin@postgresql.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@postgresql.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@postgresql.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@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í