How to Implement DR for a Production PostgreSQL v12.8 database cluster with repmgr & PgBouncer?

I manage PostgreSQL v12.8 database clusters. Our database clusters are on Linux VMs, with OS: Flavor: redhat_7 Release: 3.10.0-1160.45.1.el7.x86_64 We have repmgr clusters of 1 Primary & 2 Standby servers & use another server with PgBouncer to direct the connections to the current Primary. T

Re: Pg_hba.conf problem after unexpected IP change

On 11/12/21 10:34 AM, Yessica Brinkmann wrote: Thank you very much for your answer. Did you find the problem? If not have you investigated whether whatever changed the IP also enabled a firewall rule that blocks port(5432 I'm assuming)? Regards, Yessica Brinkmann El vie, 12 nov 2021 a la

Re: Pg_hba.conf problem after unexpected IP change

Thank you very much for your answer. Regards, Yessica Brinkmann El vie, 12 nov 2021 a las 9:22, Dave Cramer () escribió: > > > > On Fri, 12 Nov 2021 at 06:12, Yessica Brinkmann < > brinkmann.yess...@gmail.com> wrote: > >> Hello. >> Thank you very much for your answer. >> Yes, I restart the serv

Re: Are all unlogged tables in any case truncated after a server-crash?

Curious... why keep the table as unlogged if it is static? If you can spare the disk space, perhaps just create a regular table with same definition, gradually copy the data to spread the impact on WAL, and when complete, just drop the old table and rename the new one.

RE: Replace anonymized data in string

> On 12 Nov 2021, at 15:12, Patrick FICHE wrote: > Is there any way to do this ? There was a presentation on the subject of anonymization and data masking at Fosdem PGDay 2019, maybe the slides from there can give any insights? https://www.postgresql.eu/events/fosdem2019/schedule/session/2287-

Re: Replace anonymized data in string

On 11/12/21 7:12 AM, Patrick FICHE wrote: Hi Team, I have some data that has been anonymized and I would like to generate some test data from this. In some way, I would like to deanonymize this data with random data. For example, phone numbers have been anonymized with changing the 5 right

Re: Replace anonymized data in string

> On 12 Nov 2021, at 15:12, Patrick FICHE wrote: > Is there any way to do this ? There was a presentation on the subject of anonymization and data masking at Fosdem PGDay 2019, maybe the slides from there can give any insights? https://www.postgresql.eu/events/fosdem2019/schedule/session/2287-a

Replace anonymized data in string

Hi Team, I have some data that has been anonymized and I would like to generate some test data from this. In some way, I would like to deanonymize this data with random data. For example, phone numbers have been anonymized with changing the 5 right digits with the 8 digit (preserving length).

Re: Are all unlogged tables in any case truncated after a server-using

Why keep them as unlogged tables? If data is static, can you spare the disk space to gradually copy data from existing unlogged table to new copy that is logged, and then have brief exclusive lock to drop unlogged and rename new one?

Re: Pg_hba.conf problem after unexpected IP change

On Fri, 12 Nov 2021 at 06:12, Yessica Brinkmann wrote: > Hello. > Thank you very much for your answer. > Yes, I restart the server after making the changes. > Regards, > Yessica Brinkmann > Check the logs for postgres to make sure there were no errors in your new configuration. Dave Cramer www.

Re: Are all unlogged tables in any case truncated after a server-crash?

Am 12.11.2021 um 08:41 schrieb Laurenz Albe: On Thu, 2021-11-11 at 18:39 +, sch...@posteo.de wrote: every few weeks I use Postgres ability, to import huge data sets very fast by means of "unlogged tables". The bulk load (consisting of plenty "copy"- & DML-Stmts) and the spatial index crea

Re: Pg_hba.conf problem after unexpected IP change

Hello. Thank you very much for your answer. Yes, I restart the server after making the changes. Regards, Yessica Brinkmann Libre de virus. www.avg.com

Re: Are all unlogged tables in any case truncated after a server-crash?

Hi David, thx for your comments and your advice on reading docs on "checkpoint". Of course consistency is most important to any DBMS, and if in doubt about that, truncate data rows and restore from WAL. But in this case, where data is never modified after bulk load, I thought there might be an