Re: Postgres Cygwin Install-as-Service on XP Pro/Home Mini

Kevin,

On Tue, Nov 05, 2002 at 12:09:24AM -0700, Kevin Wong wrote:
> BUT!!!! Swap Excerpted Steps 7 and 8. "initdb" won't actually run
> successfully without ipc-daemon running in the background first, in my
> experience.

Oops! Thanks for the above. I'm amazed at how long I had this and the
numbering screwed up!

> Windows XP Home:
>
> Because Windows XP Home has a number of differences from XP Pro,
> primarily in user accounts/management, you can't simply follow the
> standard NT/2000 install-as-service instructions. You have to do a
> few things differently.

Since I don't have access to XP Home, would you be willing to help me
get this right? If so, then I will add a XP Home section to the README.

Combining my limited Windows 9x experience and your XP Home Cygwin
PostgreSQL installation steps, it sounds like a "blending" of the basic
and NT services installation is appropriate. Does the following make
sense *and* work:

1. Install the cygipc ipc-daemon as a NT service:

$ ipc-daemon --install-as-service

2. 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 --shutdown

3. Create the PostgreSQL data directory:

$ mkdir /usr/share/postgresql/data

4. Start the cygipc ipc-daemon:

$ net start ipc-daemon # [1]

5. Initialize PostgreSQL

$ initdb -D /usr/share/postgresql/data

6. Start postmaster:

$ net start postmaster # [1]

7. Connect to PostgreSQL:

$ psql template1

[1] Cygwin's bin directory (e.g., C:\Cygwin\bin) must be added to the
Windows NT/2000/XP's system PATH and the machine rebooted for the
SCM to find cygwin1.dll.

Note that the ipc-daemon and postmaster services are installed to run
under whatever user account XP Home uses for services.

Thanks,
Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6