Re: Can not start postgresSQL 8.4

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Can not start postgresSQL 8.4
Date: 2012-10-02 09:10:11
Message-ID: k4eb16$luo$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Boriss Redkins, 02.10.2012 10:42:
> I've got postgreSQL 8.4 and 91. installed on my Windows 7 machine. 9.1 version starts just fine. But when trying to start 8.4 with:
>
> Services
> Microsoft Corporation
> Version: 6.1.7600.16385
>
> it does not start and no logs are produced.
>
> When starting in console:
>
> C:\Program Files (x86)\PostgreSQL\8.4\bin>pg_ctl.exe start -D "\Program Files (x
> 86)\PostgreSQL\8.4\data"
> server starting
>
> it starts.
>
> How can I start 8.4 with Services?

Sounds like your service definition is using the wrong user account to start PostgreSQL
(and therefor a possible permission problem on the data directory)

Which Windows user are you using when running pg_ctl from the commandline?

Either that one should be used as the service user, or you need to make sure the user that the service is running under has full access to the data directory.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2012-10-02 09:27:50 Re: Again, problem with pgbouncer
Previous Message Jasen Betts 2012-10-02 09:02:35 Re: Securing .pgpass File?