Re: idle_in_transaction_session_timeout

On Sat, May 8, 2021 at 7:55 AM Vijaykumar Jain < vijaykumarjain.git...@gmail.com> wrote: > Why do you want to increase that timeout ? > I hope you are aware long idle in transactions connections would delay > vacuuming and result in much larger bloats and slow down the db over period > of time. >

Re: Postgres crashes at memcopy() after upgrade to PG 13.

Hi Thomas, On Sun, Mar 14, 2021 at 10:01 PM Avinash Kumar wrote: > Hi Thomas, > > On Sun, Mar 14, 2021 at 9:40 PM Thomas Munro > wrote: > >> On Mon, Mar 15, 2021 at 1:29 PM Avinash Kumar >> wrote: >> > Is this expected when replication is happening betwe

Re: Postgres crashes at memcopy() after upgrade to PG 13.

Hi Thomas, On Sun, Mar 14, 2021 at 9:40 PM Thomas Munro wrote: > On Mon, Mar 15, 2021 at 1:29 PM Avinash Kumar > wrote: > > Is this expected when replication is happening between PostgreSQL > databases hosted on different OS versions like Ubuntu 16 and Ubuntu 20 ? > Or, d

Re: Question about logically replicating a multi-TB database

Hi, On Sat, Jan 23, 2021 at 7:28 PM Ron wrote: > > https://www.postgresql.org/docs/12/logical-replication-architecture.html > > "30.5.1. Initial Snapshot > The initial data in existing subscribed tables are snapshotted and copied > in > a parallel instance of a special kind of apply process. Th

Re: Bytea Example

Hi Naveen, It's not easy for us to read if you top post. Always reply inline please. On Thu, Aug 13, 2020 at 10:57 AM Naveen Kumar wrote: > I am not using any programming language. I am simply using PostgreSQL 12 > version that's all > Oracle has BLOB to store Binary data and PG has BYTEA. In

Re: Postgres Point in time Recovery (PITR),

On Mon, Oct 21, 2019 at 8:47 PM Alan Hodgson wrote: > On Mon, 2019-10-21 at 20:40 +0530, Avinash Kumar wrote: > > can't he destroy the offline backups and your database ? > This is not a right justification to encouraging Offline Backups over > Online Backups. > If you ar

Re: Postgres Point in time Recovery (PITR),

Hi, On Mon, Oct 21, 2019 at 8:16 PM Alan Hodgson wrote: > On Mon, 2019-10-21 at 16:40 +0530, Avinash Kumar wrote: > > > We need to ensure that we have safe backup locations, for example, push > them to AWS S3 and forget about redundancy. > Why do you think only Offline Ba

Re: Postgres Point in time Recovery (PITR),

On Mon, Oct 21, 2019 at 4:19 PM Fabio Ugo Venchiarutti < f.venchiaru...@ocado.com> wrote: > On 21/10/2019 09:52, Luca Ferrari wrote: > > On Sat, Oct 19, 2019 at 7:46 PM Daulat Ram > wrote: > >> One more questions is, how backups are useful if we have streaming > replication . As I know, we can pr

Re: Postgres Point in time Recovery (PITR),

e damage. Because, the damage has happened on both Master & Standby. Regards, Avinash Vallarapu. > > > Thanks > > > > *From:* Avinash Kumar > *Sent:* Friday, October 18, 2019 5:28 PM > *To:* David Steele > *Cc:* Luca Ferrari ; Andreas Joseph Krogh < > andr...@

Re: Postgres Point in time Recovery (PITR),

Hi Daulat, PITR entirely depends on what type of backups you choose. Sometimes, to reduce the amount of downtime involved while restoring and recovering a backup, you may also use a additional delayed standby. You could use the PG built-in feature to delay the replication and fast-forward it to th

Re: how to upgrade production PostgreSQL from 9.4 to 11.3

Hi Rahul, You may look into the following blogs. https://www.percona.com/blog/2019/04/12/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/ https://www.percona.com/blog/2019/04/04/replication-between-postgresql-versions-using-logical-replication/ https://www.percona.com/bl