Thread

1. a really dumb password question

   Martin Mueller <martinmueller@northwestern.edu> — 2023-06-22T15:05:52Z

   I have a very stupid password question. I don’t know whether a postgres database on my Mac has a pass word or not.
   
   I access the database via the Aqua Data Studio frontend as the user postgres. I don’t think I ever added a password, and on the authentication panel the password box is empty but the Remember Password box is checked.
   
   However on the user panel there is a sequence of black dots for the Password and Password confirmation. This suggests that I did set a password, but I don’t remember what it is.
   
   How can I undo the damage? Is there some super user way in which I can undo the current password and set a new one. The database itself has several hundred tables, and I need to find a way to fix my stupid error.
   
   I have a dump of the database.  I don’t know whether that is subject to the password or not. If it isn’t, I suppose I could start over from scratch.
   
   I’ll be grateful for advice.
   
   Martin Muelleer
   Professor emeritus of English and Classics
   Northwestern Univerrsity
   
   
   

2. Re: a really dumb password question

   Adrian Klaver <adrian.klaver@aklaver.com> — 2023-06-22T16:02:07Z

   On 6/22/23 08:05, Martin Mueller wrote:
   > I have a very stupid password question. I don’t know whether a postgres 
   > database on my Mac has a pass word or not.
   > 
   > I access the database via the Aqua Data Studio frontend as the user 
   > postgres. I don’t think I ever added a password, and on the 
   > authentication panel the password box is empty but the Remember Password 
   > box is checked.
   
   How are you connecting?:
   
   1) No hostname
   
   2) With hostname
   
   > 
   > However on the user panel there is a sequence of black dots for the 
   > Password and Password confirmation. This suggests that I did set a 
   > password, but I don’t remember what it is.
   > 
   > How can I undo the damage? Is there some super user way in which I can 
   > undo the current password and set a new one. The database itself has 
   > several hundred tables, and I need to find a way to fix my stupid error.
   
   Have you used the Postgres command line client 
   psql(https://www.postgresql.org/docs/current/app-psql.html)?
   
   In meantime find the pg_hba.conf file for the server and post the 
   contents starting at the line:
   
   # TYPE  DATABASE        USER            ADDRESS                 METHOD
   
   here. Do this only if you are alright with sharing that information.
   
   > 
   > I have a dump of the database.  I don’t know whether that is subject to 
   > the password or not. If it isn’t, I suppose I could start over from scratch.
   
   No you don't need to start over.
   
   > 
   > I’ll be grateful for advice.
   > 
   > Martin Muelleer
   > 
   > Professor emeritus of English and Classics
   > 
   > Northwestern Univerrsity
   > 
   
   -- 
   Adrian Klaver
   adrian.klaver@aklaver.com
   
   
   
   
   

3. Re: a really dumb password question

   Ron <ronljohnsonjr@gmail.com> — 2023-06-22T16:04:57Z

   On 6/22/23 10:05, Martin Mueller wrote:
   >
   > I have a very stupid password question. I don’t know whether a postgres 
   > database on my Mac has a pass word or not.
   >
   > I access the database via the Aqua Data Studio frontend as the user 
   > postgres. I don’t think I ever added a password, and on the authentication 
   > panel the password box is empty but the Remember Password box is checked.
   >
   > However on the user panel there is a sequence of black dots for the 
   > Password and Password confirmation. This suggests that I did set a 
   > password, but I don’t remember what it is.
   >
   > How can I undo the damage? Is there some super user way in which I can 
   > undo the current password and set a new one. The database itself has 
   > several hundred tables, and I need to find a way to fix my stupid error.
   >
   > I have a dump of the database.  I don’t know whether that is subject to 
   > the password or not. If it isn’t, I suppose I could start over from scratch.
   >
   
   If the database is on your Mac, then edit the pg_hba.conf file, and restart.
   
   local   all             postgres trust
   
   That should give user "postgres" access with or without a password.
   
   -- 
   Born in Arizona, moved to Babylonia.