Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id CE85A9FB3AF for ; Tue, 31 Oct 2006 14:09:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 89574-01-6 for ; Tue, 31 Oct 2006 18:09:19 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id E04459FB278 for ; Tue, 31 Oct 2006 14:09:17 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id 30so1328156ugc for ; Tue, 31 Oct 2006 10:09:16 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=G5pVcQ+7m9PS3mD950v1Pe/w409wGwKcR2CntNvemtLEhGu00zfnZ99NEjKHBJaKTmxLmA3eLhMBeIh4X48/aUXtLhlkUzuAYYJpOikCkJOU3EXoHe9IyxiHyTtUilpp2bKO/XBW1+DRQsoas0RgaMJw3AkgGQWAMAyLH4IiA6k= Received: by 10.82.131.1 with SMTP id e1mr1222532bud; Tue, 31 Oct 2006 10:09:16 -0800 (PST) Received: by 10.82.155.9 with HTTP; Tue, 31 Oct 2006 10:09:16 -0800 (PST) Message-ID: <223020e60610311009x5fab442cg8c3284e98e1733e4@mail.gmail.com> Date: Tue, 31 Oct 2006 18:09:16 +0000 From: "Nick Black" To: pgsql-admin@postgresql.org Subject: Cannot connect using psql MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/223 X-Sequence-Number: 23526 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