Re: FW: Setting up streaming replication problems

Thanks for your patience.

On 01/29/18 00:11, Martin Goodson wrote:
> "A password needs to be provided too, if the primary demands password
> authentication. It can be provided in the primary_conninfo string, or in
> a separate ~/.pgpass file on the standby server (use replication as the
> database name)"

I tried plain text.

> But are you sure the password is the issue? What messages are you seeing
> in your logs on both the master and the standby? Could you post the logs
> here, or at least a representative sample? What are you seeing in the
> standby logs when you start it? What are you seeing in the master's logs
> at the same time?

No, I am not.

== Master log of start gives me ==

2018-01-29 05:55:39.996 CET [1307] DEBUG: registering background worker
"logical replication launcher"
2018-01-29 05:55:39.996 CET [1307] LOG: listening on IPv6 address
"::1", port 5432
2018-01-29 05:55:39.996 CET [1307] LOG: listening on IPv4 address
"127.0.0.1", port 5432
2018-01-29 05:55:40.027 CET [1307] LOG: listening on Unix socket
"/var/run/postgresql/.s.PGSQL.5432"
2018-01-29 05:55:40.061 CET [1307] DEBUG: mmap(148897792) with
MAP_HUGETLB failed, huge pages disabled: Cannot allocate memory
2018-01-29 05:55:40.153 CET [1308] LOG: database system was shut down
at 2018-01-29 05:50:37 CET
2018-01-29 05:55:40.154 CET [1308] DEBUG: checkpoint record is at 0/1649758
2018-01-29 05:55:40.155 CET [1308] DEBUG: redo record is at 0/1649758;
shutdown TRUE
2018-01-29 05:55:40.155 CET [1308] DEBUG: next transaction ID: 0:583;
next OID: 16398
2018-01-29 05:55:40.156 CET [1308] DEBUG: next MultiXactId: 1; next
MultiXactOffset: 0
2018-01-29 05:55:40.156 CET [1308] DEBUG: oldest unfrozen transaction
ID: 548, in database 1
2018-01-29 05:55:40.156 CET [1308] DEBUG: oldest MultiXactId: 1, in
database 1
2018-01-29 05:55:40.156 CET [1308] DEBUG: commit timestamp Xid
oldest/newest: 0/0
2018-01-29 05:55:40.156 CET [1308] DEBUG: transaction ID wrap limit is
2147484195, limited by database with OID 1
2018-01-29 05:55:40.156 CET [1308] DEBUG: MultiXactId wrap limit is
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
2147483648, limited by database with OID 1
2018-01-29 05:55:40.158 CET [1308] DEBUG: MultiXact member stop limit
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
process "logical replication
launcher"
2018-01-29 05:55:40.216 CET [1307] LOG: database system is ready to
accept connections
2018-01-29 05:55:40.217 CET [1314] DEBUG: logical replication launcher
started
2018-01-29 05:55:40.822 CET [1315] [unknown](at)[unknown] LOG: connection
received: host=[local]
2018-01-29 05:55:40.822 CET [1315] [unknown](at)[unknown] LOG: incomplete
startup packet
2018-01-29 05:55:41.344 CET [1318] [unknown](at)[unknown] LOG: connection
received: host=[local]
2018-01-29 05:55:41.349 CET [1318] postgres(at)postgres LOG: connection
authorized: user=postgres database=postgres
2018-01-29 05:55:41.900 CET [1321] [unknown](at)[unknown] LOG: connection
received: host=[local]
2018-01-29 05:55:41.905 CET [1321] postgres(at)postgres LOG: connection
authorized: user=postgres database=postgres
2018-01-29 05:55:42.440 CET [1324] [unknown](at)[unknown] LOG: connection
received: host=[local]
2018-01-29 05:55:42.447 CET [1324] postgres(at)postgres LOG: connection
authorized: user=postgres database=postgres

== Standby log gives me ==

2018-01-28 05:55:32.703 CET [5214] DEBUG: autovacuum: processing
database "postgres"
2018-01-29 05:55:47.724 CET [1333] DEBUG: registering background worker
"logical replication launcher"
2018-01-29 05:55:47.724 CET [1333] LOG: listening on IPv6 address
"::1", port 5433
2018-01-29 05:55:47.725 CET [1333] LOG: listening on IPv4 address
"127.0.0.1", port 5433
2018-01-29 05:55:47.759 CET [1333] LOG: listening on Unix socket
"/var/run/postgresql/.s.PGSQL.5433"
2018-01-29 05:55:47.793 CET [1333] DEBUG: mmap(148897792) with
MAP_HUGETLB failed, huge pages disabled: Cannot allocate memory
2018-01-29 05:55:47.887 CET [1334] LOG: database system was shut down
at 2018-01-29 05:50:37 CET
2018-01-29 05:55:47.887 CET [1334] DEBUG: checkpoint record is at 0/1636408
2018-01-29 05:55:47.889 CET [1334] DEBUG: redo record is at 0/1636408;
shutdown TRUE
2018-01-29 05:55:47.889 CET [1334] DEBUG: next transaction ID: 0:556;
next OID: 16385
2018-01-29 05:55:47.889 CET [1334] DEBUG: next MultiXactId: 1; next
MultiXactOffset: 0
2018-01-29 05:55:47.889 CET [1334] DEBUG: oldest unfrozen transaction
ID: 548, in database 1
2018-01-29 05:55:47.889 CET [1334] DEBUG: oldest MultiXactId: 1, in
database 1
2018-01-29 05:55:47.889 CET [1334] DEBUG: commit timestamp Xid
oldest/newest: 0/0
2018-01-29 05:55:47.889 CET [1334] DEBUG: transaction ID wrap limit is
2147484195, limited by database with OID 1
2018-01-29 05:55:47.889 CET [1334] DEBUG: MultiXactId wrap limit is
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
2147483648, limited by database with OID 1
2018-01-29 05:55:47.890 CET [1334] DEBUG: MultiXact member stop limit
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
process "logical replication launcher"
2018-01-29 05:55:47.945 CET [1333] LOG: database system is ready to
accept connections
2018-01-29 05:55:47.945 CET [1340] DEBUG: logical replication launcher
started
2018-01-29 05:55:48.470 CET [1341] [unknown](at)[unknown] LOG: connection
received: host=[local]
2018-01-29 05:55:48.471 CET [1341] [unknown](at)[unknown] LOG: incomplete
startup packet
2018-01-29 05:55:48.994 CET [1344] [unknown](at)[unknown] LOG: connection
received: host=[local]
2018-01-29 05:55:48.999 CET [1344] postgres(at)postgres LOG: connection
authorized: user=postgres database=postgres
2018-01-29 05:55:49.545 CET [1347] [unknown](at)[unknown] LOG: connection
received: host=[local]
2018-01-29 05:55:49.551 CET [1347] postgres(at)postgres LOG: connection
authorized: user=postgres database=postgres
2018-01-29 05:55:50.088 CET [1350] [unknown](at)[unknown] LOG: connection
received: host=[local]
2018-01-29 05:55:50.093 CET [1350] postgres(at)postgres LOG: connection
authorized: user=postgres database=postgres

Chhers Thiemo

--
+49 (0)1578-772 37 37
+41 (0)78 947 36 21
SIP/iptel.org: thiemo.kellner
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0xCA167FB0E717AFFC