Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?
David Ventimiglia <davidaventimiglia@hasura.io>
From: David Ventimiglia <davidaventimiglia@hasura.io>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2024-01-13T23:10:42Z
Lists: pgsql-general
I'm asking a question about technology. It has an answer. Whatever that answer is, it's independent of anyone's purpose. On Sat, Jan 13, 2024, 4:53 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote: > *No,* that's a technology problem. What is the purpose of storing them > back in the database using psql? > > On Sat, Jan 13, 2024 at 4:34 PM David Ventimiglia < > davidaventimiglia@hasura.io> wrote: > >> The business problem I'm trying to solve is: >> >> "How do I capture logical decoding events with the wal2json output >> encoder, filter them with jq, and pipe them to psql, using pg_recvlogical?" >> >>> >>>>>