[GENERAL] Logical decoding error

2017-11-02 Thread Mark Fletcher
Hello, Running Postgres 9.6.5, we're using logical decoding to take changes to the database and propagate them elsewhere in our system. We are using the PGX Go Postgres library, at https://github.com/jackc/pgx, and we are using the test_decoding plugin to format the changes. We are using 6 slots/h

Re: [GENERAL] Logical decoding error

2017-11-02 Thread Mark Fletcher
On Thu, Nov 2, 2017 at 9:59 AM, Steve Atkins wrote: > > Where are the errors coming from - your code or pgx? If it's from pgx, > what's the exact error? ('w' is regular replication payload data, so it'd > be expected as a copydata payload message type, but would be an error for a > replication me

[GENERAL] pg_logical/snapshots directory

2017-11-04 Thread Mark Fletcher
Hi All, While trying to track down my logical decoding problem, I noticed that my pg_logical/snapshots directory has ~5000 .snap files and is growing at a rate of about 4 files a minute. The earliest file is from yesterday afternoon, dating to the time I took our site down and added a column to a

Re: [GENERAL] pg_logical/snapshots directory

2017-11-05 Thread Mark Fletcher
On Sat, Nov 4, 2017 at 10:45 AM, Mark Fletcher wrote: > > While trying to track down my logical decoding problem, I noticed that > my pg_logical/snapshots directory has ~5000 .snap files and is growing at a > rate of about 4 files a minute. The earliest file is from yesterday > af