I'm very new in postgresql. I want to ask about log shipping replication process. I know that the timeout parameter is optional in log shipping process. It specifies that we don't want that postgreSQL to wait until the WAL files contain 16 MB to be sent as it does by default. My question is, it is better has timeout parameter(eg : archive_timeout = 60) or not? is it when we do timeout parameter the process of WAL file in log shipping is faster than default (the 0 default value indicates that it will until the WAL filled)? why?
I'm sorry i'm still confused in this situation.
If you want timely replication, I suggest enabling streaming replication as well as log shipping.
The main purpose of
archive_timeoutis to ensure that, when you're using log shipping for PITR backups, there's a maximum time window of data loss in situations where the server isn't generating lots of WAL so segment rotation would otherwise be infrequent.