Re: Logging the query executed on the server

2022-07-23 Thread Igor Korot
Hi, Steve, On Sun, Jul 24, 2022 at 12:51 AM Steve Baldwin wrote: > > Hi Igor, > > Before you issue your query, try something like this: > > (from psql, but hopefully you get the idea) > > b2bcreditonline=# set log_min_duration_statement to 0; > SET > b2bcreditonline=# set log_statement to 'all';

Re: Logging the query executed on the server

2022-07-23 Thread Steve Baldwin
Hi Igor, Before you issue your query, try something like this: (from psql, but hopefully you get the idea) b2bcreditonline=# set log_min_duration_statement to 0; SET b2bcreditonline=# set log_statement to 'all'; SET Ref: https://www.postgresql.org/docs/current/sql-set.html, https://www.postgres

Logging the query executed on the server

2022-07-23 Thread Igor Korot
Hi, Is it possible to log the query that will be executed on the server? I'm writing an application that connects to the server through ODBC and libpq. For some reason ODBC interface is failing - it desn't return any rows So I'm thinking if I have a proof that the query I am actually executing is

Re: 20220722-pg_dump: error: invalid number of parents 0 for table

2022-07-23 Thread Adrian Klaver
On 7/23/22 07:54, Adrian Klaver wrote: On 7/22/22 21:27, Techsupport wrote: Thanks for your reply Adrian Klaver, Yes, I have the tablespace. It is not located in the default data directory. It is comes under new directory Please expand on this: 1) Did it change location when you moved the

Re: 20220722-pg_dump: error: invalid number of parents 0 for table

2022-07-23 Thread Adrian Klaver
On 7/22/22 21:27, Techsupport wrote: Thanks for your reply Adrian Klaver, Yes, I have the tablespace. It is not located in the default data directory. It is comes under new directory Please expand on this: 1) Did it change location when you moved the data directory? 2) If so where was it pre

Logical replication versus pglogical on PostgreSQL 14

2022-07-23 Thread Rory Campbell-Lange
I'm keen to learn of the differences between logical replication in PostgreSQL 14 and how this is different from the pglogical extension. Our intended use case is to have 200-300 publishers off many small databases aggregating to 20-30 central databases on another PostgreSQL instance on the same m