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.