Re: Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

From: Ray Stell <stellr(at)vt(dot)edu>
To: Frank Pinto <frank(at)ayalo(dot)co>
Cc: Jorge Arevalo <jorgearevalo(at)libregis(dot)org>, Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method
Date: 2014-08-07 13:31:42
Message-ID: CBB57C05-E35E-40DE-8F84-383DEBCF4B83@vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Aug 6, 2014, at 6:56 PM, Frank Pinto <frank(at)ayalo(dot)co> wrote:
>
> and make sure you restarted the server so your changes take effect.
>

reload will get it, also, and is sometimes easier to come by.

The pg_hba.conf file is read on start-up and when the main server process receives a SIGHUP signal. If you edit the file on an active system, you will need to signal the postmaster (using pg_ctl reload or kill -HUP) to make it re-read the file.
http://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-08-07 13:43:39 Re: Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method
Previous Message Kevin Grittner 2014-08-07 13:10:59 Re: Reindex taking forever, and 99% CPU