Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

From: David Ventimiglia <davidaventimiglia(at)hasura(dot)io>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?
Date: 2024-01-13 23:10:42
Message-ID: CADE7j6hLSQuiAJbDdo2Ut1G0+ogYo1AXHJC4WRfiMdvX1cXOvw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)gmail(dot)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(at)hasura(dot)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?"
>>
>>>
>>>>>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lan Xu 2024-01-14 05:52:44 Help with "Create Extension unaccent"
Previous Message David Ventimiglia 2024-01-13 23:07:06 Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?