Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WAzo8-0006qG-Hk for pgsql-admin@arkaria.postgresql.org; Wed, 05 Feb 2014 10:34:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WAzo8-0007ut-1u for pgsql-admin@arkaria.postgresql.org; Wed, 05 Feb 2014 10:34:16 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WAzo5-0007uk-SI for pgsql-admin@postgresql.org; Wed, 05 Feb 2014 10:34:14 +0000 Received: from smtp-out-2.mgm.tiscali.com ([213.205.37.14] helo=imp.mgm.tiscali.it) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WAzo1-0006iv-LC for pgsql-admin@postgresql.org; Wed, 05 Feb 2014 10:34:13 +0000 Received: from [192.168.1.8] ([93.61.33.196]) by smtp-out-2.mgm.tiscali.com with id Naa61n0024DtrJt01aa7zo; Wed, 05 Feb 2014 11:34:08 +0100 x-auth-user: sharon@erabyte.it Message-ID: <52F213A0.6090803@erabyte.it> Date: Wed, 05 Feb 2014 11:34:08 +0100 From: sharon User-Agent: Mozilla/5.0 (Windows NT 6.0; rv:24.0) Gecko/20100101 Thunderbird/24.2.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Fwd: Re: Admin user issue: unable to login after changing password References: <52F21350.9060503@erabyte.it> In-Reply-To: <52F21350.9060503@erabyte.it> X-Forwarded-Message-Id: <52F21350.9060503@erabyte.it> Content-Type: multipart/alternative; boundary="------------040101020105010408040300" X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------040101020105010408040300 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit -------- Messaggio originale -------- Oggetto: Re: [ADMIN] Admin user issue: unable to login after changing password Data: Wed, 05 Feb 2014 11:32:48 +0100 Mittente: sharon A: desmodemone Hello sharon, > first : please use bottom posting > , so it's > more easy to read the mail history / thread from up to down. > Second: could you attach the pg_hba.conf ? > Third: how you connect to postgresql ? > Four: after modify the pg_hba.conf, did you reload or restart postgresql? > > I explain: if you connect to "localhost" the rule > > host all postgres localhost trust > > make you enter in the database trough the 127.0.0.1 on 5432 ( I > imagine you have the default settings and the firewall with the open > port or firewall down ) without password > > psql -U postgres -h localhost > > will connect to database > > if you not specified "locahost" the probably rule you will meet will > be about "local" connection : > > local all all peer > > that will make you enter without password, only if your OS account > exists in the database. > > > Bye > > Mat > > Nessun virus nel messaggio. > Controllato da AVG - www.avg.com > Versione: 2014.0.4259 / Database dei virus: 3684/7062 - Data di > rilascio: 04/02/2014 > Hi, for some reason pgsql uses only the ipv6 configuration while i was changing the ipv4. Now everything is working again. Thank you very much for your help Sharon --------------040101020105010408040300 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit


-------- Messaggio originale --------
Oggetto: Re: [ADMIN] Admin user issue: unable to login after changing password
Data: Wed, 05 Feb 2014 11:32:48 +0100
Mittente: sharon <sharon@erabyte.it>
A: desmodemone <desmodemone@gmail.com>


Hello sharon,
                        first : please use bottom posting , so it's more easy to read the mail history / thread from up to down.
Second: could you attach the pg_hba.conf ?
Third: how you connect to postgresql ?
Four: after modify the pg_hba.conf, did you reload or restart postgresql?

I explain:  if you connect to "localhost"  the rule

host     all             postgres             localhost               trust

make you enter in the database trough the 127.0.0.1 on 5432 ( I imagine you have the default settings and the firewall with the open port or firewall down ) without password

psql -U postgres -h localhost

will connect to database

if you not specified "locahost"  the probably rule you will meet will be about "local" connection :

local     all             all                             peer

that will make you enter without password, only if your OS account exists in the database.


Bye

Mat

Nessun virus nel messaggio.
Controllato da AVG - www.avg.com
Versione: 2014.0.4259 / Database dei virus: 3684/7062 - Data di rilascio: 04/02/2014


Hi,
for some reason pgsql uses only the ipv6 configuration while i was changing the ipv4.
Now everything is working again.

Thank you very much for your help

Sharon


--------------040101020105010408040300--