Postgres DB hacked.

Dear All, Thanks for your support. We faced the below issue and our all DB backup data has lost. It seems Hacker deleted all the tables in the DB and created a single table called "warning". when I am trying to select this table so it's showing Error (relation "warning" does not exist). Hacker c

Re: v11.5- v15.3 upgrade (linux)

nd low downtime), and logical replication (complex and least downtime). Since OS upgrade is also part of the equation, dump/restore or logical  are better candidates. Due to OS collation difference I would avoid binary upgrade path. -- Kind Regards, Yogesh Sharma PostgreSQL, Linux, and Network

Size of pg_multixact/members increases 11355

Dear All, I am using PostgreSQL 9.3.6 version and PGDATA pg_multixact.members folder size is increased to around 3GB. How to reduce this folder size and how to fix this issue? Is it realted to poatgres issue? If yes how to reproduce this issue? Thanks in advance. Regards, Yogesh

Re: Size of pg_multixact/members increases 11355

Please share direction to resolve below issue. Regards, Yogesh On Tuesday, December 12, 2017, Yogesh Sharma wrote: > Dear All, > > I am using PostgreSQL 9.3.6 version and PGDATA pg_multixact.members folder > size is increased to around 3GB. How to reduce this folder size and how t

Re: Size of pg_multixact/members increases 11355

12, 2017 at 2:52 AM, Yogesh Sharma > > wrote: > >> > >> Dear All, > >> > >> I am using PostgreSQL 9.3.6 version and PGDATA pg_multixact.members > folder > >> size is increased to around 3GB. How to reduce this folder size and > how to >

Re: Size of pg_multixact/members increases 11355

Dear Thomas , Thanks for sharing information. Is it possible to remove mentioned folder files in some time intervals by some DB command? Currently i can not upgrade to 3.6.20. So please share if any solution is available. Regards, Yogesh On Wednesday, December 13, 2017, Yogesh Sharma wrote

Re: Size of pg_multixact/members increases 11355

, 2017, Tomas Vondra wrote: > > > On 12/13/2017 01:42 PM, Yogesh Sharma wrote: > > Dear Thomas , > > > > Thanks for sharing information. > > > > Is it possible to remove mentioned folder files in some time intervals > > by some DB command? > > Current

Re: Size of pg_multixact/members increases 11355

Dear All, I have upgraded version from 9.3.6 to 9.3.20 but this issue is not resolved. can you please suggest in which version this file size are not increased. Regards, Yogesh On Thursday, December 14, 2017, Alvaro Herrera wrote: > Yogesh Sharma wrote: > > Dear Thomas , > >

Regarding pg_multixact/members folder size cleanup in postgres 9.3.6.

Dear All, Thanks for your support and guidance. I am using postgres 9.3.6 version and i am using multiple INSERT/UPDATE SQL commands with explicit share lock. I know pg_multixact/members folder contains transactions of share lock. But these files are continuously increases. I have checked Postgre

Re: Regarding pg_multixact/members folder size cleanup in postgres 9.3.6.

Dear David, Thanks for update. I have also checked in postgres 9.3.21 and 9.5.x version. But this is same as 9.3.6 postres version. Regards, Yogesh On Wednesday, February 14, 2018, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Feb 14, 2018 at 9:06 AM, Yoge

Re: Regarding pg_multixact/members folder size cleanup in postgres 9.3.6.

o how to set this > behavior through postgres parameters? > > > Regards, > Yogesh > > On Wednesday, February 14, 2018, David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Wed, Feb 14, 2018 at 9:06 AM, Yogesh Sharma >> wrote: >> >&