mfvanek / useful-sql-scripts Goto Github PK

docker-compose up
Creating network "7monitoringwithpostgres_exporter_postgres" with driver "bridge"
Creating postgres_container ... done
Creating exporter_container ... done
Creating pgadmin_container  ... done
Attaching to postgres_container, pgadmin_container, exporter_container
postgres_container   | The files belonging to this database system will be owned by user "postgres".
postgres_container   | This user must also own the server process.
postgres_container   | 
postgres_container   | The database cluster will be initialized with locale "en_US.utf8".
postgres_container   | The default database encoding has accordingly been set to "UTF8".
postgres_container   | The default text search configuration will be set to "english".
postgres_container   | 
postgres_container   | Data page checksums are disabled.
exporter_container   | ts=2023-02-02T06:25:11.444Z caller=log.go:168 level=info msg="Listening on address" address=:9187
postgres_container   | 
postgres_container   | fixing permissions on existing directory /var/lib/postgresql/data/pgdata ... ok
exporter_container   | level=info ts=2023-02-02T06:25:11.444Z caller=tls_config.go:191 msg="TLS is disabled." http2=false
postgres_container   | creating subdirectories ... ok
postgres_container   | selecting dynamic shared memory implementation ... posix
postgres_container   | selecting default max_connections ... 100
postgres_container   | selecting default shared_buffers ... 128MB
postgres_container   | selecting default time zone ... Etc/UTC
postgres_container   | creating configuration files ... ok
postgres_container   | running bootstrap script ... ok
postgres_container   | performing post-bootstrap initialization ... ok
postgres_container   | syncing data to disk ... ok
postgres_container   | 
postgres_container   | 
postgres_container   | Success. You can now start the database server using:
postgres_container   | 
postgres_container   |     pg_ctl -D /var/lib/postgresql/data/pgdata -l logfile start
postgres_container   | 
postgres_container   | initdb: warning: enabling "trust" authentication for local connections
postgres_container   | You can change this by editing pg_hba.conf or using the option -A, or
postgres_container   | --auth-local and --auth-host, the next time you run initdb.
postgres_container   | waiting for server to start....2023-02-02 06:25:11.735 UTC [48] LOG:  starting PostgreSQL 14.5 (Debian 14.5-2.pgdg110+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
postgres_container   | 2023-02-02 06:25:11.736 UTC [48] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_container   | 2023-02-02 06:25:11.739 UTC [49] LOG:  database system was shut down at 2023-02-02 06:25:11 UTC
postgres_container   | 2023-02-02 06:25:11.744 UTC [48] LOG:  database system is ready to accept connections
postgres_container   |  done
postgres_container   | server started
postgres_container   | CREATE DATABASE
postgres_container   | 
postgres_container   | 
postgres_container   | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
postgres_container   | 
postgres_container   | 2023-02-02 06:25:11.905 UTC [48] LOG:  received fast shutdown request
postgres_container   | waiting for server to shut down....2023-02-02 06:25:11.905 UTC [48] LOG:  aborting any active transactions
postgres_container   | 2023-02-02 06:25:11.906 UTC [48] LOG:  background worker "logical replication launcher" (PID 55) exited with exit code 1
postgres_container   | 2023-02-02 06:25:11.907 UTC [50] LOG:  shutting down
postgres_container   | 2023-02-02 06:25:11.921 UTC [48] LOG:  database system is shut down
postgres_container   |  done
postgres_container   | server stopped
postgres_container   | 
postgres_container   | PostgreSQL init process complete; ready for start up.
postgres_container   | 
postgres_container   | 2023-02-02 06:25:12.039 UTC [1] LOG:  starting PostgreSQL 14.5 (Debian 14.5-2.pgdg110+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
postgres_container   | 2023-02-02 06:25:12.039 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
postgres_container   | 2023-02-02 06:25:12.040 UTC [1] LOG:  listening on IPv6 address "::", port 5432
postgres_container   | 2023-02-02 06:25:12.041 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_container   | 2023-02-02 06:25:12.044 UTC [62] LOG:  database system was shut down at 2023-02-02 06:25:11 UTC
postgres_container   | 2023-02-02 06:25:12.048 UTC [1] LOG:  database system is ready to accept connections
pgadmin_container    | WARNING: Failed to set ACL on the directory containing the configuration database:
pgadmin_container    |            [Errno 1] Operation not permitted: '/var/lib/pgadmin'
pgadmin_container    | HINT   : You may need to manually set the permissions on
pgadmin_container    |          /var/lib/pgadmin to allow pgadmin to write to it.
pgadmin_container    | ERROR  : Failed to create the directory /var/lib/pgadmin/sessions:
pgadmin_container    |            [Errno 13] Permission denied: '/var/lib/pgadmin/sessions'
pgadmin_container    | HINT   : Create the directory /var/lib/pgadmin/sessions, ensure it is writeable by
pgadmin_container    |          'pgadmin', and try again, or, create a config_local.py file
pgadmin_container    |          and override the SESSION_DB_PATH setting per
pgadmin_container    |          https://www.pgadmin.org/docs/pgadmin4/5.7/config_py.html
pgadmin_container    | [2023-02-02 06:25:28 +0000] [1] [INFO] Starting gunicorn 20.1.0
pgadmin_container    | [2023-02-02 06:25:28 +0000] [1] [INFO] Listening at: http://[::]:80 (1)
pgadmin_container    | [2023-02-02 06:25:28 +0000] [1] [INFO] Using worker: gthread
pgadmin_container    | [2023-02-02 06:25:28 +0000] [92] [INFO] Booting worker with pid: 92
pgadmin_container    | [2023-02-02 06:25:39 +0000] [92] [INFO] Worker exiting (pid: 92)
pgadmin_container    | WARNING: Failed to set ACL on the directory containing the configuration database:
pgadmin_container    |            [Errno 1] Operation not permitted: '/var/lib/pgadmin'
pgadmin_container    | HINT   : You may need to manually set the permissions on
pgadmin_container    |          /var/lib/pgadmin to allow pgadmin to write to it.
pgadmin_container    | ERROR  : Failed to create the directory /var/lib/pgadmin/sessions:
pgadmin_container    |            [Errno 13] Permission denied: '/var/lib/pgadmin/sessions'
pgadmin_container    | HINT   : Create the directory /var/lib/pgadmin/sessions, ensure it is writeable by
pgadmin_container    |          'pgadmin', and try again, or, create a config_local.py file
pgadmin_container    |          and override the SESSION_DB_PATH setting per
pgadmin_container    |          https://www.pgadmin.org/docs/pgadmin4/5.7/config_py.html
pgadmin_container    | [2023-02-02 06:25:39 +0000] [93] [INFO] Booting worker with pid: 93
pgadmin_container    | [2023-02-02 06:25:50 +0000] [93] [INFO] Worker exiting (pid: 93)
pgadmin_container    | WARNING: Failed to set ACL on the directory containing the configuration database:
pgadmin_container    |            [Errno 1] Operation not permitted: '/var/lib/pgadmin'
pgadmin_container    | HINT   : You may need to manually set the permissions on
pgadmin_container    |          /var/lib/pgadmin to allow pgadmin to write to it.
pgadmin_container    | ERROR  : Failed to create the directory /var/lib/pgadmin/sessions:
pgadmin_container    |            [Errno 13] Permission denied: '/var/lib/pgadmin/sessions'
pgadmin_container    | HINT   : Create the directory /var/lib/pgadmin/sessions, ensure it is writeable by
pgadmin_container    |          'pgadmin', and try again, or, create a config_local.py file
pgadmin_container    |          and override the SESSION_DB_PATH setting per
pgadmin_container    |          https://www.pgadmin.org/docs/pgadmin4/5.7/config_py.html
pgadmin_container    | [2023-02-02 06:25:50 +0000] [94] [INFO] Booting worker with pid: 94
pgadmin_container    | [2023-02-02 06:26:00 +0000] [94] [INFO] Worker exiting (pid: 94)
pgadmin_container    | WARNING: Failed to set ACL on the directory containing the configuration database:
pgadmin_container    |            [Errno 1] Operation not permitted: '/var/lib/pgadmin'
pgadmin_container    | HINT   : You may need to manually set the permissions on
pgadmin_container    |          /var/lib/pgadmin to allow pgadmin to write to it.
pgadmin_container    | ERROR  : Failed to create the directory /var/lib/pgadmin/sessions:
pgadmin_container    |            [Errno 13] Permission denied: '/var/lib/pgadmin/sessions'
pgadmin_container    | HINT   : Create the directory /var/lib/pgadmin/sessions, ensure it is writeable by
pgadmin_container    |          'pgadmin', and try again, or, create a config_local.py file
pgadmin_container    |          and override the SESSION_DB_PATH setting per
pgadmin_container    |          https://www.pgadmin.org/docs/pgadmin4/5.7/config_py.html
pgadmin_container    | [2023-02-02 06:26:01 +0000] [95] [INFO] Booting worker with pid: 95
pgadmin_container    | [2023-02-02 06:26:09 +0000] [95] [INFO] Worker exiting (pid: 95)
pgadmin_container    | WARNING: Failed to set ACL on the directory containing the configuration database:
pgadmin_container    |            [Errno 1] Operation not permitted: '/var/lib/pgadmin'
pgadmin_container    | HINT   : You may need to manually set the permissions on
pgadmin_container    |          /var/lib/pgadmin to allow pgadmin to write to it.
pgadmin_container    | ERROR  : Failed to create the directory /var/lib/pgadmin/sessions:
pgadmin_container    |            [Errno 13] Permission denied: '/var/lib/pgadmin/sessions'
pgadmin_container    | HINT   : Create the directory /var/lib/pgadmin/sessions, ensure it is writeable by
pgadmin_container    |          'pgadmin', and try again, or, create a config_local.py file
pgadmin_container    |          and override the SESSION_DB_PATH setting per
pgadmin_container    |          https://www.pgadmin.org/docs/pgadmin4/5.7/config_py.html
pgadmin_container    | [2023-02-02 06:26:09 +0000] [96] [INFO] Booting worker with pid: 96
pgadmin_container    | [2023-02-02 06:26:17 +0000] [96] [INFO] Worker exiting (pid: 96)
pgadmin_container    | WARNING: Failed to set ACL on the directory containing the configuration database:
pgadmin_container    |            [Errno 1] Operation not permitted: '/var/lib/pgadmin'
pgadmin_container    | HINT   : You may need to manually set the permissions on
pgadmin_container    |          /var/lib/pgadmin to allow pgadmin to write to it.
pgadmin_container    | ERROR  : Failed to create the directory /var/lib/pgadmin/sessions:
pgadmin_container    |            [Errno 13] Permission denied: '/var/lib/pgadmin/sessions'
pgadmin_container    | HINT   : Create the directory /var/lib/pgadmin/sessions, ensure it is writeable by
pgadmin_container    |          'pgadmin', and try again, or, create a config_local.py file
pgadmin_container    |          and override the SESSION_DB_PATH setting per
pgadmin_container    |          https://www.pgadmin.org/docs/pgadmin4/5.7/config_py.html
pgadmin_container    | [2023-02-02 06:26:17 +0000] [97] [INFO] Booting worker with pid: 97