Quick Links

Re: postgresql on windows 2000

From:	raj_14_11(at)rec-all(dot)com
To:	Michael_Godshall(at)gmachs(dot)com
Cc:	pgsql-cygwin(at)postgresql(dot)org, jason(at)tishler(dot)net
Subject:	Re: postgresql on windows 2000
Date:	2003-09-10 05:38:13
Message-ID:	Email.gptJa3fQfrg@rec-all.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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 necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: postmaster : PID 1924 : `postmaster' service stopped."

but i cannot make out anything from it.
>
>
>Check your Event Viewer-> Application log.  There might be more information about the error there.
>
>
>Mike
>
>
>-----Original Message-----
> From: raj_14_11(at)rec-all(dot)com [<A HREF="mailto:raj_14_11(at)rec-all(dot)com">mailto:raj_14_11(at)rec-all(dot)com</A>]
> Sent: Monday, September 08, 2003 11:45 PM
> To: jason(at)tishler(dot)net
> Cc: pgsql-cygwin(at)postgresql(dot)org; godsham(at)speakeasy(dot)net
> Subject: Re: [CYGWIN] postgresql on windows 2000
>
> 
>
>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(<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>)
> >> need to be updated.
> >
> >Have you seen the following?
> >
> >    <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>
> >
> >> 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: <A HREF="http://www.tishler.net/jason/pubkey.asc" TARGET="_blank">http://www.tishler.net/jason/pubkey.asc</A> 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(at)postgresql(dot)org)
>
>
>---------------------------------------------
> WWW.rec-all.com - a community of all the RECs
>
>
>---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>

---------------------------------------------
WWW.rec-all.com - a community of all the RECs

Responses

Re: postgresql on windows 2000 at 2003-09-10 11:52:20 from Jason Tishler

Browse pgsql-cygwin by date

	From	Date	Subject
Next Message	Jason Tishler	2003-09-10 11:52:20	Re: postgresql on windows 2000
Previous Message	Godshall Michael	2003-09-09 17:33:25	Re: postgresql on windows 2000