Advice for installing wal2json on a fly postgres machine?

I’m trying to get a PostGraphile app running, and I need wal2json for the real-time subscriptions.

Running locally, I need to update postgres.conf:

wal_level = logical
max_wal_senders = 10
max_replication_slots = 10

That’s easily done with the fly cli, but the next part I’m not clear on:

git clone https://github.com/eulerto/wal2json.git
cd wal2json
USE_PGXS=1 make
USE_PGXS=1 make install

Any suggestions on how to go about this? I know we can ssh into the postgres machine itself, but I’m not clear on how permanent changes I make to it are, and there are also no tools whatsoever available on said machine (make, etc.). I’m at a bit of a loss as to how to proceed.

From the notes, it seems like e.g. RDS runs (an older version of) wal2json by default, so I’m expecting the fly approach to be a bit more hands-on.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.