How to start postrges service

Classic Servoy
1

Hi,
Im having some trouble with postrges, i want to start a postgre service on a local server so that a developer team can all connect to the same database in that server in order to develop a solution. I need all of them to use the same database but when i want to start the service i get a message saying that the service was started and stopped because no service or application was using it.

To start the service im using the “pg_ctl register” command and although the service is created i get that error later when i start it. I then tryied using the “initdb” command but that gives me some errors like that i dont have permission to create a folder (wich is weird cause im logged as an admin). Im preety lost here, besides if i install the postgres admin i get an error during the instalation that the database cluster cannot be started but then it finishes correctly.

Im working on windows server 2008 and with postrges 9.0.1, any help is appreciated
Thanks in advance.

2

Hi,

You installed PostgreSQL via the one-click installer from EnterpriseDB ?
If so this should have installed PostgreSQL as a service for you already and initialized the database cluster directory for you.

Can you check if there is a data directory in your PostgreSQL directory and if anything is in there?
I.e. C:\Program Files\PostgreSQL\9.0\data\ .

Also check the latest log file in the pg_log directory in this data directory.
I.e. C:\Program Files\PostgreSQL\9.0\data\pg_log\ .

3

You might have to set the login for the postgres service to one that has correct privileges.