Is psqlodbc_13_02 compatible to M365?

Hello. I would like to know if psqlodbc_13_02 is compatible with M365. Also, could you please tell me which of the psqlodbc_13_02 would be suitable to Windows 10 64-bit?

Re: could not link file in wal restore lines

Can someone with knowledge about PG tell me if this is a bug and if there is any need to worry about data corruption? Here is the issue which I've opened for pgbackrest, the developer confirmed that pgbackrest doesn't change those files at all. https://github.com/pgbackrest/pgbackrest/issues/181

Re: FK Constraint sort order with pg_dump

Christian Barthel writes: > On Thursday, July 21, 2022, Adrian Klaver wrote: >> Why does it matter? > As the comment in pg_dump.c states, logically identical schemas should > produce identical dumps: Agreed, but this is far from the only deficiency in DOTypeNameCompare. If we're going to try to

Re: FK Constraint sort order with pg_dump

On 7/21/22 10:59, Christian Barthel wrote: On Thursday, July 21, 2022, Adrian Klaver wrote: Why does it matter? As the comment in pg_dump.c states, logically identical schemas should produce identical dumps: | * We rely on dependency information to help us determine a safe order, | so * the

Re: FK Constraint sort order with pg_dump

On Thursday, July 21, 2022, Adrian Klaver wrote: > On 7/21/22 10:25, Christian Barthel wrote: >> Hello, The sorting order of FK constraints with the same name is >> based on the OID (because it lands in the “Usually shouldn’t get >> here” OID comparison block at [1]). Wouldn’t it be better if the

Re: FK Constraint sort order with pg_dump

On Thu, Jul 21, 2022 at 10:49 AM Adrian Klaver wrote: > On 7/21/22 10:25, Christian Barthel wrote: > > Hello, > > > > The sorting order of FK constraints with the same name is based on the > > OID (because it lands in the “Usually shouldn’t get here” OID comparison > > block at [1]). Wouldn’t it

Re: FK Constraint sort order with pg_dump

On 7/21/22 10:25, Christian Barthel wrote: Hello, The sorting order of FK constraints with the same name is based on the OID (because it lands in the “Usually shouldn’t get here” OID comparison block at [1]). Wouldn’t it be better if the order of those constraints were based on the table name?

FK Constraint sort order with pg_dump

Hello, The sorting order of FK constraints with the same name is based on the OID (because it lands in the “Usually shouldn’t get here” OID comparison block at [1]). Wouldn’t it be better if the order of those constraints were based on the table name? Details: The above schema is identical exce

Re: Unable to archive logs in standby server

Hi, Le jeu. 21 juil. 2022 à 13:58, Meera Nair a écrit : > Hi team, > > > > With non-exclusive backup method, trying backup from standby node. > > But pg_stop_backup function returns “WAL archiving is not enabled…” and > the logs are not archived to WAL directory configured. > > > > Please check

Unable to archive logs in standby server

Hi team, With non-exclusive backup method, trying backup from standby node. But pg_stop_backup function returns "WAL archiving is not enabled..." and the logs are not archived to WAL directory configured. Please check if I am missing anything in configuring this properly, Server was restarted af

RE: [External]Re: Patroni & PostgreSQL issue

Hi Abdul Wanted to know if this is a standard Patroni feature ? Any reason why the files are not deleted from the replicas when the files were deleted from the primary server. Deepak Menon| Avaya Managed Services-Delivery|+91 9899012875| men...@avaya.com Leave Alert :

Re: More than one Cluster on single server (single instance)

I have resolved this issue and it's working. Thanks On Thu, Jul 21, 2022 at 1:45 PM Daulat wrote: > Thanks for your inputs. > > We are thinking about this approach to consolidate some small applications > of individual clients and to perform administration (data/log/pgbackrest > backups etc.)

Re: plan for function returning table combined with condition

On Wed, Jul 20, 2022 at 8:39 PM Tom Lane wrote: > You want this SQL function to be inlined, but it isn't being. > I think the reason is that (by default) it's VOLATILE, and > inline_set_returning_function doesn't like that: > > * Forget it if the function is not SQL-language or has other > s

Re: More than one Cluster on single server (single instance)

Thanks for your inputs. We are thinking about this approach to consolidate some small applications of individual clients and to perform administration (data/log/pgbackrest backups etc.) separately which is not possible on a single cluster. We have tried to create and start the cluster with differ