Re: postgresql on windows 2000

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