Re: postgresql on windows 2000 - Mailing list pgsql-cygwin
From | raj_14_11@rec-all.com |
---|---|
Subject | Re: postgresql on windows 2000 |
Date | |
Msg-id | Email.ipbmatorfsl@rec-all.com Whole thread Raw |
In response to | postgresql on windows 2000 (raj_14_11@rec-all.com) |
List | pgsql-cygwin |
Hi i have tried all possibilities and followed all the instructions but when it comes to start postmaster i get this ******************************************** $ net start postmaster The postmaster service is starting. The postmaster service could not be started. The service did not report an error. More help is available by typing NET HELPMSG 3534. $ NET HELPMSG 3534 The service did not report an error. EXPLANATION The service did not report an error. ACTION Try the task later. If the problem persists, contact your network administrator. ******************************************** can anybody help me ? >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 > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) --------------------------------------------- WWW.rec-all.com - a community of all the RECs
pgsql-cygwin by date: