Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s620T-009evF-6V for pgsql-admin@arkaria.postgresql.org; Sun, 12 May 2024 05:44:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s620R-008zsy-Hf for pgsql-admin@arkaria.postgresql.org; Sun, 12 May 2024 05:44:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s620R-008zsq-6y for pgsql-admin@lists.postgresql.org; Sun, 12 May 2024 05:44:19 +0000 Received: from sonic304-20.consmr.mail.ne1.yahoo.com ([66.163.191.146]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s620J-000cE9-Tj for pgsql-admin@postgresql.org; Sun, 12 May 2024 05:44:18 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1715492649; bh=syQwg0zxEEB0NzFiOLqEV7xhhOlIe/RtXMjDpXfe2ZY=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=mee3f2II+o7Wzm6+K720NHir/au5Ou6alBDGCxNcEiSqxDb5Ted1TD5UIMAf4eTlR1CdYw5PBtlJVDFk655nJAY8CahDmOFF9cwwpeC7EXdmHS/pJGUUbkkBKxUprUlbVhJUJvpGDE5o/9CKlprRpAs75Fc1qcQr+Kv4cseSvs05USr1nWGelSKKJUVpStzobvrQ97LknrqBrU40Kr+nQW58OwnmLJZggXADEj5gzsAjqec6yxiVEGomhm0pzcJ470nASbsyDEJqjpiMzgKwM8I7PrI5zSAoNGmrpZi0WKk2hz6MLxTYO93G/SSFUG/aGPQ7dSzvqMokaCqOU3sTTA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1715492649; bh=a0b6yYg0R3sSRn+vdcWSnfXb2o3WYy0yqryG4Xvy/3J=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=a+xVt2m2Rr6IVKGrFUfwz2pe4Qig0TL0XD2tOx9eHLrpvEfgSZEnBEZ4ZxjHIWFXDVD2uPnXlMeO0HmgYDukRVdvpSu/Z8ncGhujbAERkc8D3VLkIXvMKstb9LDZSXVdvg3ShiQLX4CnjNg/78IOwDQAMCk+jdhyBdOlRkAkWhf1DBXPnZZyGOGz9pKpw+hyTOcEOdPSbI+D983gbjLcT8QWS3JoqYZ4Cz+tlqlxYtbFLAwl6KY5Vbfg0VvP4bCV7QsujJI9fft5zCoQGxL9e+H35u2OBtoJ554X9dKYsoalG6O+Ezc1PKtV7VeHgZ7Ghs2mNklQHbMpS0c+ArzNbw== X-YMail-OSG: 6O1MU6EVM1nrzi4kI_0qRvzj6Ta_OsuFlq1QEz290TryMVX..ECFR.CBz4TBGYj TnG3ByoXiGTbTGImyTXghJbq1zrAkJ8F.3xi.9S69cE_wlNIHXMADrmP_NW4nzBFjxWvCCp8qP.u AVpT.K0Cb0gjLjypteT990OcdIjRYsZwbtO4Kdd1HxWa94WqwVb5Q5NamJpAs61D82PTr4mTjl9. ePTFzzgdp8vc2xBzJ8Ii6.QdHohO5T2SJoxyGwKONF.13QqlhkVjeEMkaXA4M9RSDnCgdyi5kBjo jjHRnWx8UfVDJ11FvOz9OzRnZ3O2hTaVJie07kRlISgibFiT8UJh59hzX6DmceLKMjZJ4wPmy_4N ZfloDxPi2FC3q99BHPYx6SIrb0d4E0rZDT.TCekFtTb5pmnccj2UojcloB.xewOoES0G6npP65U8 WXO72QtsiOEumSAUetihddWmM2GLh33ZQHTPKVOXdClmwc_gxIJxKquGPju8RGA3bQI9misHwGPQ CkAAPKXqNLHL12xsdyGfM.7qQToY..G6N5F_fOQUPThA.K2X4iAlwZTlgc45TN68dnloV.US2WjV AHHDHRtSjrsx8iii0qqUKhw1qkuYUEr_bCTlaYqeXh.1i.3GILRFySexAC4D0zn.tvffZQBAIBJx aq8tutZT0lTb9gEcUZjOymkcFGkdfhFpZb0KRq60aieIVDKuiAlHdbO6Z55kmJEGz_z6mygvUWK5 gy_nRmdNIzMTsSMcdv3APXOuqYaR1WHgFoVT7JCIc79GEOfb3LDy2D.OX2JgbgAfqcLwENBcWgcJ pA6ZIXkcErlsPVJViYHyQq_FMZNMp6D9zp0q8sh.qdS63dA_8HWwGqHIG..7CZTcuz4RGdmahCPA 24DcbDpxMZ2ySRKz0WEBM_PtyHuyqcXy6Hq8rVOKWyryLnlASLwxuPwyG4iU8ZMm62fcTfncoAV7 kC3TwgM9UC7Q7hY8P1FN5BPjQYXZ9agbDaQuOYFLvavLf.dkttAvfuNdTRkq1nQ4ESlXZIctdbrw Wx2q9JxwxUX9QWGqnaRj4eFtHWPaVGfsPHniEgahGH1XVu6fwei84_UwXVuABNV1JDZW2ecNqRY4 BeXTAQKLoMrCBLf4n8Ml8_59bFbE1LflzJjH3kvKPmZ1gV_orNrVMh3vU7Jd7dJJYj0myHZ4M6iw UhPtmIB.nOuRkH3shv2YCR2jf9R._6ZcuIYlf9iT47ryf43VVJDLDcPaENnUNGmyiEh7c6Fb5a1E CelAoVqxHlLkGJSnnGBmFm2srw9ee.aU8AJ3igcZtqqEF6xB9TpEYamFOujwGnQwtK0KCp6HBaMO siWOFQuWds5ZPYrjjJXDNvcMvT3pyt5lmuJ857HQSRX4jciD50USp0.mdisYP7mQwsRRMDPL_H5X iwpZT6T2HZn9jqg54WwDo93ycfL_vxM9Gx0eMyg04Ezwmc2zLDL0x.wQmTa9RLm4xJk4bqGwSykD a2sEoG3jZMWGrEYMNVsUL9z2KxYb9ut.Hp.tMmBx677qo_q79IQVSJAClMULJXWoQVzpJKcGtzbo AEgeUJC4to2RsNXYaPVliTTwO04NQ6GApjlBxbzvqFg77UHGvnxc6Xnn.V_wq.GigZ6VCWexOwOR pk5p5fgOks1W6BHd.HilqodtYZDq_6s2DPfYPtrumTSQAAwa7CrQW1efunk.K06u4SxRI3vt0ULy QOh4FAEtcmIQLavaw6Qb54BCoCOswr7Sc0wqhmoF3Wdbm1Fjs94rtXvB0sUxYDfPx643HMbrODvG sUjJENlKQu3AZiafrEhFXLqexzhOPRwKgvbe94kHb1.nvGZU30BsG2Akq.bCFBkwWKPvzVnu4av5 v6nELVIYNl5hUAMFGvAPufJcXvqIHfTH_JuMKVoy1mpfcnYf87.cjWE3D2Yr0xPmhg6o.YZbVor1 2CmD1Jop_A4DAYfa1lDo1LJZKgu6XrHmuOY17_01Az0aPf3O_8u2SPY9J7wsQN6pTnl6Ibybi2TR _OH7QioeuVtdulYEJyiMOHXkq6JeChxe0OQ990sVHgzs8Jp_Fmf7jVjQtQLMYA.G6IH5d99g1kvk Sg4xzdCWUhqTrkr0jalJEy1AxCJoWMGviCtYavzh_5NohsLhdEdbvKsKfPOIZB2k7rinOvehcHBw 5Uma_sfVzHOKLdQevNVRVESQGdt7wq6RVNhcAJ5EzuO.oDmRfC7ys8x7.AprWD.kZFtc9j7JXC8e AxmiGeeqJHK8T85FhaFJTKx7tx5dRAm9aibbunSHthJqDpJttlhMnb4pxp_o.HYNvox7I1d0N_3l ZRQ-- X-Sonic-MF: X-Sonic-ID: 48c2554a-6b31-4586-b0de-21ac3498768e Received: from sonic.gate.mail.ne1.yahoo.com by sonic304.consmr.mail.ne1.yahoo.com with HTTP; Sun, 12 May 2024 05:44:09 +0000 Date: Sun, 12 May 2024 05:44:04 +0000 (UTC) From: Naveed Iftikhar To: "pgsql-admin@postgresql.org" Message-ID: <808751752.1562387.1715492644219@mail.yahoo.com> In-Reply-To: <15DE7820-429C-4163-BC59-E7608CF228B8@elevated-dev.com> References: <89AA09AC-A627-4EAB-8B0C-0EE184BD56A2@elevated-dev.com> <15DE7820-429C-4163-BC59-E7608CF228B8@elevated-dev.com> Subject: While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1562386_2029259896.1715492644218" X-Mailer: WebService/1.1.22321 YMailNorrin Content-Length: 2134 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1562386_2029259896.1715492644218 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Experts, I just trying to create a user in postgres and getting following errors postgres=3D#create user svc_dba;ERROR: require a VALID UNTIL option postgres=3D#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 crea= ted user with just 'create user xxxx; and it worked.=C2=A0 Please suggest Best Regards=C2=A0-Naveed- ------=_Part_1562386_2029259896.1715492644218 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Experts,

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

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

po= stgres=3D#create user svc_dba VALID UNTIL 'Jan 31 2030';
ERROR: require a VALID UNTIL option with a date b= eyond 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-
------=_Part_1562386_2029259896.1715492644218--