Re: pg_checksums?

will work. Regards, -- Alexander Kukushkin >

Re: pg_checksums?

did it dozens of times): 1. enable checksums on the standby node 2. start the standby and let it catch up with the primary 3. switchover to a standby node 4. enable checksums on the former primary (now replica). Regards, -- Alexander Kukushkin

Re: Patroni vs pgpool II

strings for this purpose. Regards, -- Alexander Kukushkin

Re: Patroni, slots, and expiring WALs

nt slots configuration (using patronictl edit-config): slots: nodename1: type: physical nodename2: type: physical nodename3: type: physical This way slots representing these members will not be removed. Regards, -- Alexander Kukushkin

Re: Unable to start replica after failover

obackup does a weird thing. It shouldn't restore the partial file instead of the normal when the normal file doesn't exists. Regards, -- Alexander Kukushkin >

Re: Unable to start replica after failover

store_command, instead, it requests a file from the next timeline. Regards, -- Alexander Kukushkin

Re: Unable to start replica after failover

this? Regards, -- Alexander Kukushkin

Re: Unable to start replica after failover

Postgres is requesting the 0002054E00FB file, but somehow gets a 0002054E00FB.partial instead. Why? IMO, pg_probackup does something weird. Regards, -- Alexander Kukushkin

Re: Is there any technical reason why "alter table .. set not null" can't use index?

se the index, but can use an already existing CHECK CONSTRAINT, that could be created as NOT VALID and validated without holding heavy locks. After adding not null you can drop the constraint. Regards, -- Alexander Kukushkin

Re: Highly academic: local etcd & Patroni Cluster for testing on a single host

_basebackup internally (which I assume it does), there > is no way to pass parameters to it. This is also not correct. One can specify arbitrarily parameters for pg_basebackup in the Patroni config file: postgresql: basebackup: tablespace-mapping: /foo=/bar waldir: /my/waldir Regards, -- Alexander Kukushkin

Re: WAL replay issue from 9.6.8 to 9.6.10

Hi, 2018-08-29 6:02 GMT+02:00 Dave Peticolas : > Hello, I'm seeing some issues with WAL replay on a test server running > 9.6.10 using WAL archived from a 9.6.8 primary server. It reliably PANICs > during replay with messages like so: > > WARNING: page 1209270272 of relation base/16422/47496599

RE: PostgreSQL Active-Active

ailover pretty darn fast. Thanks! Stephen Regard, Alexander Kukushkin

Re: Using Token (JWT) authentication mechanism in Postgres

that it is used from postgres. Regards, -- Alexander Kukushkin

Re: Using Token (JWT) authentication mechanism in Postgres

ing its answer. Source code of PAM module is here: https://github.com/CyberDem0n/pam-oauth2 Basically you can do something similar. Either take pam-oauth2 as a reference and add possibility to validate JWT tokens or implement your tokeninfo service. > > > Thank You for your help! > > > > Regards, > > > > Cesar > Regards, -- Alexander Kukushkin