Re: Debugging postgres on Windows - could not open directory "/lib"

2023-02-22 Thread Adrian Klaver
On 2/21/23 17:18, Cathy Xie wrote: On Wed, Feb 22, 2023 at 6:54 AM Adrian Klaver Hi Adrian, Thanks for your email! 1) How did you build it? I installed ActivateState Perl, Bison, and Flex. Then I ran the command ```build Debug``` under directory postgres/src/tools/msvc 2)

Re: Memory leak using when using libpq PQExecParams() CRYPTO_zalloc()

2023-02-22 Thread Jeffrey Walton
On Wed, Feb 22, 2023 at 8:35 AM Michael Arnold wrote: > > Am looking for guidance on how to fix a memory leak when using libpq > PQExecParams(). Memory leaks through CRYPTO_zalloc() and arises when using > json_agg(). None-JSON based PQExecParams() calls are not leaking. > > Using Postgresql

Memory leak using when using libpq PQExecParams() CRYPTO_zalloc()

2023-02-22 Thread Michael Arnold
Hi, Am looking for guidance on how to fix a memory leak when using libpq PQExecParams(). Memory leaks through CRYPTO_zalloc() and arises when using json_agg(). None-JSON based PQExecParams() calls are not leaking. Using Postgresql 13.6 (Ubuntu 13.6-0ubuntu0.21.10.1) on x86_64-pc-linux-gnu,

RE: Event Triggers unable to capture the DDL script executed

2023-02-22 Thread n.kobzarev
>>-Исходное сообщение- >>От: Laurenz Albe >>Отправлено: 22 февраля 2023 г. 12:52 >>Кому: Neethu P ; pgsql-general >> >>Тема: Re: Event Triggers unable to capture the DDL script executed >>On Wed, 2023-02-22 at 07:57 +, Neethu P wrote: >>> We are using event triggers to capture

Re: Event Triggers unable to capture the DDL script executed

2023-02-22 Thread Laurenz Albe
On Wed, 2023-02-22 at 07:57 +, Neethu P wrote: > We are using event triggers to capture the DDL changes in a postgres database. > However, we are unable to get the column information & the actual DDL script > executed, while a table is altered.  > Also, in the postgres documentation for

PostgreSQL optimizations for CoW FS

2023-02-22 Thread HECTOR INGERTO
Let’s say we have to run a PostgreSQL instance on top of a copy on write filesystem like ZFS or BTRFS. In adittion to set full_page_writes = off, what other optimizations can be done on the PostgreSQL side? Regards, Héctor

Event Triggers unable to capture the DDL script executed

2023-02-22 Thread Neethu P
Hi team, We are using event triggers to capture the DDL changes in a postgres database. However, we are unable to get the column information & the actual DDL script executed, while a table is altered. Also, in the postgres documentation for pg_event_trigger_ddl_commands ()- it is mentioned as