Re: password authentication failed (postgresql v8.1.4)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx [mailto:pgsql-admin-
> owner@xxxxxxxxxxxxxx] On Behalf Of Andrea Gozzi
> Sent: 17 June 2006 12:41 pm
> To: pgsql-admin@xxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxxxx>



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux