The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /var/lib/postgresql/data/pgdata ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... UTC
creating configuration files ... ok
running bootstrap script ... ok
sh: locale: not found
2022-09-13 07:12:51.450 UTC [21] WARNING: no usable system locales were found
performing post-bootstrap initialization ... ok
initdb: warning: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
syncing data to disk ... ok
Success. You can now start the database server using:
pg_ctl -D /var/lib/postgresql/data/pgdata -l logfile start
waiting for server to start....2022-09-13 07:12:59.270 UTC [27] LOG: starting PostgreSQL 14.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20211027) 10.3.1 20211027, 64-bit
2022-09-13 07:12:59.277 UTC [27] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-09-13 07:12:59.295 UTC [28] LOG: database system was shut down at 2022-09-13 07:12:56 UTC
2022-09-13 07:12:59.309 UTC [27] LOG: database system is ready to accept connections
2022-09-13 07:12:59.315 UTC [34] LOG: TimescaleDB background worker launcher connected to shared catalogs
done
server started
CREATE DATABASE
/usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/init-schema.sh
CREATE ROLE
CREATE SCHEMA
GRANT
2022-09-13 07:13:02.398 UTC [49] WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.5.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
2. API reference documentation: https://docs.timescale.com/api/latest
3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts
Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescale.com/timescaledb/latest/how-to-guides/configuration/telemetry.
2022-09-13 07:13:02.398 UTC [49] CONTEXT: PL/pgSQL function inline_code_block line 12 at RAISE
WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 2.5.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started
2. API reference documentation: https://docs.timescale.com/api/latest
3. How TimescaleDB is designed: https://docs.timescale.com/timescaledb/latest/overview/core-concepts
Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescale.com/timescaledb/latest/how-to-guides/configuration/telemetry.
CREATE EXTENSION
waiting for server to shut down...2022-09-13 07:13:02.415 UTC [27] LOG: received fast shutdown request
.2022-09-13 07:13:02.417 UTC [27] LOG: aborting any active transactions
2022-09-13 07:13:02.417 UTC [49] FATAL: terminating connection due to administrator command
2022-09-13 07:13:02.417 UTC [49] LOG: could not send data to client: Broken pipe
2022-09-13 07:13:02.417 UTC [50] LOG: terminating TimescaleDB job scheduler due to administrator command
terminating TimescaleDB background worker launcher due to administrator command2022-09-13 07:13:02.417 UTC [34] FATAL: terminating background worker "TimescaleDB Background Worker Launcher" due to administrator command
2022-09-13 07:13:02.418 UTC [50] LOG: terminating TimescaleDB job scheduler due to administrator command
2022-09-13 07:13:02.418 UTC [50] FATAL: terminating background worker "TimescaleDB Background Worker Scheduler" due to administrator command
2022-09-13 07:13:02.418 UTC [27] LOG: background worker "logical replication launcher" (PID 35) exited with exit code 1
2022-09-13 07:13:02.419 UTC [27] LOG: background worker "TimescaleDB Background Worker Scheduler" (PID 50) exited with exit code 1
2022-09-13 07:13:02.420 UTC [27] LOG: background worker "TimescaleDB Background Worker Launcher" (PID 34) exited with exit code 1
2022-09-13 07:13:02.501 UTC [29] LOG: shutting down
2022-09-13 07:13:02.667 UTC [27] LOG: database system is shut down
done
server stopped
PostgreSQL init process complete; ready for start up.
2022-09-13 07:13:02.773 UTC [1] LOG: starting PostgreSQL 14.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20211027) 10.3.1 20211027, 64-bit
2022-09-13 07:13:02.773 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2022-09-13 07:13:02.774 UTC [1] LOG: listening on IPv6 address "::", port 5432
2022-09-13 07:13:02.800 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-09-13 07:13:02.823 UTC [52] LOG: database system was shut down at 2022-09-13 07:13:02 UTC
2022-09-13 07:13:02.839 UTC [1] LOG: database system is ready to accept connections
2022-09-13 07:13:02.847 UTC [58] LOG: TimescaleDB background worker launcher connected to shared catalogs
2022-09-13 07:13:03.474 UTC [62] LOG: the "timescaledb" extension is not up-to-date
2022-09-13 07:13:03.474 UTC [62] HINT: The most up-to-date version is 2.8.0, the installed version is 2.5.1.
2022-09-13 07:25:19.588 UTC [304] ERROR: relation "cpstemporaldb.databasechangeloglock" does not exist at character 22
2022-09-13 07:25:19.588 UTC [304] STATEMENT: SELECT COUNT(*) FROM cpstemporaldb.databasechangeloglock
2022-09-13 08:13:03.466 UTC [1294] LOG: the "timescaledb" extension is not up-to-date
2022-09-13 08:13:03.466 UTC [1294] HINT: The most up-to-date version is 2.8.0, the installed version is 2.5.1.
2022-09-13 09:13:03.512 UTC [2528] LOG: the "timescaledb" extension is not up-to-date
2022-09-13 09:13:03.512 UTC [2528] HINT: The most up-to-date version is 2.8.0, the installed version is 2.5.1.
2022-09-13 10:13:03.487 UTC [3767] LOG: the "timescaledb" extension is not up-to-date
2022-09-13 10:13:03.487 UTC [3767] HINT: The most up-to-date version is 2.8.0, the installed version is 2.5.1.
2022-09-13 11:13:03.492 UTC [5006] LOG: the "timescaledb" extension is not up-to-date
2022-09-13 11:13:03.492 UTC [5006] HINT: The most up-to-date version is 2.8.0, the installed version is 2.5.1.