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 13:56:35.750 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 13:56:35.770 UTC [53] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-03-23 13:56:35.846 UTC [54] LOG:  database system was shut down at 2021-03-23 13:56:34 UTC
2021-03-23 13:56:35.872 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


waiting for server to shut down...2021-03-23 13:56:36.916 UTC [53] LOG:  received fast shutdown request
.2021-03-23 13:56:36.940 UTC [53] LOG:  aborting any active transactions
2021-03-23 13:56:36.941 UTC [53] LOG:  background worker "logical replication launcher" (PID 60) exited with exit code 1
2021-03-23 13:56:36.941 UTC [55] LOG:  shutting down
2021-03-23 13:56:37.144 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 13:56:37.279 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 13:56:37.279 UTC [78] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2021-03-23 13:56:37.279 UTC [78] LOG:  listening on IPv6 address "::", port 5432
2021-03-23 13:56:37.316 UTC [78] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-03-23 13:56:37.358 UTC [79] LOG:  database system was shut down at 2021-03-23 13:56:37 UTC
2021-03-23 13:56:37.384 UTC [78] LOG:  database system is ready to accept connections
 done
server started