Thread: postgresql on windows 2000
Hi, i am new to postgresql and trying to use postgresql on following configuration and getting the following error. ********************************************** Microsoft windows 2000 Version 5.0 (build 2195 : service pack 4) postgresql-7.3.4-2 cygwin 2.340.2.5 creating template1 database in /data/base/1... IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: Function not implemented ********************************************** Can you please help me to find a workaround so that it works successfully. regards, Rajesh --------------------------------------------- WWW.rec-all.com - a community of all the RECs
As I said before it is a mather of ipc-daemon - it has to be running if want to start postmaster, initdb etc... So you should open bash shell and write "ipc-daemon &" > -----Original Message----- > From: pgsql-cygwin-owner@postgresql.org > [mailto:pgsql-cygwin-owner@postgresql.org] On Behalf Of > raj_14_11@rec-all.com > Sent: Friday, September 05, 2003 9:06 AM > To: pgsql-cygwin@postgresql.org > Subject: [CYGWIN] postgresql on windows 2000 > > > Hi, > i am new to postgresql and trying to use postgresql on > following configuration and getting the following error. > ********************************************** > Microsoft windows 2000 > Version 5.0 (build 2195 : service pack 4) > postgresql-7.3.4-2 > cygwin 2.340.2.5 > > > creating template1 database in /data/base/1... > IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: > Function not implemented > > > ********************************************** > Can you please help me to find a workaround so that it works > successfully. > > > regards, > Rajesh > > --------------------------------------------- > WWW.rec-all.com - a community of all the RECs > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index > scan if your > joining column's datatypes do not match >
Probably it's a problem with cygwin1.dll. Ok., you should do something else - after executing ipc-daemon you should check if it was loaded (go to task manager and find ipc-daemon process). I don't think, that ipc-daemon was loaded correctly. > -----Original Message----- > From: raj_14_11@rec-all.com [mailto:raj_14_11@rec-all.com] > Sent: Friday, September 05, 2003 9:37 AM > To: newsy@lewczuk.com > Subject: Re:RE: [CYGWIN] postgresql on windows 2000 > > > after all installations when i start cygwin i get the > following message > "Your username or group hasn't been setup correctly. > This typically happens if you are a domain user > (cygwin does not automatically create /etc/passwd or > /etc/group for domain users)" > > than i run > "ipc-daemon &" command it returns me "[1] 1688" > after all this when i run "initdb -D /data" > i get the following error > "The files belonging to this database system will be owned by > user "rajesh". This user must also own the server process. > > The database cluster will be initialized with locale EN_US. > This locale setting will prevent the use of indexes for > pattern matching operations. If that is a concern, rerun > initdb with the collation order set to "C". For more > information see the Administrator's Guide. > > creating directory /data... ok > creating directory /data/base... ok > creating directory /data/global... ok > creating directory /data/pg_xlog... ok > creating directory /data/pg_clog... ok > creating template1 database in /data/base/1... > IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: > Function not implemented > > initdb failed. > Removing /data. > " > > >As I said before it is a mather of ipc-daemon - it has to be > running if > >want to start postmaster, initdb etc... So you should open > bash shell > >and write "ipc-daemon &" > > > >> -----Original Message----- > >> From: pgsql-cygwin-owner@postgresql.org > >> [mailto:pgsql-cygwin-owner@postgresql.org] On Behalf Of > >> raj_14_11@rec-all.com > >> Sent: Friday, September 05, 2003 9:06 AM > >> To: pgsql-cygwin@postgresql.org > >> Subject: [CYGWIN] postgresql on windows 2000 > >> > >> > >> Hi, > >> i am new to postgresql and trying to use postgresql on > >> following configuration and getting the following error. > >> ********************************************** > >> Microsoft windows 2000 > >> Version 5.0 (build 2195 : service pack 4) > >> postgresql-7.3.4-2 > >> cygwin 2.340.2.5 > >> > >> > >> creating template1 database in /data/base/1... > >> IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: > >> Function not implemented > >> > >> > >> ********************************************** > >> Can you please help me to find a workaround so that it works > >> successfully. > >> > >> > >> regards, > >> Rajesh > >> > >> --------------------------------------------- > >> WWW.rec-all.com - a community of all the RECs > >> > >> ---------------------------(end of > >> broadcast)--------------------------- > >> TIP 9: the planner will ignore your desire to choose an index > >> scan if your > >> joining column's datatypes do not match > >> > > > > > > > > --------------------------------------------- > WWW.rec-all.com - a community of all the RECs >
Ok., now check if file called cygwin1.dll in windows/system or windows/system32 folder is the same which is in cygwin/bin folder... . > -----Original Message----- > From: raj_14_11@rec-all.com [mailto:raj_14_11@rec-all.com] > Sent: Friday, September 05, 2003 9:44 AM > To: newsy@lewczuk.com > Subject: Re:Re: [CYGWIN] postgresql on windows 2000 > > > ya its there in task manager with pid 600 > > >Probably it's a problem with cygwin1.dll. Ok., you should do > something > >else - after executing ipc-daemon you should check if it was > loaded (go > >to task manager and find ipc-daemon process). I don't think, that > >ipc-daemon was loaded correctly. > > > >> -----Original Message----- > >> From: raj_14_11@rec-all.com [mailto:raj_14_11@rec-all.com] > >> Sent: Friday, September 05, 2003 9:37 AM > >> To: newsy@lewczuk.com > >> Subject: Re:RE: [CYGWIN] postgresql on windows 2000 > >> > >> > >> after all installations when i start cygwin i get the > >> following message > >> "Your username or group hasn't been setup correctly. > >> This typically happens if you are a domain user > >> (cygwin does not automatically create /etc/passwd or > >> /etc/group for domain users)" > >> > >> than i run > >> "ipc-daemon &" command it returns me "[1] 1688" > >> after all this when i run "initdb -D /data" > >> i get the following error > >> "The files belonging to this database system will be owned by > >> user "rajesh". This user must also own the server process. > >> > >> The database cluster will be initialized with locale EN_US. > >> This locale setting will prevent the use of indexes for > >> pattern matching operations. If that is a concern, rerun > >> initdb with the collation order set to "C". For more > >> information see the Administrator's Guide. > >> > >> creating directory /data... ok > >> creating directory /data/base... ok > >> creating directory /data/global... ok > >> creating directory /data/pg_xlog... ok > >> creating directory /data/pg_clog... ok > >> creating template1 database in /data/base/1... > >> IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: > >> Function not implemented > >> > >> initdb failed. > >> Removing /data. > >> " > >> > >> >As I said before it is a mather of ipc-daemon - it has to be > >> running if > >> >want to start postmaster, initdb etc... So you should open > >> bash shell > >> >and write "ipc-daemon &" > >> > > >> >> -----Original Message----- > >> >> From: pgsql-cygwin-owner@postgresql.org > >> >> [mailto:pgsql-cygwin-owner@postgresql.org] On Behalf Of > >> >> raj_14_11@rec-all.com > >> >> Sent: Friday, September 05, 2003 9:06 AM > >> >> To: pgsql-cygwin@postgresql.org > >> >> Subject: [CYGWIN] postgresql on windows 2000 > >> >> > >> >> > >> >> Hi, > >> >> i am new to postgresql and trying to use postgresql on > following > >> >> configuration and getting the following error. > >> >> ********************************************** > >> >> Microsoft windows 2000 > >> >> Version 5.0 (build 2195 : service pack 4) postgresql-7.3.4-2 > >> >> cygwin 2.340.2.5 > >> >> > >> >> > >> >> creating template1 database in /data/base/1... > >> >> IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: > >> >> Function not implemented > >> >> > >> >> > >> >> ********************************************** > >> >> Can you please help me to find a workaround so that it works > >> >> successfully. > >> >> > >> >> > >> >> regards, > >> >> Rajesh > >> >> > >> >> --------------------------------------------- > >> >> WWW.rec-all.com - a community of all the RECs > >> >> > >> >> ---------------------------(end of > >> >> broadcast)--------------------------- > >> >> TIP 9: the planner will ignore your desire to choose an index > >> >> scan if your > >> >> joining column's datatypes do not match > >> >> > >> > > >> > > >> > > >> > >> --------------------------------------------- > >> WWW.rec-all.com - a community of all the RECs > >> > > > > > > > > > >---------------------------(end of > >broadcast)--------------------------- > >TIP 9: the planner will ignore your desire to choose an > index scan if your > > joining column's datatypes do not match > > --------------------------------------------- > WWW.rec-all.com - a community of all the RECs >
On Fri, Sep 05, 2003 at 10:34:51AM +0100, Marek Lewczuk wrote:
> As I said before it is a mather of ipc-daemon - it has to be running
> if want to start postmaster, initdb etc... So you should open bash
> shell and write "ipc-daemon &"
The above is not quite correct. If Rajesh is using postgresql-7.3.4-2,
then he must install cypipc 2.01-2 and start ipc-daemon2.
> > -----Original Message-----
> > From: pgsql-cygwin-owner@postgresql.org
> > [mailto:pgsql-cygwin-owner@postgresql.org] On Behalf Of
> > raj_14_11@rec-all.com
> > Sent: Friday, September 05, 2003 9:06 AM
> > To: pgsql-cygwin@postgresql.org
> > Subject: [CYGWIN] postgresql on windows 2000
> >
> > i am new to postgresql and trying to use postgresql on
> > following configuration and getting the following error.
> > **********************************************
> > Microsoft windows 2000
> > Version 5.0 (build 2195 : service pack 4)
> > postgresql-7.3.4-2
^^^^^^^
> > cygwin 2.340.2.5
> >
> > creating template1 database in /data/base/1...
> > IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed:
> > Function not implemented
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
Exactly. Know I remember. > -----Original Message----- > From: Jason Tishler [mailto:jason@tishler.net] > Sent: Friday, September 05, 2003 1:18 PM > To: Marek Lewczuk > Cc: raj_14_11@rec-all.com; pgsql-cygwin@postgresql.org > Subject: Re: [CYGWIN] postgresql on windows 2000 > > > On Fri, Sep 05, 2003 at 10:34:51AM +0100, Marek Lewczuk wrote: > > As I said before it is a mather of ipc-daemon - it has to > be running > > if want to start postmaster, initdb etc... So you should open bash > > shell and write "ipc-daemon &" > > The above is not quite correct. If Rajesh is using > postgresql-7.3.4-2, then he must install cypipc 2.01-2 and > start ipc-daemon2. > > > > -----Original Message----- > > > From: pgsql-cygwin-owner@postgresql.org > > > [mailto:pgsql-cygwin-owner@postgresql.org] On Behalf Of > > > raj_14_11@rec-all.com > > > Sent: Friday, September 05, 2003 9:06 AM > > > To: pgsql-cygwin@postgresql.org > > > Subject: [CYGWIN] postgresql on windows 2000 > > > > > > i am new to postgresql and trying to use postgresql on > > > following configuration and getting the following error. > > > ********************************************** > > > Microsoft windows 2000 > > > Version 5.0 (build 2195 : service pack 4) > > > postgresql-7.3.4-2 > ^^^^^^^ > > > cygwin 2.340.2.5 > > > > > > creating template1 database in /data/base/1... > > > IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: > > > Function not implemented > > 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 >
> > Exactly. Know I remember. I mean: Now I remember...!!! Mistakes happends... > > > -----Original Message----- > > From: Jason Tishler [mailto:jason@tishler.net] > > Sent: Friday, September 05, 2003 1:18 PM > > To: Marek Lewczuk > > Cc: raj_14_11@rec-all.com; pgsql-cygwin@postgresql.org > > Subject: Re: [CYGWIN] postgresql on windows 2000 > > > > > > On Fri, Sep 05, 2003 at 10:34:51AM +0100, Marek Lewczuk wrote: > > > As I said before it is a mather of ipc-daemon - it has to > > be running > > > if want to start postmaster, initdb etc... So you should open bash > > > shell and write "ipc-daemon &" > > > > The above is not quite correct. If Rajesh is using > > postgresql-7.3.4-2, then he must install cypipc 2.01-2 and > > start ipc-daemon2. > > > > > > -----Original Message----- > > > > From: pgsql-cygwin-owner@postgresql.org > > > > [mailto:pgsql-cygwin-owner@postgresql.org] On Behalf Of > > > > raj_14_11@rec-all.com > > > > Sent: Friday, September 05, 2003 9:06 AM > > > > To: pgsql-cygwin@postgresql.org > > > > Subject: [CYGWIN] postgresql on windows 2000 > > > > > > > > i am new to postgresql and trying to use postgresql on > following > > > > configuration and getting the following error. > > > > ********************************************** > > > > Microsoft windows 2000 > > > > Version 5.0 (build 2195 : service pack 4) postgresql-7.3.4-2 > > ^^^^^^^ > > > > cygwin 2.340.2.5 > > > > > > > > creating template1 database in /data/base/1... > > > > IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: > > > > Function not implemented > > > > 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 5: Have you checked our extensive FAQ? > http://www.postgresql.org/docs/faqs/FAQ.html
"cypipc 2.01-2" download comes with a patch also.how to apply that patch for cypipc 2.01-2? >> >> Exactly. Know I remember. > >I mean: Now I remember...!!! Mistakes happends... > >> >> > -----Original Message----- >> > From: Jason Tishler [mailto:jason@tishler.net] >> > Sent: Friday, September 05, 2003 1:18 PM >> > To: Marek Lewczuk >> > Cc: raj_14_11@rec-all.com; pgsql-cygwin@postgresql.org >> > Subject: Re: [CYGWIN] postgresql on windows 2000 >> > >> > >> > On Fri, Sep 05, 2003 at 10:34:51AM +0100, Marek Lewczuk wrote: >> > > As I said before it is a mather of ipc-daemon - it has to >> > be running >> > > if want to start postmaster, initdb etc... So you should open bash >> > > shell and write "ipc-daemon &" >> > >> > The above is not quite correct. If Rajesh is using >> > postgresql-7.3.4-2, then he must install cypipc 2.01-2 and >> > start ipc-daemon2. >> > >> > > > -----Original Message----- >> > > > From: pgsql-cygwin-owner@postgresql.org >> > > > [mailto:pgsql-cygwin-owner@postgresql.org] On Behalf Of >> > > > raj_14_11@rec-all.com >> > > > Sent: Friday, September 05, 2003 9:06 AM >> > > > To: pgsql-cygwin@postgresql.org >> > > > Subject: [CYGWIN] postgresql on windows 2000 >> > > > >> > > > i am new to postgresql and trying to use postgresql on >> following >> > > > configuration and getting the following error. >> > > > ********************************************** >> > > > Microsoft windows 2000 >> > > > Version 5.0 (build 2195 : service pack 4) postgresql-7.3.4-2 >> > ^^^^^^^ >> > > > cygwin 2.340.2.5 >> > > > >> > > > creating template1 database in /data/base/1... >> > > > IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: >> > > > Function not implemented >> > >> > 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 5: Have you checked our extensive FAQ? >> > http://www.postgresql.org/docs/faqs/FAQ.html > > > > >---------------------------(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
Rajesh,
Please keep your replies on-list.
On Fri, Sep 05, 2003 at 07:45:14PM +0700, raj_14_11@rec-all.com wrote:
> Thx jason.
You are welcome.
> But one question "cygipc-2.00" comes with a patch also how to use that
> ??
Huh? Sorry, but I don't understand the above.
Please read the README:
http://www.tishler.net/jason/software/postgresql/postgresql-7.3.4.README
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
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
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
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
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
On Wed, Sep 10, 2003 at 12:38:13PM +0700, raj_14_11@rec-all.com wrote:
> 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.
The above is normal and just means the service has stopped.
Anyway, did you read my post from yesterday?
http://archives.postgresql.org/pgsql-cygwin/2003-09/msg00089.php
Sigh... I thought we finally got to the bottom of your problem.
I will try again. Does the following help?
http://cygwin.com/ml/cygwin/2002-12/msg00666.html
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
Thx jason it worked :-) now trying to connect to it from other host.again having some problem. >On Wed, Sep 10, 2003 at 12:38:13PM +0700, raj_14_11@rec-all.com wrote: >> 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. > >The above is normal and just means the service has stopped. > >Anyway, did you read my post from yesterday? > > http://archives.postgresql.org/pgsql-cygwin/2003-09/msg00089.php > >Sigh... I thought we finally got to the bottom of your problem. > >I will try again. Does the following help? > > http://cygwin.com/ml/cygwin/2002-12/msg00666.html > >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 --------------------------------------------- WWW.rec-all.com - a community of all the RECs