Re: Probleme Replikation aufzusetzen
"Thiemo Kellner, NHC Barhufpflege" <[email protected]> Mon, 29 Jan 2018 10:25:49 +0100
| Newsgroups | gmane.comp.db.postgresql.german |
|---|---|
| Message-ID | <[email protected]> |
Zitat von Laurenz Albe <[email protected]>: > Die Interessante Information fehlt, n=C3=A4mlich das Log-File. > Verzeihung und danke f=C3=BCr den Hinweis. =3D=3D Master log of start gives me =3D=3D 2018-01-29 05:55:39.996 CET [1307] DEBUG: registering background =20 worker "logical replication launcher" 2018-01-29 05:55:39.996 CET [1307] LOG: listening on IPv6 address =20 "::1", port 5432 2018-01-29 05:55:39.996 CET [1307] LOG: listening on IPv4 address =20 "127.0.0.1", port 5432 2018-01-29 05:55:40.027 CET [1307] LOG: listening on Unix socket =20 "/var/run/postgresql/.s.PGSQL.5432" 2018-01-29 05:55:40.061 CET [1307] DEBUG: mmap(148897792) with =20 MAP_HUGETLB failed, huge pages disabled: Cannot allocate memory 2018-01-29 05:55:40.153 CET [1308] LOG: database system was shut down =20 at 2018-01-29 05:50:37 CET 2018-01-29 05:55:40.154 CET [1308] DEBUG: checkpoint record is at 0/164975= 8 2018-01-29 05:55:40.155 CET [1308] DEBUG: redo record is at =20 0/1649758; shutdown TRUE 2018-01-29 05:55:40.155 CET [1308] DEBUG: next transaction ID: 0:583; =20 next OID: 16398 2018-01-29 05:55:40.156 CET [1308] DEBUG: next MultiXactId: 1; next =20 MultiXactOffset: 0 2018-01-29 05:55:40.156 CET [1308] DEBUG: oldest unfrozen transaction =20 ID: 548, in database 1 2018-01-29 05:55:40.156 CET [1308] DEBUG: oldest MultiXactId: 1, in =20 database 1 2018-01-29 05:55:40.156 CET [1308] DEBUG: commit timestamp Xid =20 oldest/newest: 0/0 2018-01-29 05:55:40.156 CET [1308] DEBUG: transaction ID wrap limit =20 is 2147484195, limited by database with OID 1 2018-01-29 05:55:40.156 CET [1308] DEBUG: MultiXactId wrap limit is =20 2147483648, limited by database with OID 1 2018-01-29 05:55:40.156 CET [1308] DEBUG: starting up replication slots 2018-01-29 05:55:40.158 CET [1308] DEBUG: MultiXactId wrap limit is =20 2147483648, limited by database with OID 1 2018-01-29 05:55:40.158 CET [1308] DEBUG: MultiXact member stop limit =20 is now 4294914944 based on MultiXact 1 2018-01-29 05:55:40.212 CET [1312] DEBUG: autovacuum launcher started 2018-01-29 05:55:40.213 CET [1307] DEBUG: starting background worker =20 process "logical replication launcher" 2018-01-29 05:55:40.216 CET [1307] LOG: database system is ready to =20 accept connections 2018-01-29 05:55:40.217 CET [1314] DEBUG: logical replication =20 launcher started 2018-01-29 05:55:40.822 CET [1315] [unknown]@[unknown] LOG: =20 connection received: host=3D[local] 2018-01-29 05:55:40.822 CET [1315] [unknown]@[unknown] LOG: =20 incomplete startup packet 2018-01-29 05:55:41.344 CET [1318] [unknown]@[unknown] LOG: =20 connection received: host=3D[local] 2018-01-29 05:55:41.349 CET [1318] postgres@postgres LOG: connection =20 authorized: user=3Dpostgres database=3Dpostgres 2018-01-29 05:55:41.900 CET [1321] [unknown]@[unknown] LOG: =20 connection received: host=3D[local] 2018-01-29 05:55:41.905 CET [1321] postgres@postgres LOG: connection =20 authorized: user=3Dpostgres database=3Dpostgres 2018-01-29 05:55:42.440 CET [1324] [unknown]@[unknown] LOG: =20 connection received: host=3D[local] 2018-01-29 05:55:42.447 CET [1324] postgres@postgres LOG: connection =20 authorized: user=3Dpostgres database=3Dpostgres =3D=3D Standby log gives me =3D=3D 2018-01-29 05:55:47.724 CET [1333] DEBUG: registering background =20 worker "logical replication launcher" 2018-01-29 05:55:47.724 CET [1333] LOG: listening on IPv6 address =20 "::1", port 5433 2018-01-29 05:55:47.725 CET [1333] LOG: listening on IPv4 address =20 "127.0.0.1", port 5433 2018-01-29 05:55:47.759 CET [1333] LOG: listening on Unix socket =20 "/var/run/postgresql/.s.PGSQL.5433" 2018-01-29 05:55:47.793 CET [1333] DEBUG: mmap(148897792) with =20 MAP_HUGETLB failed, huge pages disabled: Cannot allocate memory 2018-01-29 05:55:47.887 CET [1334] LOG: database system was shut down =20 at 2018-01-29 05:50:37 CET 2018-01-29 05:55:47.887 CET [1334] DEBUG: checkpoint record is at 0/163640= 8 2018-01-29 05:55:47.889 CET [1334] DEBUG: redo record is at =20 0/1636408; shutdown TRUE 2018-01-29 05:55:47.889 CET [1334] DEBUG: next transaction ID: 0:556; =20 next OID: 16385 2018-01-29 05:55:47.889 CET [1334] DEBUG: next MultiXactId: 1; next =20 MultiXactOffset: 0 2018-01-29 05:55:47.889 CET [1334] DEBUG: oldest unfrozen transaction =20 ID: 548, in database 1 2018-01-29 05:55:47.889 CET [1334] DEBUG: oldest MultiXactId: 1, in =20 database 1 2018-01-29 05:55:47.889 CET [1334] DEBUG: commit timestamp Xid =20 oldest/newest: 0/0 2018-01-29 05:55:47.889 CET [1334] DEBUG: transaction ID wrap limit =20 is 2147484195, limited by database with OID 1 2018-01-29 05:55:47.889 CET [1334] DEBUG: MultiXactId wrap limit is =20 2147483648, limited by database with OID 1 2018-01-29 05:55:47.889 CET [1334] DEBUG: starting up replication slots 2018-01-29 05:55:47.890 CET [1334] DEBUG: MultiXactId wrap limit is =20 2147483648, limited by database with OID 1 2018-01-29 05:55:47.890 CET [1334] DEBUG: MultiXact member stop limit =20 is now 4294914944 based on MultiXact 1 2018-01-29 05:55:47.943 CET [1338] DEBUG: autovacuum launcher started 2018-01-29 05:55:47.944 CET [1333] DEBUG: starting background worker =20 process "logical replication launcher" 2018-01-29 05:55:47.945 CET [1333] LOG: database system is ready to =20 accept connections 2018-01-29 05:55:47.945 CET [1340] DEBUG: logical replication =20 launcher started 2018-01-29 05:55:48.470 CET [1341] [unknown]@[unknown] LOG: =20 connection received: host=3D[local] 2018-01-29 05:55:48.471 CET [1341] [unknown]@[unknown] LOG: =20 incomplete startup packet 2018-01-29 05:55:48.994 CET [1344] [unknown]@[unknown] LOG: =20 connection received: host=3D[local] 2018-01-29 05:55:48.999 CET [1344] postgres@postgres LOG: connection =20 authorized: user=3Dpostgres database=3Dpostgres 2018-01-29 05:55:49.545 CET [1347] [unknown]@[unknown] LOG: =20 connection received: host=3D[local] 2018-01-29 05:55:49.551 CET [1347] postgres@postgres LOG: connection =20 authorized: user=3Dpostgres database=3Dpostgres 2018-01-29 05:55:50.088 CET [1350] [unknown]@[unknown] LOG: =20 connection received: host=3D[local] 2018-01-29 05:55:50.093 CET [1350] postgres@postgres LOG: connection =20 authorized: user=3Dpostgres database=3Dpostgres --=20 +49 (0)1578-772 37 37 +41 (0)78 947 36 21 =C3=96ffentlicher PGP-Schl=C3=BCssel: =20 http://pgp.mit.edu/pks/lookup?op=3Dget&search=3D0x8F70EFD2D972CBEF ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.