Re: PostgreSQL 8.0 bug or my own stupidity?
On Mon, Jul 11, 2005 at 05:56:43PM +0200, Tom wrote:
> Quite some lines like
>
> FATAL: user "tom" does not exist
> FATAL: database "cds" does not exist
> FATAL: user "root" does not exist
> FATAL: user "root" does not exist
> FATAL: user "tom" does not exist
> FATAL: Ident authentication failed for user "postgres"
etc.
You can save yourself some trouble screwing around w/ the 'postgres'
user account by creating an ident map which relates the shell account
you normally use with the postgres user.
Edit pg_ident.conf to look something like:
mymap yourusername postgres
mymap postgres postgres
mymap root postgres
Then edit pg_hba.conf to look something like:
local all all ident mymap
This says that when connecting to any local database as any user, do
ident authentication, and refer to the 'mymap' entries in pg_ident.conf
for doing the lookups. So now, logged in as yourusername or root, for
example, you can do:
psql -U postgres -d template1
--
Ron Peterson
Network & Systems Manager
Mount Holyoke College
http://www.mtholyoke.edu/~rpeterso
Reply to: