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

From Godshall Michael
Subject Re: postgresql on windows 2000
Date
Msg-id A596FA3368757645AF862C701495CA0001B4453D@hor1mspmx01.gmachs.com
Whole thread Raw
In response to postgresql on windows 2000  (raj_14_11@rec-all.com)
List pgsql-cygwin

Check your Event Viewer-> Application log.  There might be more information about the error there.

Mike

-----Original Message-----
From: raj_14_11@rec-all.com [mailto:raj_14_11@rec-all.com]
Sent: Monday, September 08, 2003 11:45 PM
To: jason@tishler.net
Cc: pgsql-cygwin@postgresql.org; godsham@speakeasy.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(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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

pgsql-cygwin by date:

Previous
From: Jason Tishler
Date:
Subject: Re: Windows XP SP1, PostgreSQL 7.2.4, Cygwin 1.3.22, CygIPC 1.14-1
Next
From: raj_14_11@rec-all.com
Date:
Subject: Re: postgresql on windows 2000