Mark Sargent <coolboarderguy@xxxxxxxxx> writes: > [racket@ibmlap ~]$ psql template1 > psql: FATAL: role "racket" does not exist > Which confuses me, as local all all trust should allow me to connect, > no? No, it allows you to claim that you are any database user you want to claim you are. The default assumption is that you want to be the database user with the same name as your OS username. The problem here is that there is no such user. Most likely the only pre-existing database user will be named "postgres", so try psql -U postgres template1 If that lets you in, execute the SQL command "CREATE USER racket;" and then you should be able to connect as "yourself". (Note: you might prefer to make yourself a superuser, see the manual.) regards, tom lane
