Search Postgresql Archives

Re: Cannot start the PostgreSQL service

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 01/30/2016 12:33 PM, Igal @ Lucee.org wrote:
On 1/30/2016 12:10 PM, Igal @ Lucee.org wrote:

Did you check the Windows Event Viewer?  When a service fails to start
you should see the details there in the Application log errors.
Sorry, I just realized that you had this:

2016-01-25 18:45:19 GMTFATAL:  the database system is starting up
2016-01-27 01:09:47 GMTFATAL: *role "SYSTEM" does not exist *
pg_ctl: PID file "C:/Program Files
(x86)/PostgreSQL/8.4/data/postmaster.pid" does not exist

So you are using PostgreSQL 8.4?  Not sure why you would do that on a
development machine (assuming that you're not running production servers
on Windows 7 Home)

From a previous post by the OP:

"How did you install Postgres on this machine?
With Hold'em Manager software many years ago.  "


Looks to me like the issue is that the service is running under the
Local System account, which is not recognized by PostgreSQL, and that's
why the log shows [role "SYSTEM" does not exist].  If you have installed
using the installer then you should probably have a "postgres" account
on the machine?  If so, set the service to Log On as that account.



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux