DeltaMaster

Log Docker

Jan 2nd, 2019
261
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.68 KB | None | 0 0
  1. Add rule to pg_hba: replication user
  2. Setup master database
  3. Use modified postgresql.conf for greater speed (spatial and replication)
  4. psql: could not connect to server: No such file or directory
  5. Is the server running locally and accepting
  6. connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
  7. 2019-01-01 20:02:22.713 UTC [25] LOG: listening on IPv4 address "127.0.0.1", port 5432
  8. 2019-01-01 20:02:22.947 UTC [25] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
  9. 2019-01-01 20:02:23.389 UTC [38] LOG: database system was shut down at 2018-04-25 10:44:17 UTC
  10. 2019-01-01 20:02:23.556 UTC [25] LOG: database system is ready to accept connections
  11. List of databases
  12. Name | Owner | Encoding | Collate | Ctype | Access privileges
  13. -----------+----------+----------+---------+---------+-----------------------
  14. postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
  15. template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +
  16. | | | | | postgres=CTc/postgres
  17. template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +
  18. | | | | | postgres=CTc/postgres
  19. (3 rows)
  20.  
  21. postgres ready
  22. Postgis is missing, installing now
  23. Creating template postgis
  24. Enabling template_postgis as a template
  25. UPDATE 1
  26. Loading postgis extension
  27. CREATE EXTENSION
  28. Enabling hstore in the template
  29. CREATE EXTENSION
  30. Enabling topology in the template
  31. CREATE EXTENSION
  32. Loading legacy sql
  33. CREATE FUNCTION
  34. CREATE FUNCTION
  35. CREATE FUNCTION
  36. CREATE FUNCTION
  37. CREATE FUNCTION
  38. CREATE FUNCTION
  39. CREATE FUNCTION
  40. CREATE FUNCTION
  41. CREATE FUNCTION
  42. CREATE FUNCTION
  43. CREATE FUNCTION
  44. CREATE FUNCTION
  45. CREATE OPERATOR CLASS
  46. Setup postgres User:Password
  47. CREATE ROLE
  48. Check default db exists
  49. Create default db gis
  50. List of databases
  51. Name | Owner | Encoding | Collate | Ctype | Access privilege
  52. s
  53. ------------------+----------+----------+---------+---------+-------------------
  54. ----
  55. gis | docker | UTF8 | C.UTF-8 | C.UTF-8 |
  56. postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
  57. template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres
  58. +
  59. | | | | | postgres=CTc/postg
  60. res
  61. template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres
  62. +
  63. | | | | | postgres=CTc/postg
  64. res
  65. template_postgis | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
  66. (5 rows)
  67.  
  68. 2019-01-01 20:02:38.580 UTC [25] LOG: received smart shutdown request
  69. 2019-01-01 20:02:38.677 UTC [25] LOG: worker process: logical replication launcher (PID 46) exited with exit code 1
  70. 2019-01-01 20:02:38.678 UTC [41] LOG: shutting down
  71. 2019-01-01 20:02:39.141 UTC [25] LOG: database system is shut down
  72.  
  73. /docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
  74.  
  75. Postgres initialisation process completed .... restarting in foreground
  76. 2019-01-01 20:02:39.788 UTC [222] LOG: listening on IPv4 address "0.0.0.0", port 5432
  77. 2019-01-01 20:02:39.788 UTC [222] LOG: listening on IPv6 address "::", port 5432
  78. 2019-01-01 20:02:39.975 UTC [222] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
  79. 2019-01-01 20:02:40.397 UTC [225] LOG: database system was shut down at 2019-01-01 20:02:39 UTC
  80. 2019-01-01 20:02:40.507 UTC [222] LOG: database system is ready to accept connections
  81.  
  82. 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
  83. 2019-01-01 20:06:31.524 UTC [222] LOG: received smart shutdown request
  84. Add rule to pg_hba: replication user
  85. Setup master database
  86. Use modified postgresql.conf for greater speed (spatial and replication)
  87. psql: could not connect to server: Connection refused
  88. Is the server running locally and accepting
  89. connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
  90. 2019-01-01 20:18:30.074 UTC [25] LOG: listening on IPv4 address "127.0.0.1", port 5432
  91. 2019-01-01 20:18:30.243 UTC [25] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
  92. 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
  93. 2019-01-01 20:18:30.697 UTC [50] postgres@postgres FATAL: the database system is starting up
  94. psql: FATAL: the database system is starting up
  95. 2019-01-01 20:18:31.512 UTC [42] LOG: database system was not properly shut down; automatic recovery in progress
  96. 2019-01-01 20:18:31.594 UTC [42] LOG: redo starts at 0/1ED67D8
  97. 2019-01-01 20:18:31.747 UTC [42] LOG: invalid record length at 0/1F0D290: wanted 24, got 0
  98. 2019-01-01 20:18:31.748 UTC [42] LOG: redo done at 0/1F0D258
  99. 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
  100. 2019-01-01 20:18:31.814 UTC [63] postgres@postgres FATAL: the database system is starting up
  101. psql: FATAL: the database system is starting up
  102. 2019-01-01 20:18:33.013 UTC [76] postgres@postgres FATAL: the database system is starting up
  103. psql: FATAL: the database system is starting up
  104. 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