Skip to content

Console Output

+ chmod +x ./ci/init_postgres.sh
+ ./ci/init_postgres.sh postgres
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 /run/postgresql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... 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.

Success. You can now start the database server using:

    pg_ctl -D /run/postgresql/data -l logfile start

waiting for server to start....2021-03-23 14:04:31.423 UTC [53] LOG:  starting PostgreSQL 13.2 (Debian 13.2-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2021-03-23 14:04:31.443 UTC [53] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-03-23 14:04:31.519 UTC [54] LOG:  database system was shut down at 2021-03-23 14:04:30 UTC
2021-03-23 14:04:31.536 UTC [53] LOG:  database system is ready to accept connections
 done
server started

./ci/init_postgres.sh: running ./ci/sql/setup_postgres.sql
CREATE DATABASE
You are now connected to database "basyx-map" as user "postgres".
CREATE SCHEMA
CREATE DATABASE
You are now connected to database "basyx-directory" as user "postgres".
CREATE SCHEMA
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1


2021-03-23 14:04:32.656 UTC [53] LOG:  received fast shutdown request
waiting for server to shut down....2021-03-23 14:04:32.680 UTC [53] LOG:  aborting any active transactions
2021-03-23 14:04:32.681 UTC [53] LOG:  background worker "logical replication launcher" (PID 60) exited with exit code 1
2021-03-23 14:04:32.681 UTC [55] LOG:  shutting down
2021-03-23 14:04:32.900 UTC [53] LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

+ pg_ctl start
waiting for server to start....2021-03-23 14:04:33.027 UTC [78] LOG:  starting PostgreSQL 13.2 (Debian 13.2-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2021-03-23 14:04:33.027 UTC [78] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2021-03-23 14:04:33.027 UTC [78] LOG:  listening on IPv6 address "::", port 5432
2021-03-23 14:04:33.063 UTC [78] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-03-23 14:04:33.114 UTC [79] LOG:  database system was shut down at 2021-03-23 14:04:32 UTC
2021-03-23 14:04:33.140 UTC [78] LOG:  database system is ready to accept connections
 done
server started