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 1srHFv-000HM4-HH for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 13:31:36 +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 1srHFt-001BoB-I6 for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 13:31:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1srHFt-001Bo2-7B for pgsql-admin@lists.postgresql.org; Thu, 19 Sep 2024 13:31:34 +0000 Received: from mail-lf1-x135.google.com ([2a00:1450:4864:20::135]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1srHFs-0000uQ-6e for pgsql-admin@postgresql.org; Thu, 19 Sep 2024 13:31:33 +0000 Received: by mail-lf1-x135.google.com with SMTP id 2adb3069b0e04-5365a9574b6so1381595e87.1 for ; Thu, 19 Sep 2024 06:31:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726752690; x=1727357490; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=LmnU8hlPnwcjaolZUDhuKT5cZ3oFmqE7CDK11wPr/hk=; b=ON+mf3xaY23XTxIzaxpVnaVSiOUvZS+9fLBqPTV4LeFAxgcPVkre1sh8/MjfMwXrdF 48ZxKuOJZoq/aOhNw0XKHD2xX5r5V0gnG0+RRcls8DZolhcvIyHAGNxCVsgruUAh3T20 gtqXRi0XElAIYgK+d7NIRn7+BRlHqg1I9F2a8xGgkgErPkXXKQn+F+LLhAPB7Qm9DFss 0EVGvJ4+2ptDfSDe+VoSbEy/Fsi0EqxgUBBptn9/Fk6nkNVXgepuBclWyAo61uLGshVp x+eOqCC6dPJQGu+QhT1k+45xc1vuiR/ngB64+nFqwvoDh6brONArQ2EbuZxhffderlX/ 7/IA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726752690; x=1727357490; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=LmnU8hlPnwcjaolZUDhuKT5cZ3oFmqE7CDK11wPr/hk=; b=nQNUA2S6fT2nzfxkgdkBEChac7YHa5G01IqVpb4I6E3AJ8n3oJtr7cE0PIsBMgVZe7 P/5aD4Fj9abEQF8ZaCLvHowJk2/crDWtOr6H6QArRHZEvqm+bN8C1mXLPfqlhtoIhGAp QpwS2cBIAu2K13JIcnUp3EPm8yHj+SdMUPyw+W4MDOEgMIxiepCxrl0UnTuahax0Mgp9 5J6hVUGwHLcQcIqVTXqSOb3/e/b3yqK09mCafcnbmQmP5X4SmMxmlT6Zz9OjmX63Gqms GOhIsSxUEXgT5CTqosKGNcGF/Akf5kqXgL8AiQvG88saDaNtEwWdzrE+UxsrObZEUPKR rNPQ== X-Gm-Message-State: AOJu0Yy09pxzCSS6tmL0MIm7mqFdSa5Lxb8aVNANk0S5gh+zKuUxSS4W GqDBU62Z+LMx8wDFa26gKGGTFxfaTQa+9cbiUqOuRwl5isHz1oPjbixkWmSdLySfpjnAHz19F71 dsHfpCMeyVnrfCO76obIB3hc7E0K0hA== X-Google-Smtp-Source: AGHT+IGzNxBD6KMm5tADglkMuZiuLG/ORbzEUniCbBvdsKMsUlIZ7IBpv/WyDoi7msV4D2Jx4Gk7msINC04m5zzA0C0= X-Received: by 2002:a05:6512:ad5:b0:536:54bd:8374 with SMTP id 2adb3069b0e04-5367ff399dfmr15183653e87.60.1726752689926; Thu, 19 Sep 2024 06:31:29 -0700 (PDT) MIME-Version: 1.0 From: Sunil Jadhav Date: Thu, 19 Sep 2024 19:01:15 +0530 Message-ID: Subject: How to make superuser from non superuser in PostgreSQL To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary="000000000000b2bd27062278f067" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b2bd27062278f067 Content-Type: text/plain; charset="UTF-8" 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 --000000000000b2bd27062278f067 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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=C2=A0
=C2=A0"must be=C2=A0 superu= ser to alter superuser"=C2=A0
=C2=A0How to reso= lve=C2=A0this?
I don't know the superuser passwo= rd?

Thanks for=C2=A0your= help in advance

Thanks<= /div>
Sunil jadhav=C2=A0
--000000000000b2bd27062278f067--