Skip to content

Instantly share code, notes, and snippets.

@allenap
Created November 19, 2017 10:05
Show Gist options
  • Save allenap/0819243b57ecbae21be0a85a71becbd5 to your computer and use it in GitHub Desktop.
Save allenap/0819243b57ecbae21be0a85a71becbd5 to your computer and use it in GitHub Desktop.
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 ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
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 /var/lib/postgresql/data -l logfile start
****************************************************
WARNING: No password has been set for the database.
This will allow anyone with access to the
Postgres port to access your database. In
Docker's default configuration, this is
effectively any other container on the same
system.
Use "-e POSTGRES_PASSWORD=password" to set
it in "docker run".
****************************************************
waiting for server to start....2017-11-19 09:54:06.357 UTC [40] LOG: listening on IPv4 address "127.0.0.1", port 5432
2017-11-19 09:54:06.357 UTC [40] LOG: could not bind IPv6 address "::1": Cannot assign requested address
2017-11-19 09:54:06.357 UTC [40] HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2017-11-19 09:54:06.360 UTC [40] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2017-11-19 09:54:06.370 UTC [41] LOG: database system was shut down at 2017-11-19 09:54:06 UTC
2017-11-19 09:54:06.376 UTC [40] LOG: database system is ready to accept connections
done
server started
ALTER ROLE
/usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/docker.sh
waiting for server to shut down....2017-11-19 09:54:06.503 UTC [40] LOG: received fast shutdown request
2017-11-19 09:54:06.504 UTC [40] LOG: aborting any active transactions
2017-11-19 09:54:06.506 UTC [40] LOG: worker process: logical replication launcher (PID 47) exited with exit code 1
2017-11-19 09:54:06.507 UTC [42] LOG: shutting down
2017-11-19 09:54:06.518 UTC [40] LOG: database system is shut down
done
server stopped
PostgreSQL init process complete; ready for start up.
2017-11-19 09:54:06.624 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2017-11-19 09:54:06.624 UTC [1] LOG: listening on IPv6 address "::", port 5432
2017-11-19 09:54:06.628 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2017-11-19 09:54:06.638 UTC [63] LOG: database system was shut down at 2017-11-19 09:54:06 UTC
2017-11-19 09:54:06.645 UTC [1] LOG: database system is ready to accept connections
2017-11-19 09:54:40.735 UTC [356] LOG: logical decoding found consistent point at 0/163B848
2017-11-19 09:54:40.735 UTC [356] DETAIL: There are no running transactions.
2017-11-19 09:54:40.735 UTC [356] STATEMENT: SELECT 'created logical replication slot'
FROM pg_create_logical_replication_slot('jsoncdc', 'jsoncdc');
2017-11-19 09:54:41.060 UTC [356] LOG: starting logical decoding for slot "jsoncdc"
2017-11-19 09:54:41.060 UTC [356] DETAIL: streaming transactions committing after 0/163B880, reading WAL from 0/163B848
2017-11-19 09:54:41.060 UTC [356] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
2017-11-19 09:54:41.060 UTC [356] LOG: logical decoding found consistent point at 0/163B848
2017-11-19 09:54:41.060 UTC [356] DETAIL: There are no running transactions.
2017-11-19 09:54:41.060 UTC [356] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
2017-11-19 09:54:41.595 UTC [360] LOG: logical decoding found consistent point at 0/1EC69C0
2017-11-19 09:54:41.595 UTC [360] DETAIL: There are no running transactions.
2017-11-19 09:54:41.595 UTC [360] STATEMENT: SELECT 'created logical replication slot'
FROM pg_create_logical_replication_slot('jsoncdc', 'jsoncdc');
2017-11-19 09:54:41.617 UTC [360] LOG: starting logical decoding for slot "jsoncdc"
2017-11-19 09:54:41.617 UTC [360] DETAIL: streaming transactions committing after 0/1EC69F8, reading WAL from 0/1EC69C0
2017-11-19 09:54:41.617 UTC [360] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
2017-11-19 09:54:41.617 UTC [360] LOG: logical decoding found consistent point at 0/1EC69C0
2017-11-19 09:54:41.617 UTC [360] DETAIL: There are no running transactions.
2017-11-19 09:54:41.617 UTC [360] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
2017-11-19 09:54:41.663 UTC [364] LOG: logical decoding found consistent point at 0/1F1A3D8
2017-11-19 09:54:41.663 UTC [364] DETAIL: There are no running transactions.
2017-11-19 09:54:41.663 UTC [364] STATEMENT: SELECT 'created logical replication slot'
FROM pg_create_logical_replication_slot('jsoncdc', 'jsoncdc');
2017-11-19 09:54:41.679 UTC [364] LOG: starting logical decoding for slot "jsoncdc"
2017-11-19 09:54:41.679 UTC [364] DETAIL: streaming transactions committing after 0/1F1A410, reading WAL from 0/1F1A3D8
2017-11-19 09:54:41.679 UTC [364] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
2017-11-19 09:54:41.680 UTC [364] LOG: logical decoding found consistent point at 0/1F1A3D8
2017-11-19 09:54:41.680 UTC [364] DETAIL: There are no running transactions.
2017-11-19 09:54:41.680 UTC [364] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
2017-11-19 09:54:41.720 UTC [368] LOG: logical decoding found consistent point at 0/1F1D208
2017-11-19 09:54:41.720 UTC [368] DETAIL: There are no running transactions.
2017-11-19 09:54:41.720 UTC [368] STATEMENT: SELECT 'created logical replication slot'
FROM pg_create_logical_replication_slot('jsoncdc', 'jsoncdc');
2017-11-19 09:54:41.754 UTC [368] LOG: starting logical decoding for slot "jsoncdc"
2017-11-19 09:54:41.754 UTC [368] DETAIL: streaming transactions committing after 0/1F1D240, reading WAL from 0/1F1D208
2017-11-19 09:54:41.754 UTC [368] STATEMENT: SELECT * FROM jsoncdc.changedata;
2017-11-19 09:54:41.755 UTC [368] LOG: logical decoding found consistent point at 0/1F1D208
2017-11-19 09:54:41.755 UTC [368] DETAIL: There are no running transactions.
2017-11-19 09:54:41.755 UTC [368] STATEMENT: SELECT * FROM jsoncdc.changedata;
2017-11-19 09:54:41.807 UTC [372] LOG: logical decoding found consistent point at 0/1F71490
2017-11-19 09:54:41.807 UTC [372] DETAIL: There are no running transactions.
2017-11-19 09:54:41.807 UTC [372] STATEMENT: SELECT 'created logical replication slot'
FROM pg_create_logical_replication_slot('jsoncdc', 'jsoncdc');
2017-11-19 09:54:41.825 UTC [372] LOG: starting logical decoding for slot "jsoncdc"
2017-11-19 09:54:41.825 UTC [372] DETAIL: streaming transactions committing after 0/1F714C8, reading WAL from 0/1F71490
2017-11-19 09:54:41.825 UTC [372] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
2017-11-19 09:54:41.825 UTC [372] LOG: logical decoding found consistent point at 0/1F71490
2017-11-19 09:54:41.825 UTC [372] DETAIL: There are no running transactions.
2017-11-19 09:54:41.825 UTC [372] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
2017-11-19 09:54:41.834 UTC [372] LOG: starting logical decoding for slot "jsoncdc"
2017-11-19 09:54:41.834 UTC [372] DETAIL: streaming transactions committing after 0/1F8AF58, reading WAL from 0/1F71490
2017-11-19 09:54:41.834 UTC [372] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
2017-11-19 09:54:41.834 UTC [372] LOG: logical decoding found consistent point at 0/1F71490
2017-11-19 09:54:41.834 UTC [372] DETAIL: There are no running transactions.
2017-11-19 09:54:41.834 UTC [372] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
2017-11-19 09:54:41.889 UTC [376] LOG: logical decoding found consistent point at 0/1F91800
2017-11-19 09:54:41.889 UTC [376] DETAIL: There are no running transactions.
2017-11-19 09:54:41.889 UTC [376] STATEMENT: SELECT 'created logical replication slot'
FROM pg_create_logical_replication_slot('jsoncdc', 'jsoncdc');
2017-11-19 09:54:41.907 UTC [376] LOG: starting logical decoding for slot "jsoncdc"
2017-11-19 09:54:41.907 UTC [376] DETAIL: streaming transactions committing after 0/1F91838, reading WAL from 0/1F91800
2017-11-19 09:54:41.907 UTC [376] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
2017-11-19 09:54:41.908 UTC [376] LOG: logical decoding found consistent point at 0/1F91800
2017-11-19 09:54:41.908 UTC [376] DETAIL: There are no running transactions.
2017-11-19 09:54:41.908 UTC [376] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
2017-11-19 09:54:41.951 UTC [380] LOG: logical decoding found consistent point at 0/1FD97D0
2017-11-19 09:54:41.951 UTC [380] DETAIL: There are no running transactions.
2017-11-19 09:54:41.951 UTC [380] STATEMENT: SELECT 'created logical replication slot'
FROM pg_create_logical_replication_slot('jsoncdc', 'jsoncdc');
2017-11-19 09:54:42.047 UTC [380] LOG: starting logical decoding for slot "jsoncdc"
2017-11-19 09:54:42.047 UTC [380] DETAIL: streaming transactions committing after 0/1FD9808, reading WAL from 0/1FD97D0
2017-11-19 09:54:42.047 UTC [380] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
2017-11-19 09:54:42.048 UTC [380] LOG: logical decoding found consistent point at 0/1FD97D0
2017-11-19 09:54:42.048 UTC [380] DETAIL: There are no running transactions.
2017-11-19 09:54:42.048 UTC [380] STATEMENT: SELECT * FROM jsoncdc.changedata
WHERE NOT (data LIKE '{ "begin": %' OR data LIKE '{ "commit": %');
^C2017-11-19 09:55:01.638 UTC [1] LOG: received fast shutdown request
2017-11-19 09:55:01.645 UTC [1] LOG: aborting any active transactions
2017-11-19 09:55:01.647 UTC [1] LOG: worker process: logical replication launcher (PID 69) exited with exit code 1
2017-11-19 09:55:01.648 UTC [64] LOG: shutting down
2017-11-19 09:55:01.691 UTC [1] LOG: database system is shut down
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment