Julien Rouhaud <rjuju123@xxxxxxxxx> writes: > On Sun, May 12, 2024 at 06:04:36AM GMT, Naveed Iftikhar wrote: >> Thanks, I think previous DBA has created credcheck extension. How can I remove or bypass or create the user with valid until .. even I provide the valid until but still getting the error. > You should look at the documentation for the exact syntax to use: > https://github.com/MigOpsRepos/credcheck This is pretty rich, because not only is credcheck making up this valid-until date on its own, but then it's objecting to what it made up. 'Jan 31 2030' is a perfectly valid date according to Postgres, and "require a VALID UNTIL option with a date beyond 120 days" is not an error that appears anywhere in core Postgres, even if we somehow failed to do the implied date arithmetic correctly. I think your answer is to remove that extension, preferably with gloves and tongs. regards, tom lane
