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-17 10:04:54.562 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-17 10:04:54.590 UTC [53] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-03-17 10:04:54.666 UTC [54] LOG:  database system was shut down at 2021-03-17 10:04:53 UTC
2021-03-17 10:04:54.692 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-17 10:04:55.819 UTC [53] LOG:  received fast shutdown request
waiting for server to shut down....2021-03-17 10:04:55.843 UTC [53] LOG:  aborting any active transactions
2021-03-17 10:04:55.844 UTC [53] LOG:  background worker "logical replication launcher" (PID 60) exited with exit code 1
2021-03-17 10:04:55.844 UTC [55] LOG:  shutting down
2021-03-17 10:04:56.047 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-17 10:04:56.190 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-17 10:04:56.191 UTC [78] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2021-03-17 10:04:56.191 UTC [78] LOG:  listening on IPv6 address "::", port 5432
2021-03-17 10:04:56.227 UTC [78] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-03-17 10:04:56.277 UTC [79] LOG:  database system was shut down at 2021-03-17 10:04:56 UTC
2021-03-17 10:04:56.304 UTC [78] LOG:  database system is ready to accept connections
 done
server started