Thread: postgres in windows xP
Hi
I have been trying to get postgres in windows through cygwin. No success yet. I followed all the instructions in postgresql-7.4.5 step by step. But the last a few steps, particularly, in step 9, cygrunsrv –S postmaster doesn’t work. I could not start postmaster as service at all. I have added postgres to log on as service in secpol.msc. I can also see postmaster in service, in postmaster’s property, log in tab, I can also see postgres.
Ok, here are a few messages, I got, I tried both commands cygrunsrv and net start.
When I run as admin user , who got admin right, I got these errors
admin@laptop ~
$ cygrunsrv -S postmaster
cygrunsrv: Error starting a service: QueryServiceStatus: Win32 error 1062:
The service has not been started.
admin@laptop ~
$ net start postmaster
The postmaster service is starting.
The postmaster service could not be started.
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.
When I run as postgres user, who got limited right, I got these
postgres@laptop ~
$ cygrunsrv -S postmaster
cygrunsrv: Error starting a service: OpenSCManager: Win32 error 5:
Access is denied.
postgres@laptop ~
$ net start postmaster
System error 5 has occurred.
Access is denied.
Any Help please,
With many thanks
James
Dear James , I dont know why you want to stick to cygwin when a windows port for PostgreSQL is available just download it at ftp://ftp22.us.postgresql.org/mirrors/ftp.postgresql.org/win32/postgresql-8.0.0-beta5-en.zip Kindly note its in beta state thus requesting you to use at maximum and report errors / bugs here. -- With Best Regards, Vishal Kashyap. Lead Software Developer, http://saihertz.com, http://vishalkashyap.tk
I suggest that you try with Postgresql 8. It's already in beta phase, but is Windows native, and does not need cygwin. The performance of postgres with cygwin is poor. > Hi > > I have been trying to get postgres in windows through cygwin. No > success yet. I followed all the instructions in postgresql-7.4.5 step > by step. But the last a few steps, particularly, in step 9, /cygrunsrv > –S postmaster / doesn’t work. I could not start postmaster as service > at all. I have added postgres to log on as service in secpol.msc. I > can also see postmaster in service, in postmaster’s property, log in > tab, I can also see postgres. > > Ok, here are a few messages, I got, I tried both commands cygrunsrv > and net start. > > When I run as admin user , who got admin right, I got these errors > > admin@laptop ~ > > $ cygrunsrv -S postmaster > > cygrunsrv: Error starting a service: QueryServiceStatus: Win32 error 1062: > > The service has not been started. > > admin@laptop ~ > > $ net start postmaster > > The postmaster service is starting. > > The postmaster service could not be started. > > A system error has occurred. > > System error 1067 has occurred. > > The process terminated unexpectedly. > > When I run as postgres user, who got limited right, I got these > > postgres@laptop ~ > > $ cygrunsrv -S postmaster > > cygrunsrv: Error starting a service: OpenSCManager: Win32 error 5: > > Access is denied. > > postgres@laptop ~ > > $ net start postmaster > > System error 5 has occurred. > > Access is denied. > > Any Help please, > > With many thanks > > James >