pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpassword authentication failed (postgresql v8.1.4)
5+ messages / 3 participants
[nested] [flat]
* password authentication failed (postgresql v8.1.4)
@ 2006-06-17 11:41 Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>
0 siblings, 3 replies; 5+ messages in thread
From: Andrea Gozzi @ 2006-06-17 11:41 UTC (permalink / raw)
To: pgsql-admin
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.gozzi@linuxrevolution.eu>
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: password authentication failed (postgresql v8.1.4)
@ 2006-06-17 11:54 Andy Shellam <andy.shellam@mailnetwork.co.uk>
parent: Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>
2 siblings, 0 replies; 5+ messages in thread
From: Andy Shellam @ 2006-06-17 11:54 UTC (permalink / raw)
To: andrea.gozzi@linuxrevolution.eu; +Cc: pgsql-admin
Isn't there a specific LOGIN privilege now in 8.1? In my PostgreSQL
Manager, there's a "can login?" box which if cleared, creates a role, but
doesn't allow them to login.
Have you tried using the "createuser" wrapper program to do this for you?
Andy
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-
> owner@postgresql.org] On Behalf Of Andrea Gozzi
> Sent: 17 June 2006 12:41 pm
> To: pgsql-admin@postgresql.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.gozzi@linuxrevolution.eu>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: password authentication failed (postgresql v8.1.4)
@ 2006-06-17 11:56 Andy Shellam <andy.shellam@mailnetwork.co.uk>
parent: Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>
2 siblings, 1 reply; 5+ messages in thread
From: Andy Shellam @ 2006-06-17 11:56 UTC (permalink / raw)
To: andrea.gozzi@linuxrevolution.eu; pgsql-admin; +Cc: 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@postgresql.org [mailto:pgsql-admin-
> owner@postgresql.org] On Behalf Of Andrea Gozzi
> Sent: 17 June 2006 12:41 pm
> To: pgsql-admin@postgresql.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.gozzi@linuxrevolution.eu>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: password authentication failed (postgresql v8.1.4)
@ 2006-06-17 12:30 Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>
parent: Andy Shellam <andy.shellam@mailnetwork.co.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Andrea Gozzi @ 2006-06-17 12:30 UTC (permalink / raw)
To: andy.shellam@mailnetwork.co.uk; +Cc: pgsql-admin
That was it, now everything's working!
Thanks a lot, it seems like I forgot to read that manual page..
Andrea
On Sat, 2006-06-17 at 12:56 +0100, Andy Shellam wrote:
> 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@postgresql.org [mailto:pgsql-admin-
> > owner@postgresql.org] On Behalf Of Andrea Gozzi
> > Sent: 17 June 2006 12:41 pm
> > To: pgsql-admin@postgresql.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.gozzi@linuxrevolution.eu>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: password authentication failed (postgresql v8.1.4)
@ 2006-06-17 14:20 David <dbree@duo-county.com>
parent: Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>
2 siblings, 0 replies; 5+ messages in thread
From: David @ 2006-06-17 14:20 UTC (permalink / raw)
To: Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>; +Cc: pgsql-admin
On Sat, Jun 17, 2006 at 01:41:13PM +0200, Andrea Gozzi wrote:
> Hi.
> I have been upgrading my PG server from version 7.4 (debian sarge
> binary) to v8.1.4 (source installation).
I see in subsequent messages that you got your particular problem worked
out, but if you prefer to stick with Debian binaries, Martin Pitt, the
maintainer of the Postgresql packages maintains backports to sarge.
I've been running them for several months and they seem to work quite
well, aside from the occasional snags you hit when running unstable.
The sources.list entry I use for this is
deb http://people.debian.org/~mpitt/packages/sarge-backports/ /
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2006-06-17 14:20 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-17 11:41 password authentication failed (postgresql v8.1.4) Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>
2006-06-17 11:54 ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-06-17 11:56 ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-06-17 12:30 ` Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>
2006-06-17 14:20 ` David <dbree@duo-county.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox