Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id A0F58635074 for ; Fri, 27 Mar 2009 19:45:11 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 04922-02-5 for ; Fri, 27 Mar 2009 19:45:01 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n76.bullet.mail.sp1.yahoo.com (n76.bullet.mail.sp1.yahoo.com [98.136.44.48]) by mail.postgresql.org (Postfix) with SMTP id E1556633D4E for ; Fri, 27 Mar 2009 19:44:56 -0300 (ADT) Received: from [216.252.122.217] by n76.bullet.mail.sp1.yahoo.com with NNFMP; 27 Mar 2009 22:44:53 -0000 Received: from [69.147.65.163] by t2.bullet.sp1.yahoo.com with NNFMP; 27 Mar 2009 22:44:53 -0000 Received: from [127.0.0.1] by omp408.mail.sp1.yahoo.com with NNFMP; 27 Mar 2009 22:44:53 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 418640.47430.bm@omp408.mail.sp1.yahoo.com Received: (qmail 48985 invoked by uid 60001); 27 Mar 2009 22:44:53 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1238193893; bh=/ivQBqb5gPZvwI5GGzanROm93KCnNkm5VC/0pSqh3+E=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=RspasXluKPuaanrannG6R1+RPGrGzmATJQvxlyachQVK7x1W+D55MPtA1LLzuFcc61xIVX5CcYKibLexVMonvZ93EeELEjKgDjSRAIutW1B9MDYsH34yHpB2d1Pc2zAZt9WtaKjjS79LsV/Gj6Y2f5ToU4GxpX4GEbBntAxReiQ= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=3jeuJDnJRwWcDBhDdOaz2eAw/uNZXAD7fI38bUdvukxHpIY0px1bwkrt8t5toAN9HEVR6T3nEb4ZUgOQ78hxEsjlxNnL0b49n2urmjj/iSiVExaearveWpV/vW0Ka07XvhdJ/FauLPYli94aL0lDEXK+o1o2l1F4DBrJI17OQZM=; Message-ID: <218848.40985.qm@web43403.mail.sp1.yahoo.com> X-YMail-OSG: 7Hl5bGsVM1nqLnOdoCJ9Uiw80oROF.e4c2ajrWWnvX2o43JtGssTjLAwrgE1FqUy5ZXDzaEGApmjv2x5JNm33xfVlK5sst5N4yPb6vex4qw60N0p0oozJUEisG76tqhaiCvc28NCv5OW1bolvvlEpg4XZPaI1BNpgP6ryAW_me4plwohSWknz5DhGIymKjIhTG3LlCQid8gvQHy9oeA- Received: from [216.254.18.193] by web43403.mail.sp1.yahoo.com via HTTP; Fri, 27 Mar 2009 15:44:53 PDT X-Mailer: YahooMailRC/1277.32 YahooMailWebService/0.7.289.1 Date: Fri, 27 Mar 2009 15:44:53 -0700 (PDT) From: Newbie Poster Subject: Logging in with postgres remotely To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1233996833-1238193893=:40985" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200903/241 X-Sequence-Number: 31741 --0-1233996833-1238193893=:40985 Content-Type: text/plain; charset=us-ascii I am trying to connect to a postgres database ona remote server using pgAdmin III, and the user postgres. According to some instructions I found in the mailing list archives, I reset the password of the postgres user, which is required before one can use that username to connect to a remote database. I am still getting the same error, however, which is: Error connecting to the server: FATAL: password authentication failed for user "postgres" Any pointers? Thanks! --0-1233996833-1238193893=:40985 Content-Type: text/html; charset=us-ascii
I am trying to connect to a postgres database ona remote server using pgAdmin III, and the user postgres.  According to some instructions I found in the mailing list archives, I reset the password of the postgres user, which is required before one can use that username to connect to a remote database. I am still getting the same error, however, which is:

 Error connecting to the server: FATAL:  password authentication failed for user "postgres"

Any pointers?  Thanks!

--0-1233996833-1238193893=:40985--