From: | "Andy Shellam" <andy(dot)shellam(at)mailnetwork(dot)co(dot)uk> |
---|---|
To: | <andrea(dot)gozzi(at)linuxrevolution(dot)eu>, <pgsql-admin(at)postgresql(dot)org> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: password authentication failed (postgresql v8.1.4) |
Date: | 2006-06-17 11:56:33 |
Message-ID: | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAAC4AAAAAAAAAt+qV6pqKPEmXG74TlFgX5gEAlpDSN+DrMEWnumhoRHpQKQAAAbLc9wAAEAAAAMUMakySmKJDsUqfk3WyI2gBAAAAAA==@mailnetwork.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
http://www.postgresql.org/docs/8.1/static/role-membership.html
According to the above manual page, the command is like:
CREATE ROLE joe LOGIN INHERIT;
(presumably with your WITH PASSWORD and other grants tacked on.)
> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-
> owner(at)postgresql(dot)org] On Behalf Of Andrea Gozzi
> Sent: 17 June 2006 12:41 pm
> To: pgsql-admin(at)postgresql(dot)org
> Subject: [ADMIN] password authentication failed (postgresql v8.1.4)
>
> Hi.
> I have been upgrading my PG server from version 7.4 (debian sarge
> binary) to v8.1.4 (source installation).
> The installation procedure went fine but I can't log into the database
> with another role/user than 'postgres'.
> This is my pg_hba.conf, that I was succesfully using with v7.4:
>
>
> # Database administrative login by UNIX sockets
> local all postgres ident sameuser
>
> # All other connections by UNIX sockets
> local all all ident md5
>
> # All IPv4 connections from localhost
> host all admin 0.0.0.0 0.0.0.0 md5
> host all bdati 0.0.0.0 0.0.0.0 md5
>
>
> The remote pgAdmin3 obviously doesn't work and neither does the psql
> command if I try to login with 'admin' or 'bdati'.
> Users have been created with
>
> CREATE ROLE admin WITH PASSWORD 'xxx' SUPERUSER;
> CREATE ROLE bdati WITH PASSWORD 'xxx' CREATEDB;
>
> It's probably one of the dumbest questions but I really can't sort it
> out.
>
> Thanks
>
> Andrea
>
>
> --
> Andrea Gozzi <andrea(dot)gozzi(at)linuxrevolution(dot)eu>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrea Gozzi | 2006-06-17 12:30:20 | Re: password authentication failed (postgresql v8.1.4) |
Previous Message | Andy Shellam | 2006-06-17 11:54:31 | Re: password authentication failed (postgresql v8.1.4) |