Re: can't get psql authentication against Active Directory working

2023-03-12 Thread Stephen Frost
Greetings, * Tomas Pospisek (t...@sourcepole.ch) wrote: > On 25.02.23 00:52, Stephen Frost wrote: > > * Tomas Pospisek (t...@sourcepole.ch) wrote: > > > On 21.02.23 16:29, Stephen Frost wrote: > > > > * Tomas Pospisek (t...@sourcepole.ch) wrote: > > > > > On 20.02.23 15:17, Stephen Frost wrote: >

Re: Practice advice for use of %type in declaring a subprogram's formal arguments

2023-03-12 Thread Bryn Llewellyn
> david.g.johns...@gmail.com wrote: > >> b...@yugabyte.com wrote: >> >> Do you (all) think that, notwithstanding this, it's a good plan to use >> "%type" for the declaration of a formal argument just for the reason that it >> documents your intention explicitly? > > If my function is likely to

Re: Help? Unexpected PostgreSQL compilation failure using generic compile script

2023-03-12 Thread Adrian Klaver
On 3/12/23 14:43, Martin Goodson wrote: Hello. For reasons I won't bore you with, we compile PostgreSQL from source rather than use the standard packages for some of our databases. So a fairly basic script that has been used for years suddenly fails on a fairly generic RHEL 7.9 server.

Re: Help? Unexpected PostgreSQL compilation failure using generic compile script

2023-03-12 Thread Martin Goodson
On 12/03/2023 21:52, Tom Lane wrote: Martin Goodson writes: So I simply removed the --with-gssapi, and tried again. AND IT FAILED AGAIN. This time it failed claiming it couldn't find the ldap library. Which is most -definitely- present. Hard to debug this sort of thing remotely when you don't

Re: Help? Unexpected PostgreSQL compilation failure using generic compile script

2023-03-12 Thread Tom Lane
Martin Goodson writes: > So I simply removed the --with-gssapi, and tried again. > AND IT FAILED AGAIN. > This time it failed claiming it couldn't find the ldap library. Which is > most -definitely- present. Hard to debug this sort of thing remotely when you don't supply the exact error messages

Help? Unexpected PostgreSQL compilation failure using generic compile script

2023-03-12 Thread Martin Goodson
Hello. For reasons I won't bore you with, we compile PostgreSQL from source rather than use the standard packages for some of our databases. We've compiled numerous PostgreSQL versions, from 11.1 to 14.4, using a fairly generic and not particularly complicated compile script that has worked

Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay

2023-03-12 Thread Laurenz Albe
On Sun, 2023-03-12 at 12:00 -0500, Ron wrote: > On 3/12/23 09:01, Laurenz Albe wrote: > > On Sun, 2023-03-12 at 01:53 +0530, Atul Kumar wrote: > > > Could someone help me in telling the difference between these three  > > > parameters > > > 1. max_standby_archive_delay > > > 2. max_standby_streamin

Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay

2023-03-12 Thread Ron
On 3/12/23 09:01, Laurenz Albe wrote: On Sun, 2023-03-12 at 01:53 +0530, Atul Kumar wrote: Could someone help me in telling the difference between these three parameters 1. max_standby_archive_delay 2. max_standby_streaming_delay 3. recovery_min_apply_delay My basic motive is to make the standb

Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay

2023-03-12 Thread Laurenz Albe
On Sun, 2023-03-12 at 01:53 +0530, Atul Kumar wrote: > Could someone help me in telling the difference between these three  > parameters  > 1. max_standby_archive_delay > 2. max_standby_streaming_delay > 3. recovery_min_apply_delay > > My basic motive is to make the standby database server to be d

Re: ERROR: only immutable functions supported in continuous aggregate view

2023-03-12 Thread Martijn de Munnik
Ok, now I understand, thank you. My solution is to create materialized view with intermediate values and the create a normal view on top that uses the intermediate values and the jsonb_build_object function to create the desired result. Kind regards, Martijn de Munnik On 2023-03-11 16:47, To