Differences

This shows you the differences between two versions of the page.

--- dba:postgresql:a_tale_of_postgresql_the_second [2023/10/24 09:21] – created dodger
+++ dba:postgresql:a_tale_of_postgresql_the_second [2023/10/24 09:23] – dodger
@@ Line 55: / Line 55: @@
 Add check to the monitorization tool to check:
-  * Connectivity from _primary_ to the shared Network drive
+  * Connectivity from _primary_ server to the shared Network drive
+  * Connectivity from _backup_ server to the shared Network drive
   * Disk space available on the _backup_ server in the underlying drive of the shared network drive
@@ Line 75: / Line 76: @@
 *Note*: This solution is not recommended because you won't have cross-repliaction. That is, in our initial recomendations we suggest that _primary_ server copies the WAL files to the _backup_ server to be able to execute a Point-in-time-recover (PITR), that is a *best-practice*.
+# Additional notes and recommendations
+## PostgreSQL version
+You're running version 12 which has EOL (end-of-life) support on [November 14, 2024](https://www.postgresql.org/support/versioning/).
+Our recommendation is to upgrade to v16.
+v16 will be on production state for many months when final upgrade happens, so we suggest to plan the version upgrade as soon as possible.
+## Archivelog location
+Consider having a external shared storage shared with both _primary_ and _backup_ for archivelog storage.
 # Thales Hyderabad info
+You can safely ignore this.
 ```