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';
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
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
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
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
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