Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4712B9FB3DD for ; Tue, 31 Oct 2006 14:52:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 59284-09 for ; Tue, 31 Oct 2006 14:52:40 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by postgresql.org (Postfix) with ESMTP id 8F7DD9FB3C9 for ; Tue, 31 Oct 2006 14:52:39 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id 30so1339247ugc for ; Tue, 31 Oct 2006 10:52:38 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=PLxAnTd36ZOzbwlCVNuyPECSoN1OG4evxujcP+a2dSaudXU8K4XUe9cw7AbTMHuUtUlY4Ozf32LdYn7NucEbkue6bOQotXrN63J7ZGfSQvwJ9GKD0bvwdC5oZe4Gb1EIbjGM+/bxUoBCcC9W29CC8n+/gLMQ6N0ldt8RK+uP9x8= Received: by 10.82.105.13 with SMTP id d13mr1242104buc; Tue, 31 Oct 2006 10:52:37 -0800 (PST) Received: by 10.82.155.9 with HTTP; Tue, 31 Oct 2006 10:52:37 -0800 (PST) Message-ID: <223020e60610311052r5c517220l338e617e26ded4ad@mail.gmail.com> Date: Tue, 31 Oct 2006 18:52:37 +0000 From: "Nick Black" To: pgsql-admin@postgresql.org Subject: Re: Cannot connect using psql In-Reply-To: <223020e60610311009x5fab442cg8c3284e98e1733e4@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <223020e60610311009x5fab442cg8c3284e98e1733e4@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/224 X-Sequence-Number: 23527 Problem solved. I had config files in /etc/ and in /usr/ . :) On 10/31/06, Nick Black wrote: > Hello, > > I am having difficuilties connected to the postgres server. I asked > on IRC, but everyone was stumped, so here we go. > > My pg_hba.conf file: > > # TYPE DATABASE USER CIDR-ADDRESS METHOD > > # "local" is for Unix domain socket connections only > local all all trust > > # IPv4 local connections: > host all all 127.0.0.1/32 trust > > # IPv6 local connections: > host all all ::1/128 trust > host all all 10.0.0.0/16 trust > > I have postgres users called postgres, nick and osm and unix users > called nick and postgres. I created users nick and osm using the > createuser script. > > I can connect to postgres and nick without any problems, but if I try > to connect to osm, the following happens: > > nick@pmdev $ psql -U osm -W -d template1 > Password for user osm: > psql: FATAL: Ident authentication failed for user "osm" > > > But ident is not included in the config file, which made me think that > the file wasnt being read. So ammended the entry for local to > > local all all password > > restarted, and was prompted for a password. > > I am really confused as to the issue. I thought that postgres treated > unix users and postgres users seperately. It seems strange that I can > connect using user nick (the name of a unix user and a postgres user). > > Thanks in advance, > > Nick >