How to get previous log file

Hi! select pg_read_file(pg_current_logfile()) retrieves today log file. Log files are in log directory: /var/lib/postgresql/12/main/log# ls ... postgresql-2020-06-08_00.log postgresql-2020-06-18_00.log postgresql-2020-06-28_00.log postgresql-2020-06-09_00.log postgresql-20

Re: How to get previous log file

On 6/28/20 2:42 AM, Andrus wrote: Hi! select pg_read_file(pg_current_logfile()) retrieves today log file. Log files are in log directory: /var/lib/postgresql/12/main/log# ls ... postgresql-2020-06-08_00.log  postgresql-2020-06-18_00.log postgresql-2020-06-28_00.log postgresql-202

Re: n_distinct off by a factor of 1000

On 2020-06-24 16:27:35 -0600, Michael Lewis wrote: > On Wed, Jun 24, 2020, 2:35 PM Peter J. Holzer wrote: > > Yes, estimating the number of distinct values from a relatively small > sample is hard when you don't know the underlying distribution. It might > be possible to analyze the s

Fwd: BUG #16513: Postgresql HA Cluster

Hi Team, Please help us on the below query . Thanks -- Forwarded message - From: Daniel Gustafsson Date: Sat, 27 Jun, 2020, 3:16 AM Subject: Re: BUG #16513: Postgresql HA Cluster To: , PostgreSQL mailing lists < pgsql-b...@lists.postgresql.org> > On 26 Jun 2020, at 16:10, PG B

Postgresql HA Cluster

Hi All, Is there any functionality present in postgresql for High Availability Cluster where we can setup multiple nodes/instances in READ-WRITE mode for single database so that incase of one node/instance failure it will automatically failover the traffic to 2nd node/instance (without failure or

bdr_init_copy ends fine but doesn't copy the remote db

I am trying to make a multi-master replication using BDR and because of the DDL issues-errors, I decided to use bdr_init_copy command instead of using bdr.bdr_group_join(). I have two servers with PostgreSQL services and one of them(Master2) has an empty DB, the other(Master1) has one schema and on