Dilip Kumar wrote on 2020/11/15 04:47:12 AM:
> I am not sure how Patroni does it internally, can you explain the
> scenario in more detail? Suppose you are executing the promote on m-1
> and if the promotion is successful it will switch the timeline and it
> will create the timeline history file
Dhinakaran R wrote on 2020/11/07 02:03:22
PM:
> > I had installed PostgreSQL 11.9 and pgaudit 1.3.2. updated
> > shared_preload_libraries, restarted PostgreSQL, created an extension
for
> > pgaudit and set parameters for pgaudit in postgresql.conf. But
> > surprisingly pgaudit.log is not gett
Hi,
I've recently been seeing a race condition with the restore_command on
replicas using streaming replication.
On the primary, we are archiving wal files to s3 compatible storage via
pgBackRest. In the recovery.conf section of the postgresql.conf file on the
replicas, we define the restore co
Tom Lane wrote on 2020/06/26 02:47:25 PM:
> From: Tom Lane
> To: "Brad Nicholson"
> Cc: pgsql-general@lists.postgresql.org
> Date: 2020/06/26 02:51 PM
> Subject: [EXTERNAL] Re: PG13 Trusted Extension usability issue
>
> "Brad Nicholson" writ
First, as a long time user of the pgextwlist extension, I'm happy to see
this functionality appearing in core. However, as a long term user of that
extension, I can say that ability to create an extension as a non-super
user is pretty limited in itself in a lot of cases. Many extensions both
in
"Zwettler Markus (OIZ)" wrote on 2019/11/08
11:54:14 AM:
> > (please don't top post, makes the replies hard to follow)
>
> > patronictl switchover
>
> > follow the prompts
>
> > there is also a /switchover API endpoint you can use.
>
> > Brad
>
> I wondered about your "patronictl switchover + sy
"Zwettler Markus (OIZ)" wrote on 2019/11/08
11:27:00 AM:
> From: "Zwettler Markus (OIZ)"
> To: Brad Nicholson
> Cc: Adrian Klaver , "pgsql-
> gene...@lists.postgresql.org"
> Date: 2019/11/08 11:27 AM
> Subject: [EXTERNAL] AW: AW: AW: AW:
"Zwettler Markus (OIZ)" wrote on 2019/11/08
11:02:49 AM:
> From: "Zwettler Markus (OIZ)"
> To: Brad Nicholson
> Cc: Adrian Klaver , "pgsql-
> gene...@lists.postgresql.org"
> Date: 2019/11/08 11:02 AM
> Subject: [EXTERNAL] AW: AW: AW: AW: AW:
"Zwettler Markus (OIZ)" wrote on 2019/11/08
07:51:33 AM:
> From: "Zwettler Markus (OIZ)"
> To: Brad Nicholson
> Cc: Adrian Klaver , "pgsql-
> gene...@lists.postgresql.org"
> Date: 2019/11/08 07:51 AM
> Subject: [EXTERNAL] AW: AW: AW: AW:
"Zwettler Markus (OIZ)" wrote on 2019/11/07
11:32:42 AM:
> From: "Zwettler Markus (OIZ)"
> To: Adrian Klaver , "pgsql-
> gene...@lists.postgresql.org"
> Date: 2019/11/07 11:33 AM
> Subject: [EXTERNAL] AW: AW: AW: broken backup trail in case of
> quickly patroni switchback and forth
>
> 3)
>
Stephen Frost wrote on 2019/10/11 08:50:53 AM:
> From: Stephen Frost
> To: Ajay Pratap
> Cc: Postgres General
> Date: 2019/10/11 08:51 AM
> Subject: [EXTERNAL] Re: Pgbackrest backup is too slow
>
> Greetings,
>
> * Ajay Pratap (ajaypra...@ameyo.com) wrote:
> > I have a Centos 7 server which r
Michael Paquier wrote on 06/27/2019 11:17:10 PM:
> From: Michael Paquier
> To: Brad Nicholson
> Cc: Grigory Smolkin , pgsql-
> gene...@lists.postgresql.org
> Date: 06/27/2019 11:17 PM
> Subject: [EXTERNAL] Re: Re: Enabling checksums on a streaming replica
>
> On Wed, Ju
Grigory Smolkin wrote on 06/26/2019 12:37:10 PM:
> From: Grigory Smolkin
> To: pgsql-general@lists.postgresql.org
> Date: 06/26/2019 12:37 PM
> Subject: [EXTERNAL] Re: Enabling checksums on a streaming replica
>
> Hello!
> Very interesting idea, but what about full page writes, that comes
> from
I'm wondering about the validity of using the pg_checksums utility to
enable checksum's on a streaming replication standby, and then promoting
that standby as a way to enable checksums on existing clusters.
I've tested the process out, and it "works" (by works I mean doesn't blow
up or log any er
> From: Rich Shepard
> To: pgsql-general@lists.postgresql.org
> Date: 05/14/2019 05:19 PM
> Subject: [EXTERNAL] Re: Table update: restore or replace?
> And I think I'll set up a cron job to do a database dump each day with
the
> date appended to the file name in the bash shell script.
Might I su
Michael Paquier wrote on 04/02/2019 01:05:01 AM:
> From: Michael Paquier
> To: "Jonathan S. Katz"
> Cc: Tom Lane , Magnus Hagander
> , Daniel Verite ,
> pgsql-general
> Date: 04/02/2019 01:05 AM
> Subject: Re: CVE-2019-9193 about COPY FROM/TO PROGRAM
>
> On Mon, Apr 01, 2019 at 10:04:32AM -040
Andreas Kretschmer wrote on 03/28/2019 07:28:53
AM:
> >
> > Ummm... Will it use an index (a BTree index)?
> >
>
> test=# explain select * from emp where ename = 'aaa';
> QUERY PLAN
> -
> Seq Scan on emp (cost=0.00..25.
Thomas Tignor wrote on 03/25/2019 08:25:49 PM:
>
> Hi Brad,
> Thanks for writing. As I mentioned to Vijay, the "source" is a JVM
> using the postgres v42.0.0 JDBC driver. I do not believe we have any
> explicit encoding set, and so I expect the client encoding is
> SQL_ASCII. The DB is most defi
Vijaykumar Jain wrote on 03/25/2019 03:07:19 PM:
> but why do you think this as db corruption and not just a bad input?
> https://urldefense.proofpoint.com/v2/url?
>
u=https-3A__github.com_postgres_postgres_blob_master_src_pl_plperl_expected_plperl-5Flc-5F1.out&d=DwIFaQ&c=jf_iaSHvJObTbx-
> siA
19 matches
Mail list logo
