Postgress integration test flaky

[sspaink]

Example failure: https://app.circleci.com/pipelines/github/influxdata/telegraf/11009/workflows/f1aff207-4b36-4054-bfa5-f00e3585c951/jobs/180427

Snippet:

waiting for server to shut down....2022-06-13 12:09:30.756 UTC [39] LOG:  received fast shutdown request
2022-06-13 12:09:30.771 UTC [39] LOG:  aborting any active transactions
2022-06-13 12:09:30.773 UTC [39] LOG:  background worker "logical replication launcher" (PID 46) exited with exit code 1
2022-06-13 12:09:30.773 UTC [41] LOG:  shutting down
2022-06-13 12:09:30.819 UTC [39] LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

2022-06-13 12:09:30.870 UTC [1] LOG:  starting PostgreSQL 14.3 on x86_64-pc-linux-musl, compiled by gcc (Alpine 11.2.1_git20220219) 11.2.1 20220219, 64-bit
2022-06-13 12:09:30.870 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2022-06-13 12:09:30.870 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2022-06-13 12:09:30.890 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-06-13 12:09:30.904 UTC [74] LOG:  database system was shut down at 2022-06-13 12:09:30 UTC
--- Container Logs End ---
--- FAIL: TestPostgresqlDatabaseBlacklistTestIntegration (2.46s)
    postgresql_test.go:295: 
        	Error Trace:	postgresql_test.go:295
        	Error:      	Received unexpected error:
        	            	failed to connect to `host=localhost user=postgres database=`: server error (FATAL: the database system is starting up (SQLSTATE 57P03))
        	Test:       	TestPostgresqlDatabaseBlacklistTestIntegration
FAIL
FAIL	github.com/influxdata/telegraf/plugins/inputs/postgresql	39.955s

[powersj]

Looking at the postgres logs, the message we are waiting for occurs twice:

2022-06-13 18:34:33.398 UTC [37] LOG:  database system is ready to accept connections
 done
server started

/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*

waiting for server to shut down....2022-06-13 18:34:33.492 UTC [37] LOG:  received fast shutdown request
2022-06-13 18:34:33.492 UTC [37] LOG:  aborting any active transactions
2022-06-13 18:34:33.493 UTC [37] LOG:  background worker "logical replication launcher" (PID 44) exited with exit code 1
2022-06-13 18:34:33.493 UTC [39] LOG:  shutting down
2022-06-13 18:34:33.504 UTC [37] LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

2022-06-13 18:34:33.601 UTC [1] LOG:  starting PostgreSQL 14.3 on x86_64-pc-linux-musl, compiled by gcc (Alpine 11.2.1_git20220219) 11.2.1 20220219, 64-bit
2022-06-13 18:34:33.601 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2022-06-13 18:34:33.601 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2022-06-13 18:34:33.603 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-06-13 18:34:33.605 UTC [49] LOG:  database system was shut down at 2022-06-13 18:34:33 UTC
2022-06-13 18:34:33.607 UTC [1] LOG:  database system is ready to accept connections

First, the image starts up, then the docker entry point is hit, and the server is shutdown and the init process completes, and then a second time the message shows up.

next steps: 1) review the messages for a better option and/or 2) look to see if there is a configuration or setting to avoid needing to have the service come up and down on DockerHub readme