-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Congratulations! Please consider sending these instructions to the postgresql
people, hopefully they can put it in their docs somewhere...
Russell
On Friday 25 April 2003 17:12 pm, Jared Quedens wrote:
> I might have confused you a bit. However I did figure out the problem and
> solved it last night.. I found a hardly readable readme file online that
> gave me the answer. Cygwin uses an ipc-daemon for postgres, although they
> claim its outdated, you still need to use it with postgres for now. That
> daemon is installed as an NT service! as well as postmaster. you grant
> postgres the log on as service right. XP actually starts the services as
> postgres, NOT cygwin starting it as a daemon. Thats where i got lost. This
> is what i found that helped for anyone interested...
>
> The following is the NT services Cygwin PostgreSQL installation procedure:
> 1. Install the cygipc ipc-daemon as a NT service: # ipc-daemon
> --install-as-service 2. Create the "postgres" user account: # cmd /c
> lusrmgr.msc # [3]
> 3. Grant the "postgres" user the "Log on as a service" user right: # cmd /c
> secpol.msc [4] 4. Install postmaster as a NT service: # cygrunsrv --install
> postmaster --path /usr/bin/postmaster --args "-D /usr/share/postgresql/data
> -i" --dep ipc-daemon --termsig INT --user postgres --shutdown # [5] [6]
> 5. Create the PostgreSQL data directory: # mkdir /usr/share/postgresql/data
> 6. Change ownership of the PostgreSQL data directory: # chown postgres
> /usr/share/postgresql/data 7. Initialize PostgreSQL (*when running under
> the "postgres" account*): $ initdb -D /usr/share/postgresql/data
> 5. Start the cygipc ipc-daemon: # net start ipc-daemon # [7]
> 6. Start postmaster: # net start postmaster # [7]
> 7. Connect to PostgreSQL: # psql -U postgres template1
> [8]
> [9]
>
>
> The following are the notes to the above:
> [1] The "#" prompt indicates running as a user which is a member of the
> Local Administrators group.
> [2] The "$" prompt indicates running as the "postgres" user. Log in as
> "postgres" or use ssh to emulate Unix's "su" command.
> [3] On Windows 2000, this starts the "Local Users and Groups" applet. On
> Windows NT 4.0, do the analogous operation.
> [4] On Windows 2000, this starts the "Local Security Settings" applet. On
> Windows NT 4.0, do the analogous operation.
> [5] Do not use rxvt for this step because the password exchange will not
> work properly. [6] Clean postmaster shutdown will only work with a post
> Cygwin 1.3.2 snapshot from 2001-Jul-28 or later.
> [7] Cygwin's bin directory (e.g., C:\Cygwin\bin) must be added to the
> Windows NT/2000's system PATH and the machine rebooted for the SCM to find
> cygwin1.dll.
> [8] Actually, psql can run under any user account.
> [9] One can use PostgreSQL's createuser command or set PGUSER to obviate
> the need to specify "-U postgres" on the psql command line.
>
> So case closed!!! :-) i now have a working postgres in cygwin.. Although
> the setup is a little tricky I like the idea of having it in my xp
> services. not a bad twist.. Thanx all who helped and I hope someone out
> there will benifit from my misery! :-)
>
>
>
> __________________________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo
> http://search.yahoo.com
- --
Linux -- the OS for the Renaissance Man
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE+qnw/AqKGrvVshJQRAiQIAKDCLHmsUtighxGIV+XcttWFvbeHKQCfQWn3
k8bohhqbLkuoHep9+2EvTSw=
=tZ+7
-----END PGP SIGNATURE-----
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 18:34:28 EDT