Postgres Pro
Downloads
Home   >   mailing lists

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? - Mailing list pgsql-general

From David Ventimiglia
Subject Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?
Date
Msg-id CADE7j6hLSQuiAJbDdo2Ut1G0+ogYo1AXHJC4WRfiMdvX1cXOvw@mail.gmail.com
Whole thread Raw
In response to Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?  (Ron Johnson <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
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?"

pgsql-general by date:

Previous
From: David Ventimiglia
Date:
Subject: Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?
Next
From: Lan Xu
Date:
Subject: Help with "Create Extension unaccent"