Re: FW: Setting up streaming replication problems - Mailing list pgsql-general

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]@[unknown] LOG:  connection 
received: host=[local]
2018-01-29 05:55:40.822 CET [1315] [unknown]@[unknown] LOG:  incomplete 
startup packet
2018-01-29 05:55:41.344 CET [1318] [unknown]@[unknown] LOG:  connection 
received: host=[local]
2018-01-29 05:55:41.349 CET [1318] postgres@postgres LOG:  connection 
authorized: user=postgres database=postgres
2018-01-29 05:55:41.900 CET [1321] [unknown]@[unknown] LOG:  connection 
received: host=[local]
2018-01-29 05:55:41.905 CET [1321] postgres@postgres LOG:  connection 
authorized: user=postgres database=postgres
2018-01-29 05:55:42.440 CET [1324] [unknown]@[unknown] LOG:  connection 
received: host=[local]
2018-01-29 05:55:42.447 CET [1324] postgres@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]@[unknown] LOG:  connection 
received: host=[local]
2018-01-29 05:55:48.471 CET [1341] [unknown]@[unknown] LOG:  incomplete 
startup packet
2018-01-29 05:55:48.994 CET [1344] [unknown]@[unknown] LOG:  connection 
received: host=[local]
2018-01-29 05:55:48.999 CET [1344] postgres@postgres LOG:  connection 
authorized: user=postgres database=postgres
2018-01-29 05:55:49.545 CET [1347] [unknown]@[unknown] LOG:  connection 
received: host=[local]
2018-01-29 05:55:49.551 CET [1347] postgres@postgres LOG:  connection 
authorized: user=postgres database=postgres
2018-01-29 05:55:50.088 CET [1350] [unknown]@[unknown] LOG:  connection 
received: host=[local]
2018-01-29 05:55:50.093 CET [1350] postgres@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