From: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to change the default database for a user |
Date: | 2006-01-30 18:53:49 |
Message-ID: | 943abd910601301053t2d47d44ajd70138335946f6e1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)mcnaught(dot)org> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2006-01-30 19:04:43 | Re: Alternative to knoda, kexi and rekall? |
Previous Message | Doug McNaught | 2006-01-30 18:40:33 | Re: How to change the default database for a user |