Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Add rule to pg_hba: replication user
- Setup master database
- Use modified postgresql.conf for greater speed (spatial and replication)
- psql: could not connect to server: No such file or directory
- Is the server running locally and accepting
- connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
- 2019-01-01 20:02:22.713 UTC [25] LOG: listening on IPv4 address "127.0.0.1", port 5432
- 2019-01-01 20:02:22.947 UTC [25] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
- 2019-01-01 20:02:23.389 UTC [38] LOG: database system was shut down at 2018-04-25 10:44:17 UTC
- 2019-01-01 20:02:23.556 UTC [25] LOG: database system is ready to accept connections
- List of databases
- Name | Owner | Encoding | Collate | Ctype | Access privileges
- -----------+----------+----------+---------+---------+-----------------------
- postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
- template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +
- | | | | | postgres=CTc/postgres
- template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +
- | | | | | postgres=CTc/postgres
- (3 rows)
- postgres ready
- Postgis is missing, installing now
- Creating template postgis
- Enabling template_postgis as a template
- UPDATE 1
- Loading postgis extension
- CREATE EXTENSION
- Enabling hstore in the template
- CREATE EXTENSION
- Enabling topology in the template
- CREATE EXTENSION
- Loading legacy sql
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- Setup postgres User:Password
- CREATE ROLE
- Check default db exists
- Create default db gis
- List of databases
- Name | Owner | Encoding | Collate | Ctype | Access privilege
- s
- ------------------+----------+----------+---------+---------+-------------------
- ----
- gis | docker | UTF8 | C.UTF-8 | C.UTF-8 |
- postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
- template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres
- +
- | | | | | postgres=CTc/postg
- res
- template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres
- +
- | | | | | postgres=CTc/postg
- res
- template_postgis | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
- (5 rows)
- 2019-01-01 20:02:38.580 UTC [25] LOG: received smart shutdown request
- 2019-01-01 20:02:38.677 UTC [25] LOG: worker process: logical replication launcher (PID 46) exited with exit code 1
- 2019-01-01 20:02:38.678 UTC [41] LOG: shutting down
- 2019-01-01 20:02:39.141 UTC [25] LOG: database system is shut down
- /docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
- Postgres initialisation process completed .... restarting in foreground
- 2019-01-01 20:02:39.788 UTC [222] LOG: listening on IPv4 address "0.0.0.0", port 5432
- 2019-01-01 20:02:39.788 UTC [222] LOG: listening on IPv6 address "::", port 5432
- 2019-01-01 20:02:39.975 UTC [222] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
- 2019-01-01 20:02:40.397 UTC [225] LOG: database system was shut down at 2019-01-01 20:02:39 UTC
- 2019-01-01 20:02:40.507 UTC [222] LOG: database system is ready to accept connections
- Session terminated, terminating shell...2019-01-01 20:06:31.524 UTC [222] LOG: worker process: logical replication launcher (PID 231) exited with exit code 1
- 2019-01-01 20:06:31.524 UTC [222] LOG: received smart shutdown request
- Add rule to pg_hba: replication user
- Setup master database
- Use modified postgresql.conf for greater speed (spatial and replication)
- psql: could not connect to server: Connection refused
- Is the server running locally and accepting
- connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
- 2019-01-01 20:18:30.074 UTC [25] LOG: listening on IPv4 address "127.0.0.1", port 5432
- 2019-01-01 20:18:30.243 UTC [25] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
- 2019-01-01 20:18:30.628 UTC [42] LOG: database system was interrupted; last known up at 2019-01-01 20:02:40 UTC
- 2019-01-01 20:18:30.697 UTC [50] postgres@postgres FATAL: the database system is starting up
- psql: FATAL: the database system is starting up
- 2019-01-01 20:18:31.512 UTC [42] LOG: database system was not properly shut down; automatic recovery in progress
- 2019-01-01 20:18:31.594 UTC [42] LOG: redo starts at 0/1ED67D8
- 2019-01-01 20:18:31.747 UTC [42] LOG: invalid record length at 0/1F0D290: wanted 24, got 0
- 2019-01-01 20:18:31.748 UTC [42] LOG: redo done at 0/1F0D258
- 2019-01-01 20:18:31.749 UTC [42] LOG: last completed transaction was at log time 2019-01-01 20:03:13.699387+00
- 2019-01-01 20:18:31.814 UTC [63] postgres@postgres FATAL: the database system is starting up
- psql: FATAL: the database system is starting up
- 2019-01-01 20:18:33.013 UTC [76] postgres@postgres FATAL: the database system is starting up
- psql: FATAL: the database system is starting up
- 2019-01-01 20:18:33.381 UTC [25] LOG: database system is ready to accept connections
Advertisement
Add Comment
Please, Sign In to add comment