Argh, I had "phpbb" in my env ( ~/.login) too: setenv PGDATA /var/postgresql/data setenv PGDATABASE phpbb setenv PGHOST /var/www/tmp setenv PGUSER phpbb Now everything makes sense (I was thinking about some kind of system table for default databases). Sorry and thank you for your help Regards Alex On 1/30/06, Doug McNaught <doug@xxxxxxxxxxxx> wrote: > I was talking about the name of the database, not the user name in the > database. The former defaults to the same as your Unix username > (e.g. if I log in as 'doug' psql will try to connect me to a database > called 'doug' if I don't supply a database name). The PGDATABASE > environment variable overrides this. Are you sure it's not set? > > Anyway, you should always supply the database name explicitly when you > connect--it's a lot safer.
