From: "Buzas, Matthew Scott" <buzas1@llnl.gov>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: questions about pgsql & pgadmin4 + fatal no role detected
Thread-Topic: questions about pgsql & pgadmin4 + fatal no role detected
Thread-Index: Adskjp9ng4rVKGNIQySdZwErdpEPLg==
Date: Tue, 22 Oct 2024 14:28:24 +0000
Message-ID: 
 <PH0PR09MB11822B8BA1652D4C57BD1DCC8E64C2@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?J/Q9pJAHigJrCiRRy/APJ3j5txTEGl52o6p1Lc+mkJ3/KocWg7dCMPbJKmhX?=
 =?us-ascii?Q?MN49nD/OGF+GAyxdRIAZm1G03cSJFR61yMO6l9V8OzD1rtWlaV1ysZmdGbiZ?=
 =?us-ascii?Q?tHdINAWWIEBqEjwamK77fwjZC7ODcuGXtdHZNljUCmV4c6fNzRxnf6M+ztC6?=
 =?us-ascii?Q?/BFKMukYamPwpI01iqWbK7OE9uXuMESxabFGVJfHcQby0aNHkkSSX+fGp+DQ?=
 =?us-ascii?Q?U6IlnpBba9UE3WJa+p5EgJ6jOCVUNFQRjQH60CJRwjm1aYyrcDPA5OIZGuJC?=
 =?us-ascii?Q?uuoEb/H7LvnXi55yGMWX5P4jblc7Gx2RFmd9JVbxChb/HXsqATKVOMuiOqFk?=
 =?us-ascii?Q?3wkAqPU2QczjeVOD+v8Dv6kreJ5cHqXb/lI85iE4oQ8zaZnGpcESlCkXFj+7?=
 =?us-ascii?Q?r0h2dTUuHzL2Q5LWDJyZEAU+j4Nz2r5kDBxPvoLOnfFcwFOHUNc3yNqL7Ujx?=
 =?us-ascii?Q?jkMU5RkqFrZDBeP2kasT0tk7ojhJEsADhTeGgjgveBusIIxZJX9i0mSh52oG?=
 =?us-ascii?Q?5y4UTDalWEc+rwcCnCXWWneWKq1MVcNFeCaa2oHCaKzsMjPMTxctPCJqk/Um?=
 =?us-ascii?Q?t+znGBbzYi5nzQ6ov83Yf2ne9CN/GyT1XaCOIdHQsJoiUqEAAgIOBF0BuTWq?=
 =?us-ascii?Q?zcjUZEnCrKUWbhOtuqioRKIvV66hUieMwpEOAlD+ni4dhnoOhIsh2T/DPeHy?=
 =?us-ascii?Q?kKSv8KjteCMzu8zZ0MUDCz22O9IeuIgohhshQzCc6EsMDhZZfieLQWdi42YZ?=
 =?us-ascii?Q?2njd9FtqBynhtnK0G527gsiqkXVCv6qFGcCOEsdJ2eC8wpubAhwOPDZCQtnG?=
 =?us-ascii?Q?lA9lSJJIPHYFMCJFKlYWS3jtxMA0wop9scI7eae0s5ib/Fs2OYYPEKZ7s+3V?=
 =?us-ascii?Q?/GUrObrs2bAIVFVMphAHSG5XA/j/dTcbGQP7kUL7KjlcHQmWmHKV4g41tPDK?=
 =?us-ascii?Q?DG/yjR4FsM8X7wEZwFKJ9hk0AjmiXe5xuvLXvphVupF+bMAHa9C4JKYavKT0?=
 =?us-ascii?Q?HThCVuj8OjVMR3B5fZgKIdcdkmbECkfUfYw6vDifOqCJ/M/9NGYpARJrFUZd?=
 =?us-ascii?Q?S+8359MDN9fjjm8Q50k1Bhe7/NmnRSDO6tTHvF/iG8qSXn3oKc3Is/B70w18?=
 =?us-ascii?Q?OdQt8LZcn2R4p8g+fqcTQvwILoPwN36FNVJQAFwZsrX7aSa0x+NPUJDkzWL7?=
 =?us-ascii?Q?MKqqsn4bteOT7VdxrOoyA0Y4TXYGnXJPC3mxoaSEFLWYeW0l8XyRy7Fr75iP?=
 =?us-ascii?Q?z8o6Y8p7DfbmHLPLlVu/RrUzF2x4uHBJYMrcUoB5030RXResag9qpWR9Klzn?=
 =?us-ascii?Q?L7UEJTVElIqAPaKFI4Hv6PDWNthAzWBFiqMg2Zb06A1oyc5xO4qaEhJW3F6l?=
 =?us-ascii?Q?rUaxL1mWr56HU3Jdx8LspRRtKlLQ3OqDN+kJQAPrJRFrK2ipVMyrLwueU7yZ?=
 =?us-ascii?Q?XzqPyQDe4jeu7iVa1OYr6/IVPBV6jEgxBFxZmANCPV3sRCdAy6mVkG4M8pOI?=
 =?us-ascii?Q?TQiHE578uMWWfn07lgywMhlFpi7dV2vayOTzkUATUVkkmjHsbiqm/K5FzG98?=
 =?us-ascii?Q?1b5hFvj7p3z+2Up92UI=3D?=
Content-Type: multipart/alternative;
	boundary="_000_PH0PR09MB11822B8BA1652D4C57BD1DCC8E64C2PH0PR09MB11822na_"
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: 
	CkX6nG2QlO9lG8raHxHeyRMYbMcyQRRQwn5sMg/EbpziwEFa1JkMBwtwhFPPx1V3ryKAe0TiLXwmWkk+wxSdpEOsT7b9cXVRpuwolbnsJ8y+hFh1YzOXjZlzvaa1BblA57Illwhwe2pxDij4C7O5qfsoIuQSubydQhyZNZb1xAr0ALFDQIKuPx0QZaR7vvfETWHyuqg/ET+ZIZFbCqZXIkrGqlst+fDhWq63pE7LR5qerLKDvQvvjn0nuFE0bFkoYCVUKkx9UmhV22JEXp/fH0xfnqs/X0m7E6kzqiB3d7xXAyUwgbwN2w5J7tLR8qhrGfZd+hkQlXn4pYXuaNepXVTNDBNu1WOuhxMweRX+lfVDT4ksAA6BE6bfowzCTYzTkY26PWOsM682wQi+7rA4doFU/Oti9xapuFXiNXMvFMxLD6l785Fwn9hCt2UdLrl70j8kEuyvqBP/3Ij983P6dwWI9aRRPV3zzSpR22cNW9osXv9K+LapQc9ys6cVS6spICvb1S+zW1EB8rIYujfR0ordKLYhVNtEOjP6ndQe9TRxhTQ81L5wUOfU2AMGHpNJH6YNvOFyPoG2n+vrnluxFwg1lrxtPIAjMWsucDSDHwK6+XmvhErgjf0dEHw+G3iUKd2ZGWm7rntDRv7eqy8nCw==
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: 
 20b7cb2c-10ce-4960-1a29-08dcf2a5c9a2
X-MS-Exchange-CrossTenant-originalarrivaltime: 22 Oct 2024 14:28:24.6109
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: a722dec9-ae4e-4ae3-9d75-fd66e2680a63
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DS0PR09MB11253
X-Proofpoint-GUID: -hvBhCPYC6ZE7milTZtGiKXOG5myiH1K
X-Proofpoint-ORIG-GUID: -hvBhCPYC6ZE7milTZtGiKXOG5myiH1K
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-22_15,2024-10-22_01,2024-09-30_01
X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0
 malwarescore=0 bulkscore=0
 impostorscore=0 mlxlogscore=519 phishscore=0 spamscore=0
 priorityscore=1501 suspectscore=0 mlxscore=0 adultscore=0
 lowpriorityscore=0 clxscore=1031 classifier=spam adjust=0 reason=mlx
 scancount=1 engine=8.12.0-2409260000 definitions=main-2410220092
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/PH0PR09MB11822B8BA1652D4C57BD1DCC8E64C2%40PH0PR09MB11822.namprd09.prod.outlook.com>
Precedence: bulk

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

Able to back up a database, when I open pgadmin4 to verify admin login ther=
e's a message saying it's out of date but when I upgrade to pgsql13 the ser=
vices never start and the upgrade never occurs
I am unable to update WHD because when I do I can't restore my previous dat=
abase
I've created other accounts as a test and I still can't log in to my databa=
se via pgadmin4


Matt

--_000_PH0PR09MB11822B8BA1652D4C57BD1DCC8E64C2PH0PR09MB11822na_
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">Able to back up a database, when I open pgadmin4 to =
verify admin login there&#8217;s a message saying it&#8217;s out of date bu=
t when I upgrade to pgsql13 the services never start and the upgrade never =
occurs<o:p></o:p></p>
<p class=3D"MsoNormal">I am unable to update WHD because when I do I can&#8=
217;t restore my previous database<o:p></o:p></p>
<p class=3D"MsoNormal">I&#8217;ve created other accounts as a test and I st=
ill can&#8217;t log in to my database via pgadmin4<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</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">Matt</span><o:p></o:p></p>
</div>
</body>
</html>

--_000_PH0PR09MB11822B8BA1652D4C57BD1DCC8E64C2PH0PR09MB11822na_--