Created
November 19, 2017 10:05
-
-
Save allenap/0819243b57ecbae21be0a85a71becbd5 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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