Hi everyone,
Is there is any option to perform logical decoding on an active replication
slot.
I'm trying to decode a replication slot but it throughs an error as below.
ERROR: replication slot "my_sub" is active for PID 2525720
Sorry guys, what I meant was to log the tuple returned count not the values
to get printed in logs.
On Fri, Nov 22, 2024, 9:46 PM David G. Johnston
wrote:
> On Fri, Nov 22, 2024 at 12:32 AM Jethish Jethish
> wrote:
>
>> If an select query is fired I need the query returned val
Hi David,
If an select query is fired I need the query returned values needs to be
logged in my PostgreSQL log file.
For example if a select query returns 5 rows I need the same in the log
file
On Fri, Nov 22, 2024, 10:49 AM David G. Johnston
wrote:
> On Thursday, November 21, 2024, Jeth
Hi Everyone,
Is it possible to log the rows returned by a query in the PostgreSQL logs?
for the time the COPY takes (reset primary_conninfo). You could
> increase max_standby_streaming_delay. Perhaps you could also wrap the COPY
> operation in pg_wal_replay_pause() / pg_wal_replay_resume().
>
> On Thu, May 23, 2024 at 11:59 AM Jethish Jethish
> wrote:
>
>&g
I'm frequently facing the below error while performing backup. Someone
please tell how solve this issues.
Failed : pg_dump: error: Dumping the contents of table "botsession" failed:
PQgetResult() failed. pg_dump: error: Error message from server: ERROR:
canceling statement due to conflict with re
