Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On 12/11/24 11:12, Bharani SV-forum wrote: Team As suggested from old server, post shutdown of DB, I did OS level dump of PG_DATA folder and had restored in the new server. If you follow the process shown here: https://www.postgresql.org/message-id/CAKAnmmKZdhnhdNRd3OgDyEco9OPkT%3DqA_TeWMFMRv

Re: Credcheck- credcheck.max_auth_failure

On 12/11/24 09:57, Greg Sabino Mullane wrote: On Wed, Dec 11, 2024 at 5:46 AM 張宸瑋 > wrote: In the use of the Credcheck suite, the parameter "credcheck.max_auth_failure = '3'" is set in the postgresql.conf file to limit users from entering incorrect passw

Re: Credcheck- credcheck.max_auth_failure

On Wed, Dec 11, 2024 at 1:44 PM Ron Johnson wrote: > Isn't this a pretty common password setting? I know that for at least 35 > years, and going back to the VAX/VMS days I've been locked out for X hours > if I typed an invalid password. Same on Windows and I think also Linux > (though ssh publ

Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

TeamAs suggested from old server, post shutdown of DB, I did OS level dump of PG_DATA folder and had restored in the new server. Any idea on how to install the older binary postgres 13.18 ( OS=Amazon Linux 2023.6.20241121) under a dedicated folder suffixed as the following e.g.) /usr/pgsql1318

Re: Credcheck- credcheck.max_auth_failure

On Wed, Dec 11, 2024 at 12:57 PM Greg Sabino Mullane wrote: > On Wed, Dec 11, 2024 at 5:46 AM 張宸瑋 wrote: > >> In the use of the Credcheck suite, the parameter >> "credcheck.max_auth_failure = '3'" is set in the postgresql.conf file to >> limit users from entering incorrect passwords more than th

Re: Credcheck- credcheck.max_auth_failure

On Wed, Dec 11, 2024 at 5:46 AM 張宸瑋 wrote: > In the use of the Credcheck suite, the parameter > "credcheck.max_auth_failure = '3'" is set in the postgresql.conf file to > limit users from entering incorrect passwords more than three times, after > which their account will be locked. > Won't that

Re: Credcheck- credcheck.max_auth_failure

On 12/11/24 02:46, 張宸瑋 wrote: In the use of the Credcheck suite, the parameter "credcheck.max_auth_failure = '3'" is set in the postgresql.conf file to limit users from entering incorrect passwords more than three times, after which their account will be locked. Due to certain requirements, I

Credcheck- credcheck.max_auth_failure

In the use of the Credcheck suite, the parameter "credcheck.max_auth_failure = '3'" is set in the postgresql.conf file to limit users from entering incorrect passwords more than three times, after which their account will be locked. Due to certain requirements, I would like to ask if there is a way

Re: Clarification of behaviour when dropping partitions

Yes, right. I wonder if the team sees an opportunity for some optimization here, supporting such a scenario efficiently. I can't think of any downsides to it but I may be missing something. Cheers. On Thu, Dec 5, 2024 at 2:38 AM Laurenz Albe wrote: > On Wed, 2024-12-04 at 23:00 +0100, Bolaji Wa