Re: postgresql on windows 2000
| От | raj_14_11@rec-all.com |
|---|---|
| Тема | Re: postgresql on windows 2000 |
| Дата | |
| Msg-id | Email.gptJa3fQfrg@rec-all.com обсуждение исходный текст |
| Ответ на | postgresql on windows 2000 (raj_14_11@rec-all.com) |
| Ответы |
Re: postgresql on windows 2000
(Jason Tishler <jason@tishler.net>)
|
| Список | pgsql-cygwin |
i checked the event viewer log also it gives following message "The description for Event ID ( 0 ) in Source ( postmaster ) cannot be found. The local computer may not have the necessaryregistry information or message DLL files to display messages from a remote computer. The following informationis part of the event: postmaster : PID 1924 : `postmaster' service stopped." but i cannot make out anything from it. > > ><P><FONT SIZE=2>Check your Event Viewer-> Application log. There might be more information about the error there.</FONT> ></P> > ><P><FONT SIZE=2>Mike</FONT> ></P> > ><P><FONT SIZE=2>-----Original Message-----</FONT> ><BR><FONT SIZE=2>From: raj_14_11@rec-all.com [<A HREF="mailto:raj_14_11@rec-all.com">mailto:raj_14_11@rec-all.com</A>]</FONT> ><BR><FONT SIZE=2>Sent: Monday, September 08, 2003 11:45 PM</FONT> ><BR><FONT SIZE=2>To: jason@tishler.net</FONT> ><BR><FONT SIZE=2>Cc: pgsql-cygwin@postgresql.org; godsham@speakeasy.net</FONT> ><BR><FONT SIZE=2>Subject: Re: [CYGWIN] postgresql on windows 2000</FONT> ></P> ><BR> > ><P><FONT SIZE=2>Hi</FONT> ><BR><FONT SIZE=2>i have tried all possibilities and followed all the instructions but when it comes to start postmasteri get this </FONT> ><BR><FONT SIZE=2>********************************************</FONT> ><BR><FONT SIZE=2>$ net start postmaster</FONT> ><BR><FONT SIZE=2>The postmaster service is starting.</FONT> ><BR><FONT SIZE=2>The postmaster service could not be started.</FONT> ></P> > ><P><FONT SIZE=2>The service did not report an error.</FONT> ></P> > ><P><FONT SIZE=2>More help is available by typing NET HELPMSG 3534.</FONT> ></P> > ><P><FONT SIZE=2>$ NET HELPMSG 3534</FONT> ></P> > ><P><FONT SIZE=2>The service did not report an error.</FONT> ></P> ><BR> > ><P><FONT SIZE=2>EXPLANATION</FONT> ></P> > ><P><FONT SIZE=2>The service did not report an error.</FONT> ></P> > ><P><FONT SIZE=2>ACTION</FONT> ></P> > ><P><FONT SIZE=2>Try the task later. If the problem persists, contact your network</FONT> ><BR><FONT SIZE=2>administrator.</FONT> ><BR><FONT SIZE=2>********************************************</FONT> ><BR><FONT SIZE=2>can anybody help me ?</FONT> ></P> > ><P><FONT SIZE=2>>Mike,</FONT> ><BR><FONT SIZE=2>></FONT> ><BR><FONT SIZE=2>>Please keep your replies on-list.</FONT> ><BR><FONT SIZE=2>></FONT> ><BR><FONT SIZE=2>>On Fri, Sep 05, 2003 at 09:10:05PM -0500, Mike G wrote:</FONT> ><BR><FONT SIZE=2>>> It sounds like the cygipc-daemon is running the wrong version. The</FONT> ><BR><FONT SIZE=2>>> instructions located in the</FONT> ><BR><FONT SIZE=2>>> readme(<A HREF="http://www.tishler.net/jason/software/postgresql/postgresql-7.3.3.README" TARGET="_blank">http://www.tishler.net/jason/software/postgresql/postgresql-7.3.3.README</A>)</FONT> ><BR><FONT SIZE=2>>> need to be updated.</FONT> ><BR><FONT SIZE=2>></FONT> ><BR><FONT SIZE=2>>Have you seen the following?</FONT> ><BR><FONT SIZE=2>></FONT> ><BR><FONT SIZE=2>> <A HREF="http://www.tishler.net/jason/software/postgresql/postgresql-7.3.4.README" TARGET="_blank">http://www.tishler.net/jason/software/postgresql/postgresql-7.3.4.README</A></FONT> ><BR><FONT SIZE=2>></FONT> ><BR><FONT SIZE=2>>> This is what it should read now:</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> The following is the NT services Cygwin PostgreSQL installation</FONT> ><BR><FONT SIZE=2>>> procedure</FONT> ><BR><FONT SIZE=2>>> (with footnotes designated by "[n]"):</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> 1. Install the cygipc ipc-daemon as a NT service:</FONT> ><BR><FONT SIZE=2>>> A)If you are upgrading from a version prior to 7.3.4-2</FONT> ><BR><FONT SIZE=2>>> shutdown the postmaster and cygipc services.</FONT> ><BR><FONT SIZE=2>>> close the service manager screen.</FONT> ><BR><FONT SIZE=2>>> # ipc-daemon --remove-as-service</FONT> ><BR><FONT SIZE=2>>> # ipc-daemon2 --install-as-service</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> Next skip to step 4.</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> B)If it is a fresh install</FONT> ><BR><FONT SIZE=2>>> # ipc-daemon2 --install-as-service</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> 2. Create the "postgres" user account:</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> # net user postgres $password /add /fullname:postgres</FONT> ><BR><FONT SIZE=2>>> /comment:'PostgreSQL user account' /homedir:"$(cygpath -w</FONT> ><BR><FONT SIZE=2>>> /home/postgres)" # [11]</FONT> ><BR><FONT SIZE=2>>> # mkpasswd -l -u postgres >>/etc/passwd</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> 3. Grant the "postgres" user the "Log on as a service" user right:</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> # cmd /c secpol.msc # [3] [4] [5] [12]</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> 4. Install postmaster as a NT service:</FONT> ><BR><FONT SIZE=2>>> A)If you are upgrading from a version prior to 7.3.4-2</FONT> ><BR><FONT SIZE=2>>> # cygrunsrv --remove postmaster</FONT> ><BR><FONT SIZE=2>>> # cygrunsrv --install postmaster --path /usr/bin/postmaster --args</FONT> ><BR><FONT SIZE=2>>> "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user</FONT> ><BR><FONT SIZE=2>>> postgres --shutdown # [6]</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> Skip to step 7.</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> B)If you are doing a fresh install:</FONT> ><BR><FONT SIZE=2>>> # cygrunsrv --install postmaster --path /usr/bin/postmaster --args</FONT> ><BR><FONT SIZE=2>>> "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user</FONT> ><BR><FONT SIZE=2>>> postgres --shutdown # [6]</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> 5. Create the PostgreSQL data directory:</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> # mkdir /usr/share/postgresql/data</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> 6. Change ownership of the PostgreSQL data directory:</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> # chown postgres /usr/share/postgresql/data # [10]</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> 7. Start the cygipc ipc-daemon:</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> # net start ipc-daemon2 # [7]</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> **If upgrading skip to step 9.</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> 8. Initialize PostgreSQL (*when running under the "postgres" account*):</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> $ initdb -D /usr/share/postgresql/data</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> 9. Start postmaster:</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> # net start postmaster # [7]</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> 10. Connect to PostgreSQL:</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> # psql -U postgres template1 # [8] [9]</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> The following are the notes to the above:</FONT> ><BR><FONT SIZE=2>>> </FONT> ><BR><FONT SIZE=2>>> [snip]</FONT> ><BR><FONT SIZE=2>></FONT> ><BR><FONT SIZE=2>>Sorry, but I feel that my README is already too cluttered. However, I</FONT> ><BR><FONT SIZE=2>>will add an issue regarding upgrading from 7.3.4-1 or earlier.</FONT> ><BR><FONT SIZE=2>></FONT> ><BR><FONT SIZE=2>>Thanks,</FONT> ><BR><FONT SIZE=2>>Jason</FONT> ><BR><FONT SIZE=2>></FONT> ><BR><FONT SIZE=2>>-- </FONT> ><BR><FONT SIZE=2>>PGP/GPG Key: <A HREF="http://www.tishler.net/jason/pubkey.asc" TARGET="_blank">http://www.tishler.net/jason/pubkey.asc</A>or key servers</FONT> ><BR><FONT SIZE=2>>Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6</FONT> ><BR><FONT SIZE=2>></FONT> ><BR><FONT SIZE=2>>---------------------------(end of broadcast)---------------------------</FONT> ><BR><FONT SIZE=2>>TIP 2: you can get off all lists at once with the unregister command</FONT> ><BR><FONT SIZE=2>> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)</FONT> ></P> > ><P><FONT SIZE=2>---------------------------------------------</FONT> ><BR><FONT SIZE=2>WWW.rec-all.com - a community of all the RECs</FONT> ></P> > ><P><FONT SIZE=2>---------------------------(end of broadcast)---------------------------</FONT> ><BR><FONT SIZE=2>TIP 8: explain analyze is your friend</FONT> ></P> > --------------------------------------------- WWW.rec-all.com - a community of all the RECs
В списке pgsql-cygwin по дате отправления: