· 6 years ago · Apr 01, 2020, 07:00 PM
1kothapavan35@DESKTOP-PAVANKOTHA:~$ kubectl logs pg-1 -n default
22020-04-01T18:35:47 INFO: Loading 'Postgres' database engine DLL.
32020-04-01T18:35:47 INFO: Instantiating database engine.
42020-04-01T18:35:47 INFO: Opening V1ConfigMap watch.
52020-04-01T18:35:47 INFO: Configuring REST API.
62020-04-01T18:35:47 INFO: Starting database engine.
72020-04-01T18:35:47 INFO: Initializing new database.
82020-04-01T18:35:47 INFO: Running /bin/su -c "exec pg_autoctl create coordinator --pgctl /usr/lib/postgresql/11/bin/pg_ctl --nodename pg-1.pg-svc.default.svc.cluster.local --monitor postgres://autoctl_node@pg-0.pg-svc.default.svc.cluster.local/pg_auto_failover" postgres...
92020-04-01T18:35:47 INFO: Starting REST API.
1018:35:47 WARN Failed to connect to "postgres://autoctl_node@pg-0.pg-svc.default.svc.cluster.local/pg_auto_failover", retrying until the server is ready
1118:35:47 ERROR Failed to connect after successful ping, please verify authentication and logs on the server at "postgres://autoctl_node@pg-0.pg-svc.default.svc.cluster.local/pg_auto_failover"
1218:35:47 ERROR Connection to database failed: fe_sendauth: no password supplied
13
1418:35:47 ERROR Failed to register node pg-1.pg-svc.default.svc.cluster.local:5432 in group 0 of formation "default" with initial state "init", see previous lines for details
1518:35:47 ERROR Failed to register the existing local Postgres node "pg-1.pg-svc.default.svc.cluster.local:5432" running at "/var/lib/postgresql/data"to the pg_auto_failover monitor at postgres://autoctl_node@pg-0.pg-svc.default.svc.cluster.local/pg_auto_failover, see above for details
162020-04-01T18:35:47 WARN: No XML encryptor configured. Key {94a1ba8e-d4f7-485c-81e8-30aeb47e2723} may be persisted to storage in unencrypted form.
172020-04-01T18:35:47 ERROR: The engine terminated unexpectedly. Exception - pg_autoctl create failed with status 3.
18System.Exception: pg_autoctl create failed with status 3.
19 at Dusky.Agent.Engine.Postgres.PostgresEngine.InitializeDatabase(CancellationToken cancelToken) in /home/kothapavan35/aris-ha/projects/dusky/dotnet/agent/engines/Postgres/PostgresEngine.cs:line 399
20 at Dusky.Agent.Engine.Postgres.PostgresEngine.Run(CancellationToken cancelToken) in /home/kothapavan35/aris-ha/projects/dusky/dotnet/agent/engines/Postgres/PostgresEngine.cs:line 76
212020-04-01T18:35:47 INFO: Shutting down.
222020-04-01T18:35:47 WARN: Unable to bind to http://localhost:8000 on the IPv6 loopback interface: 'Cannot assign requested address'.
23Hosting environment: Production
24Content root path: /
25Now listening on: http://localhost:8000
262020-04-01T18:35:47 INFO: Waiting for database engine to shut down.
27kothapavan35@DESKTOP-PAVANKOTHA:~$ kubectl logs pg-2 -n default
282020-04-01T18:35:41 INFO: Loading 'Postgres' database engine DLL.
292020-04-01T18:35:41 INFO: Instantiating database engine.
302020-04-01T18:35:41 INFO: Opening V1ConfigMap watch.
312020-04-01T18:35:41 INFO: Configuring REST API.
322020-04-01T18:35:41 INFO: Starting database engine.
332020-04-01T18:35:41 INFO: Initializing new database.
342020-04-01T18:35:41 INFO: Running /bin/su -c "exec pg_autoctl create coordinator --pgctl /usr/lib/postgresql/11/bin/pg_ctl --nodename pg-2.pg-svc.default.svc.cluster.local --monitor postgres://autoctl_node@pg-0.pg-svc.default.svc.cluster.local/pg_auto_failover" postgres...
352020-04-01T18:35:41 INFO: Starting REST API.
3618:35:41 WARN Failed to connect to "postgres://autoctl_node@pg-0.pg-svc.default.svc.cluster.local/pg_auto_failover", retrying until the server is ready
372020-04-01T18:35:41 WARN: No XML encryptor configured. Key {23695306-a3fb-4928-9746-e3c04bd62b1c} may be persisted to storage in unencrypted form.
3818:35:41 ERROR Failed to connect after successful ping, please verify authentication and logs on the server at "postgres://autoctl_node@pg-0.pg-svc.default.svc.cluster.local/pg_auto_failover"
3918:35:41 ERROR Connection to database failed: fe_sendauth: no password supplied
40
4118:35:41 ERROR Failed to register node pg-2.pg-svc.default.svc.cluster.local:5432 in group 0 of formation "default" with initial state "init", see previous lines for details
4218:35:41 ERROR Failed to register the existing local Postgres node "pg-2.pg-svc.default.svc.cluster.local:5432" running at "/var/lib/postgresql/data"to the pg_auto_failover monitor at postgres://autoctl_node@pg-0.pg-svc.default.svc.cluster.local/pg_auto_failover, see above for details
432020-04-01T18:35:41 ERROR: The engine terminated unexpectedly. Exception - pg_autoctl create failed with status 3.
44System.Exception: pg_autoctl create failed with status 3.
45 at Dusky.Agent.Engine.Postgres.PostgresEngine.InitializeDatabase(CancellationToken cancelToken) in /home/kothapavan35/aris-ha/projects/dusky/dotnet/agent/engines/Postgres/PostgresEngine.cs:line 399
46 at Dusky.Agent.Engine.Postgres.PostgresEngine.Run(CancellationToken cancelToken) in /home/kothapavan35/aris-ha/projects/dusky/dotnet/agent/engines/Postgres/PostgresEngine.cs:line 76
472020-04-01T18:35:41 INFO: Shutting down.
482020-04-01T18:35:41 WARN: Unable to bind to http://localhost:8000 on the IPv6 loopback interface: 'Cannot assign requested address'.
49Hosting environment: Production
50Content root path: /
51Now listening on: http://localhost:8000
522020-04-01T18:35:41 INFO: Waiting for database engine to shut down.
53
54
55Entry populated correctly
56root@pg-0:/# cat /var/lib/postgresql/data/pg_hba.conf
57local all all trust
58local replication all trust
59host all all .pg.default.svc.cluster.local trust
60host replication all .pg.default.svc.cluster.local trust
61host all all all md5