Re: Creating a new database on a different file system

2025-03-17 Thread Tim Gerber
Hi Ian, Tablespaces would work... take a look: https://www.postgresql.org/docs/current/manage-ag-tablespaces.html Best, Tim On Mon, Mar 17, 2025 at 9:49 AM Ian Dauncey wrote: > Hi All > > > > We are running an old version of PostgreSQL on a Linux Server. > > We have created a few databases on

Re: old OS

2025-02-04 Thread Tim Gerber
Appears PG 12 is available for RHEL 6 via the following repository: https://download.postgresql.org/pub/repos/yum/12/redhat/ If you need more reference, take a look at: https://www.postgresql.org/download/linux/redhat/

Re: Data Out of Sync with Physical Streaming Replication

2025-01-15 Thread Tim Gerber
e784e70250","\\x019344723f7778b6b34305157fb9a339","\\x01934472b0527ce29c7d35a809bcb3f6"} (5 rows) STANDBY: issuedb=# SELECT ctid, xmin, xmax, troubleshoot_issue_id as issue_id from troubleshoot_issue; ctid | xmin | xmax | troubleshoot_issue_id ---+-

Data Out of Sync with Physical Streaming Replication

2025-01-15 Thread Tim Gerber
Hi All, We have run into an issue where the data for a primary and standby Postgres instances are out of sync. We are using streaming physical replication. We have encountered this issue several times over the last year on different Postgres Clusters. Postgres indicates everything is in sync but