"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > On Tuesday, April 23, 2024, Arbol One <ArbolOne@xxxxxxxxxx> wrote: >> psql-16 asks for the password, which I have forgotten. >> Is there a way I can retrieve this master password? > Nope. You need to login using a method that doesn’t require a password > then change the password. See pg_hba.conf for authentication options. > Usually connecting via local and peer authentication is the default option. If all else fails, shut the server down and start it in single-user mode. That will let you in as a superuser and you can use ALTER USER to reset the role's password. regards, tom lane
