MIME-Version: 1.0
References: 
 <CAEQOu1F5NDuv556QtNyqFEPyu4r+3SJAeTsSwGDU6_ECCEDxOA@mail.gmail.com>
In-Reply-To: 
 <CAEQOu1F5NDuv556QtNyqFEPyu4r+3SJAeTsSwGDU6_ECCEDxOA@mail.gmail.com>
From: Muhammad Usman Khan <usman.k@bitnine.net>
Date: Fri, 20 Sep 2024 09:18:34 +0500
Message-ID: 
 <CAPnRvGs3f7zck7YM+efXgW0G9TrgxybouKf7XJzwkadQ7QrgDg@mail.gmail.com>
Subject: Re: How to make superuser from non superuser in PostgreSQL
To: Sunil Jadhav <sunilbjpatil@gmail.com>
Cc: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000014a67106228556c2"
Archived-At: 
 <https://www.postgresql.org/message-id/CAPnRvGs3f7zck7YM%2BefXgW0G9TrgxybouKf7XJzwkadQ7QrgDg%40mail.gmail.com>
Precedence: bulk

--00000000000014a67106228556c2
Content-Type: text/plain; charset="UTF-8"

Hi,
You can try the following options

   - Edit pg_hba.conf file and change authentication method to trust
   Reload postgres iand login without password
   psql -U postgres
   And then you can use alter command
   ALTER USER your_username WITH SUPERUSER;
   - If you have root access to the server than you can directly switch to
   postgres superuser
   sudo -i -u postgres
   psql
   ALTER USER your_username WITH SUPERUSER;
   - If you can't log in with sudo but have access to the PostgreSQL data
   directory, you can start PostgreSQL in single-user mode to reset the
   password
   sudo -u postgres postgres --single -D /var/lib/pgsql/data  (Change your
   path accordingly)
   ALTER USER postgres WITH PASSWORD 'new_password';
   Exit single user mode and start postgres normally


On Thu, 19 Sept 2024 at 18:31, Sunil Jadhav <sunilbjpatil@gmail.com> wrote:

> Hello Team,
>
> I have login with non super user in PostgreSQL instance.
> How to become a super user
> I tried and getting a below error
>  "must be  superuser to alter superuser"
>  How to resolve this?
> I don't know the superuser password?
>
> Thanks for your help in advance
>
> Thanks
> Sunil jadhav
>

--00000000000014a67106228556c2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div dir=3D"ltr" class=3D"gmail_signature" data-smart=
mail=3D"gmail_signature"><div dir=3D"ltr"><div>Hi,<br>You can try the follo=
wing options<br><ul><li>Edit pg_hba.conf file and change authentication met=
hod to trust<br>Reload postgres iand login without password<br>psql -U post=
gres<br>And then you can use alter command<br><span class=3D"gmail-hljs-key=
word">ALTER</span> <span class=3D"gmail-hljs-keyword">USER</span> your_user=
name <span class=3D"gmail-hljs-keyword">WITH</span> SUPERUSER;=C2=A0</li><l=
i>If you have root access to the server than you can directly switch to pos=
tgres superuser<br>sudo -i -u postgres

<br>psql<br>ALTER USER your_username WITH SUPERUSER;</li><li>If you can&#39=
;t log in with sudo but have access to the PostgreSQL data directory, you c=
an start PostgreSQL in single-user mode to reset the password<br>sudo -u po=
stgres postgres --single -D /var/lib/pgsql/data=C2=A0 (Change your path acc=
ordingly)<br>ALTER USER postgres WITH PASSWORD &#39;new_password&#39;;<br>E=
xit single user mode and start postgres normally<br>=C2=A0=C2=A0<br></li></=
ul></div></div></div></div></div><br><div class=3D"gmail_quote"><div dir=3D=
"ltr" class=3D"gmail_attr">On Thu, 19 Sept 2024 at 18:31, Sunil Jadhav &lt;=
<a href=3D"mailto:sunilbjpatil@gmail.com">sunilbjpatil@gmail.com</a>&gt; wr=
ote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px=
 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D=
"auto">Hello Team,<div dir=3D"auto"><br></div><div dir=3D"auto">I have logi=
n with non super user in PostgreSQL instance.</div><div dir=3D"auto">How to=
 become a super user</div><div dir=3D"auto">I tried and getting a below err=
or=C2=A0</div><div dir=3D"auto">=C2=A0&quot;must be=C2=A0 superuser to alte=
r superuser&quot;=C2=A0</div><div dir=3D"auto">=C2=A0How to resolve=C2=A0th=
is?</div><div dir=3D"auto">I don&#39;t know the superuser password?</div><d=
iv dir=3D"auto"><br></div><div dir=3D"auto">Thanks for=C2=A0your help in ad=
vance</div><div dir=3D"auto"><br></div><div dir=3D"auto">Thanks</div><div d=
ir=3D"auto">Sunil jadhav=C2=A0</div></div>
</blockquote></div>

--00000000000014a67106228556c2--