Re: Request to help on Query improvement suggestion.

On Fri, 2020-05-22 at 16:15 +0530, devchef2020 d wrote: > PostgreSQL : 9.5.15 > Created Indexes on column parental_path: > = > > CREATE INDEX cable_pair_parental_path_idx > ON SCHEMA.TABLE_NAME > USING btree > (md5(parental_path) COLLATE pg_catalog."default")

Re: Query returns no rows in pg_basebackup cluster

On Sunday, May 24, 2020, Andrus wrote: > Hi! > > Backup in created in Windows from Linux server using pg_receivewal and >>> pg_basebackup . >>> Can this backup used for PITR in Linux ? >>> >> No. Physical copies need to be based on the same platform. If you >> wish to replicate a cluster withou

Re: Query returns no rows in pg_basebackup cluster

On Mon, May 25, 2020 at 09:02:49AM +0300, Andrus wrote: > Will logical replication also allow two modes: > 1. PITR recovery can used if needed > 2. Hot standby: User databases in both clusters contain same data. > > How to set logical replication for all user databases in cluster so that > when

Re: Query returns no rows in pg_basebackup cluster

Hi! No. Physical copies need to be based on the same platform. Does the O/S that the client software runs on really affect this? To the extent that the O/S determines text sort order, yes; see thread. The short answer here is that we aren't going to support such cases. If you try to replicate

Re: Query returns no rows in pg_basebackup cluster

Hi! Backup in created in Windows from Linux server using pg_receivewal and pg_basebackup . Can this backup used for PITR in Linux ? No. Physical copies need to be based on the same platform. If you wish to replicate a cluster without any platform, architecture or even not-too-many major vers

Re: pg_dump crashes

Unfortunately not. I discovered the issue rather late. The last working backup is about 2 months old. On Fri, May 22, 2020 at 5:36 PM Adrian Klaver wrote: > On 5/22/20 8:17 AM, Nico De Ranter wrote: > > > > > > On Fri, May 22, 2020 at 5:14 PM Adrian Klaver > >

Re: Query returns no rows in pg_basebackup cluster

"David G. Johnston" writes: > On Sun, May 24, 2020 at 4:10 PM Michael Paquier wrote: >> No. Physical copies need to be based on the same platform. > Does the O/S that the client software runs on really affect this? To the extent that the O/S determines text sort order, yes; see thread. The sh

Re: Query returns no rows in pg_basebackup cluster

On Sun, May 24, 2020 at 4:10 PM Michael Paquier wrote: > On Fri, May 22, 2020 at 09:53:37AM +0300, Andrus wrote: > > Backup in created in Windows from Linux server using pg_receivewal and > pg_basebackup . > > Can this backup used for PITR in Linux ? > > No. Physical copies need to be based on t

Re: Query returns no rows in pg_basebackup cluster

On Fri, May 22, 2020 at 09:53:37AM +0300, Andrus wrote: > Backup in created in Windows from Linux server using pg_receivewal and > pg_basebackup . > Can this backup used for PITR in Linux ? No. Physical copies need to be based on the same platform. If you wish to replicate a cluster without any

Re: pg_basebackup + incremental base backups

Greetings, * Christopher Pereira (krip...@imatronix.cl) wrote: > Ok, we want to use pgbackrest to *rebuild a standby that has fallen behind* > (where pg_rewind won't work). After reading the docs, we believe we should > use this setup: > > a) Primary host: primary cluster > > b) Repository host:

Re: pg_basebackup + incremental base backups

We've contemplated adding support for something like this to pgbackrest, since all the pieces are there, but there hasn't been a lot of demand for it and it kind of goes against the idea of having a proper backup solution, really.. It'd also create quite a bit of load on the primary to checksum

Help with streaming replication protocol

Hello, So from a high level, I understand that Postgres will send messages (XLogData) and the receiver needs to ack these messages so Postgres knows it's ok to delete data from disk. I don't understand some details of the protocol though. Working off the documentation here: https://www.postgres