Postgres Pro
Downloads
Home   >   mailing lists

While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option - Mailing list pgsql-admin

From Naveed Iftikhar
Subject While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option
Date
Msg-id 808751752.1562387.1715492644219@mail.yahoo.com
Whole thread Raw
In response to Re: cloudNativePg bootstrap from dump  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option
List pgsql-admin
Tree view
Hi Experts,

I just trying to create a user in postgres and getting following errors

postgres=#create user svc_dba;
ERROR: require a VALID UNTIL option

postgres=#create user svc_dba VALID UNTIL 'Jan 31 2030';
ERROR: require a VALID UNTIL option with a date beyond 120 days

How can I just get rid of this VALID UNTIL option b'coz in past I have created user with just 'create user xxxx; and it worked.  Please suggest



Best Regards
 -Naveed-

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: PostgreSQL on netapp AFF C250A storage ?
Next
From: Julien Rouhaud
Date:
Subject: Re: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option