Thread: postgres in windows xP

postgres in windows xP

From
"James Nyunt"
Date:

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

 

 

Re: postgres in windows xP

From
"Vishal Kashyap @ [SaiHertz]"
Date:
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

Re: postgres in windows xP

From
Juan Miguel
Date:
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
>