[GENERAL] Postgresql CDC tool recommendations ?

Guys Any recommendation on a good CDC tool that can be used to push postgresql changes to Kafka in json format ? Thanks Avi

Re: [GENERAL] MultiXact member wraparound protections are disabled

Your right we looked back in our old logs and we do see the messages there as well. Still what I'm not getting is since we restarted the database after SAN FC re-cable effort auto-vacuum is running on all the threads continuous. I have never seen auto-vacuum using all the threads 24*7 on this datab

Re: [GENERAL] MultiXact member wraparound protections are disabled

We are also seeing this in our log file Oct 12 19:08:14 site-db01a postgres[6117]: [7589-1] app=,user=,db=,ip=LOG: MultiXact member wraparound protections are disabled because oldest checkpointed MultiXact 1 does not exist on disk On Wed, Oct 12, 2016 at 7:13 PM, avi Singh wrote: > Got

Re: [GENERAL] MultiXact member wraparound protections are disabled

s in an index: 32 Maximum size of a TOAST chunk:1996 Size of a large-object chunk: 2048 Date/time type storage: 64-bit integers Float4 argument passing: by value Float8 argument passing: by value Data page checksum version: 0 O

Re: [GENERAL] MultiXact member wraparound protections are disabled

Sharing output postgres@site-db01a:~/cmates/data/pg_multixact/members $ ls 0002 0004 0006 0008 000A 000C 000E 0010 0012 0014 0016 0018 001A 0001 0003 0005 0007 0009 000B 000D 000F 0011 0013 0015 0017 0019 001B postgres@site-db01a:~/cmates/data/pg_multixact/offsets $ l

Re: [GENERAL] Slony error please help

ng fine since than On Thu, Jun 16, 2016 at 8:44 PM, Venkata Balaji N wrote: > > On Fri, Jun 17, 2016 at 5:36 AM, avi Singh > wrote: > >> I am working on a project to upgrade postgresql from 9.4 to 9.5 we use >> slony for replication >> >> >> Phase 1

[GENERAL] Slony error please help

I am working on a project to upgrade postgresql from 9.4 to 9.5 we use slony for replication Phase 1 problem 1. We had slony version slony1-94-2.2.2-1.rhel5.x86_64 installed when i tried testing upgrade on my test env it failed coz slony 2.2.2 version is not compatible with 9.5 so i upgraded sl

[GENERAL] grant select on pg_stat_activity

Guys Whats the best way to grant select on pg_stat_activity so that non super user can access this view. Thanks Avi

Re: [GENERAL] Postgresql upgrade 9.5

Upgrade from 9.4.5 On Wed, Mar 2, 2016 at 3:09 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Mar 2, 2016 at 4:03 PM, avi Singh > wrote: > >> Guys if anyone of you upgraded Prod database to 9.5.1 have any feedback >> please share. I have to plan

[GENERAL] Postgresql upgrade 9.5

Guys if anyone of you upgraded Prod database to 9.5.1 have any feedback please share. I have to plan an upgrade, still debating if i should wait for 9.5.2 or not? Whats your take on that? Thanks Avi