From: "Buzas, Matthew Scott" <buzas1@llnl.gov>
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: support with pgadmin4/upgrades
Thread-Topic: support with pgadmin4/upgrades
Thread-Index: Adsgpux651wRHr1cQvCld/V7VN0iow==
Date: Thu, 17 Oct 2024 15:14:10 +0000
Message-ID: 
 <PH0PR09MB1182221EB58AF3751BEB568B4E6472@PH0PR09MB11822.namprd09.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?cxyXa5oic0JLgT/hU3N0ufC6tQ3hYaJqunJ+6VaaMN3UW0aPuVH3o0vrn8fH?=
 =?us-ascii?Q?jPtKJYKB8f4ZtTABOfllv09JqcNhc9ItUQKpxbQc/ywIKqJgs7rji2ULD0KI?=
 =?us-ascii?Q?hO5wDjPOahDf1Ifx4InT+5Y/45AmGKPHOojwf9VOAU8ABvNUfc4RuvSOE+sF?=
 =?us-ascii?Q?CHajXLbQa35qLb3xmzcFitLdJNEX20JN4n4VK4S+B40+XKVp+FMfXe/H44Ss?=
 =?us-ascii?Q?x35fpMQ8QbKtTnrhquE7XoC3VaY6awO3bfCmZt7xr5QkS7TbPjHOghSYLb8h?=
 =?us-ascii?Q?Q8uQqQh+xZJZJd5CiqGP0zfZ7SQgP7+aH9+zVtYIQkm6ikfBJkB/o1dvxD3G?=
 =?us-ascii?Q?CVrlhK7opD0ixjjoPJtJsmIYyu/fn9/nU0m7waVJOFwhF3ZnKn7n/0AHVOBM?=
 =?us-ascii?Q?l08DFLduez01GOWHBKs412Yt21U70Ad2V3LgK3XpWz4B1n2IC9l6we9b3tQ2?=
 =?us-ascii?Q?C2Yxsll0HZyiJvM1mrSeFKs1SYpSHlYE9L4NQdoH/UafTUqwDusrbKzRvjVK?=
 =?us-ascii?Q?genwSHO/VAiz/hRWyUTgi1kLogqe9W6ubapAMNFt1g2xnop8BXcMofpPyDfQ?=
 =?us-ascii?Q?TT62C2dUPI7QUj+oo3wV1CuSmvyKRSb7ly1GCdVBFTfPybCN3bNqECy67mkC?=
 =?us-ascii?Q?4LcBRQg0i4ANBh6qgd9cZyAUIPDU9IqQeuS91pXEWlr8jHAWiCbugyP0e2rq?=
 =?us-ascii?Q?fxJrYtA/4VUXUHC57D1kU11HMZmrFszjEqKNCYJgxPelvydCUe7oYWQRakps?=
 =?us-ascii?Q?yeFH2patxG0ZcLSsKZrKZytWB0OQWPG4TxboDOLgQP+2Rm71pX5mDqStOQKY?=
 =?us-ascii?Q?nxJTb2JCb66JvHTIwtfwHffIEXY8nhOv9KvFdfB6tiuX8bzoUrLvet2CRWP8?=
 =?us-ascii?Q?0T1+q9WXmnam7WY8uAA6hYoHYbdWGGTeTz2jq9GJ8LyICtVdhsSQA99XLFej?=
 =?us-ascii?Q?dVbeIXVpCqjRr60W2tg19AVJCr40ty7KmwR4k0Zs5Ht/uuFi6j1CJV4reUt3?=
 =?us-ascii?Q?pYsKfnC93YD/Qgn+OK8cCVi0W35ehSqDZFnvMtIpVA1xYRPnTxNNbHoZSL5y?=
 =?us-ascii?Q?PydjtOprNEUAx2OjMl7MRdtxUiB8ygT/1zSX6S9oZ7bXF4wFSwbvlTTCwLLx?=
 =?us-ascii?Q?ZsG/iElilBYGu2jeU5pQ+e2Z4M7sKTFsnOpOtW6sdG2l5yrQ1JqlW8ACKIeb?=
 =?us-ascii?Q?xupsQMgFRVHdTS/y/cCVt0filFNBtI390RFo6dfasncEEMFxMTQ+SM7z8YyU?=
 =?us-ascii?Q?xlv+WOAsYm3j5GAY4wMByGB9niYhJmfP3tr/q3DPdEAhjtY49BbLYyJI5Wmp?=
 =?us-ascii?Q?t7E8vIYec/APjcZ7TkNaZvpF/YptgU1yKgsKNlrQPA31+FeaePYlOklaJNDw?=
 =?us-ascii?Q?P4bRmrplBXRRCoKw2ax5pOQuRzQC3dR0yupL9+4x79HAxp8C7LzZxgv1+oTk?=
 =?us-ascii?Q?HoABPUN4xkZzKI8Zp9FIEFcyH76E2FkX7odamstZekJ+lXODkod9yD7AEGlL?=
 =?us-ascii?Q?y6KE6A6u4DPyD/Uko7mrv0VF2WsixaCJu7IZy1MSYK1x3xFQhH4IrnciPSOA?=
 =?us-ascii?Q?gBFZjQNQeTJp+OmNhvU=3D?=
Content-Type: multipart/alternative;
	boundary="_000_PH0PR09MB1182221EB58AF3751BEB568B4E6472PH0PR09MB11822na_"
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: 
	bbj+uAaOUIcMytLo/yd+sTOWP1AnNW+ANLIaulVjfclMPd0kCG0F+Lzy00hV+G3VHzA1HYLMoIBbNfsgqyPPbt6cWpDVJiasBzTGL4Ebz6zgB5yzYM4z70Pvb+9JzF7QJXMvSgJhw1K4lD56d+tV0JVswV4N8qZRHynRBMBuA0SxXC69XGDAlbgY/45GOirJmjtV2MYCVkOqAOLmMtPw2nDu86lCp8ZhweOm6KMLWjairD8tWfkKGVzi6MPAm3FFWZ6FveQnF03/a2g6B0H+yAFaAiLS/HVGd4e06Kh2MSOTN6WXQatKlxFj1qmcXEsNVnFgjDb3SDmMau0fHNitDPxZ1gwYIommhYv30ebExO7vbAKtAvNQZ3gW92DKihH8VHIsbuC3ZNV0C11ATcogdice51msA8i8ar2CJhmdWYigxGCQb7NSgc44YKmJZqXH9gFZoQSAcZL8K4Sa/F3MUvWSIFOebtjmA53o1PW6P19aqQcOdGorhlYRvRprVALyrl2ggFCNtkSGDva+8TMyZl4CwIu71FIQXQSuw60P2A4r254nle8LgNIzsNuqNO67Fd2m0NYPkH3ToEagtXms9JTV2v184lQmziQNt2Fx7zUGZJq83P2/C5rAzdVg5BecEGotVcwzbwMN8f5TyMLZIw==
X-OriginatorOrg: llnl.gov
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: PH0PR09MB11822.namprd09.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 2781d1c4-e737-469c-71a0-08dceebe5a4a
X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Oct 2024 15:14:10.5321
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: a722dec9-ae4e-4ae3-9d75-fd66e2680a63
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DS0PR09MB11233
X-Proofpoint-ORIG-GUID: e7lX5gMAZEtQTycVOfgyQcTe0scoUMCo
X-Proofpoint-GUID: e7lX5gMAZEtQTycVOfgyQcTe0scoUMCo
X-Proofpoint-Virus-Version: vendor=baseguard
 engine=ICAP:2.0.293,Aquarius:18.0.1051,Hydra:6.0.680,FMLib:17.12.62.30
 definitions=2024-10-17_16,2024-10-17_01,2024-09-30_01
X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0
 phishscore=0 spamscore=0
 mlxlogscore=828 priorityscore=1501 bulkscore=0 adultscore=0
 lowpriorityscore=0 impostorscore=0 mlxscore=0 clxscore=1011 suspectscore=0
 malwarescore=0 classifier=spam adjust=0 reason=mlx scancount=1
 engine=8.12.0-2409260000 definitions=main-2410170105
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/PH0PR09MB1182221EB58AF3751BEB568B4E6472%40PH0PR09MB11822.namprd09.prod.outlook.com>
Precedence: bulk

--_000_PH0PR09MB1182221EB58AF3751BEB568B4E6472PH0PR09MB11822na_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hopefully I am doing this right

I am working with SolarWinds for WHD upgrade and we use PGAdminIV to manage=
 the database
Prior to upgrading WHD, we backup the database and make sure we have the pr=
oper usernames/passwords for pgadminIV for the next upgrade
However, when we upgrade, and start pgadminIV to reload the database, it sa=
ys role not found when using the username/password designated for it

This is for Windows for WHD 12.7.7 upgrading forward. I am working with sol=
arwinds but we feel like this is an issue with the database itself that's c=
ausing us not to login again after upgrading
I've made sure our normal users and admin account for PGSQL exist and they =
have the right permissions etc.

Matthew Buzas
Windows IT Desktop Support
925-423-4985
07-1630 PST M-TH
07-1530 Alternate Fridays


--_000_PH0PR09MB1182221EB58AF3751BEB568B4E6472PH0PR09MB11822na_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Aptos;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Aptos",sans-serif;
	mso-ligatures:standardcontextual;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Aptos",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:11.0pt;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hopefully I am doing this right<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I am working with SolarWinds for WHD upgrade and we =
use PGAdminIV to manage the database<o:p></o:p></p>
<p class=3D"MsoNormal">Prior to upgrading WHD, we backup the database and m=
ake sure we have the proper usernames/passwords for pgadminIV for the next =
upgrade<o:p></o:p></p>
<p class=3D"MsoNormal">However, when we upgrade, and start pgadminIV to rel=
oad the database, it says role not found when using the username/password d=
esignated for it<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">This is for Windows for WHD 12.7.7 upgrading forward=
. I am working with solarwinds but we feel like this is an issue with the d=
atabase itself that&#8217;s causing us not to login again after upgrading<o=
:p></o:p></p>
<p class=3D"MsoNormal">I&#8217;ve made sure our normal users and admin acco=
unt for PGSQL exist and they have the right permissions etc.
<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt;font-family:&quot;Ti=
mes New Roman&quot;,serif">Matthew Buzas<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt;font-family:&quot;Ti=
mes New Roman&quot;,serif">Windows IT Desktop Support<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt;font-family:&quot;Ti=
mes New Roman&quot;,serif">925-423-4985<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt;font-family:&quot;Ti=
mes New Roman&quot;,serif">07-1630 PST M-TH
<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt;font-family:&quot;Ti=
mes New Roman&quot;,serif">07-1530 Alternate Fridays<o:p></o:p></span></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
</body>
</html>

--_000_PH0PR09MB1182221EB58AF3751BEB568B4E6472PH0PR09MB11822na_--