Does the Postgresql service actually start? I haven’t looked at windows 8 for a while, but I did install continua ci on it a while back and it ran without problems. We’ll test it again when we get back to work on Wed.
So I’ve started the postgre database using the command: pg_ctl -D “C:\ProgramData\Vsoft\ContinuaCI\PostgreSQLDB” start
Postgre was up and running, so after that I’ve restarted the continua service and same error happens. Double check if any firewall was blocking it, disabled the windows firewall and mcaffe firewall to. Restarted again both services, and same error …
But now looking at windows event log the error is there: Could not initialise database:
Npgsql.NpgsqlException: Failed to establish a connection to ‘127.0.0.1’. em Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context) em Npgsql.NpgsqlConnector.Open() em Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection) em Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection) em Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection) em Npgsql.NpgsqlConnection.Open() em FluentMigrator.Runner.Processors.Postgres.PostgresProcessor…ctor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory) em FluentMigrator.Runner.Processors.Postgres.PostgresProcessorFactory.Create(String connectionString, IAnnouncer announcer, IMigrationProcessorOptions options) em FluentMigrator.Runner.Initialization.TaskExecutor.InitializeProcessor(String assemblyLocation) em FluentMigrator.Runner.Initialization.TaskExecutor.Initialize() em FluentMigrator.Runner.Initialization.TaskExecutor.Execute() em Continua.Migrations.Runner.Execute(String database, String connectionString, String fileName) em Continua.Server.Service.Migrator.Begin() Exiting…
As I could see the connection is not working …
I’ve performed an netstat -an and the default postgree port is listening, are you guys using the default one ? or a custom one ?
Just for future reference, here is the command to register the service: C:\Program Files\VSoft Technologies\ContinuaCI\Server\PostgreSQL\bin>pg_ctl register -N “ContinuaCI PostgreSQL” -U machinename\user -P yourpass -S auto -o “-p 9001” -D “C:\ProgramData\VSoft\ContinuaCI\PostgreSQLDB”
Hmm… strange that the windows 8 upgrade process de-registers the service. I suspect it may mark it as incompatible for whatever reason (who knows with Microsoft these days).
