Re: postgresql on windows 2000 - Mailing list pgsql-cygwin

From Jason Tishler
Subject Re: postgresql on windows 2000
Date
Msg-id 20030908201718.GD1888@tishler.net
Whole thread Raw
In response to postgresql on windows 2000  (raj_14_11@rec-all.com)
List pgsql-cygwin
Mike,

Please keep your replies on-list.

On Fri, Sep 05, 2003 at 09:10:05PM -0500, Mike G wrote:
> It sounds like the cygipc-daemon is running the wrong version.  The
> instructions located in the
> readme(http://www.tishler.net/jason/software/postgresql/postgresql-7.3.3.README)
> need to be updated.

Have you seen the following?

    http://www.tishler.net/jason/software/postgresql/postgresql-7.3.4.README

> This is what it should read now:
>
> The following is the NT services Cygwin PostgreSQL installation
> procedure
> (with footnotes designated by "[n]"):
>
> 1. Install the cygipc ipc-daemon as a NT service:
>     A)If you are upgrading from a version prior to 7.3.4-2
>     shutdown the postmaster and cygipc services.
>     close the service manager screen.
>     # ipc-daemon --remove-as-service
>     # ipc-daemon2 --install-as-service
>
>     Next skip to step 4.
>
>     B)If it is a fresh install
>     # ipc-daemon2 --install-as-service
>
> 2. Create the "postgres" user account:
>
>     # net user postgres $password /add /fullname:postgres
> /comment:'PostgreSQL user account' /homedir:"$(cygpath -w
> /home/postgres)" # [11]
>     # mkpasswd -l -u postgres >>/etc/passwd
>
> 3. Grant the "postgres" user the "Log on as a service" user right:
>
>     # cmd /c secpol.msc # [3] [4] [5] [12]
>
> 4. Install postmaster as a NT service:
>     A)If you are upgrading from a version prior to 7.3.4-2
>     # cygrunsrv --remove postmaster
>     # cygrunsrv --install postmaster --path /usr/bin/postmaster --args
> "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user
> postgres --shutdown # [6]
>
>     Skip to step 7.
>
>     B)If you are doing a fresh install:
>     # cygrunsrv --install postmaster --path /usr/bin/postmaster --args
> "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user
> postgres --shutdown # [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 # [10]
>
> 7. Start the cygipc ipc-daemon:
>
>     # net start ipc-daemon2 # [7]
>
>    **If upgrading skip to step 9.
>
> 8. Initialize PostgreSQL (*when running under the "postgres" account*):
>
>     $ initdb -D /usr/share/postgresql/data
>
> 9. Start postmaster:
>
>     # net start postmaster # [7]
>
> 10. Connect to PostgreSQL:
>
>     # psql -U postgres template1 # [8] [9]
>
> The following are the notes to the above:
>
> [snip]

Sorry, but I feel that my README is already too cluttered.  However, I
will add an issue regarding upgrading from 7.3.4-1 or earlier.

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

pgsql-cygwin by date:

Previous
From: Jason Tishler
Date:
Subject: Re: high cpu usage with postgres on windows XP
Next
From: a m
Date:
Subject: Re: high cpu usage with postgres on windows XP