10/10/2023 0 Comments Centos install postgresql 12Reload is adequate to apply changes for archive_cleanup_command, promote_trigger_file, recovery_end_command, recovery_min_apply_delay parameters. standby.signal file will use to determine standby database.Īlso, you can change parameters with ALTER SYSTEM command. standby_mode parameter is no longer used. trigger_file parameter has been changed to promote_trigger_file. Parameters will write in nf file and file. If you set up a WAL archive that’s accessible from the standby, these solutions are not required, since the standby can always use the archive to catch up provided it retains enough segments. You can avoid this by setting wal_keep_segments to a value large enough to ensure that WAL segments are not recycled too early, or by configuring a replication slot for the standby. If this occurs, the standby will need to be reinitialized from a new base backup. If you use streaming replication without file-based continuous archiving, the server might recycle old WAL segments before the standby has received them. Streaming replication is asynchronous by default, in which case there is a small delay between committing a transaction in the primary and the changes becoming visible in the standby.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |