Default Postgres Password

[Daniel J. Luke]

On Nov 25, 2012, at 5:12 PM, Stephen Rasku <macports at srasku.net> wrote:
> 
> I did "sudo psql90" and it still asked me for a password:
> 
> $ sudo psql90
> Password: 
> psql90: FATAL:  password authentication failed for user "root"
> $ sudo psql90 -U postgres
> Password for user postgres: 
> psql90: FATAL:  password authentication failed for user "postgres"

... probably because you told it to (hint: check your pg_hba.conf file). You can also set up a ~/.pgpass file if you want to be able to psql (as any postgres user) without typing the password. I believe the default pg_hba.conf file is set up to allow access without any password.

--
Daniel J. Luke                                                                   
+========================================================+                        
| *---------------- dluke at geeklair.net ----------------* |                          
| *-------------- http://www.geeklair.net -------------* |                          
+========================================================+                        
|   Opinions expressed are mine and do not necessarily   |                          
|          reflect the opinions of my employer.          |                          
+========================================================+