Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bcq8d-0005bA-Om for pgsql-admin@arkaria.postgresql.org; Thu, 25 Aug 2016 08:35:51 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bcq8d-0003xa-AD for pgsql-admin@arkaria.postgresql.org; Thu, 25 Aug 2016 08:35:51 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bcq6v-0001ya-6R for pgsql-admin@postgresql.org; Thu, 25 Aug 2016 08:34:05 +0000 Received: from mail-wm0-x22a.google.com ([2a00:1450:400c:c09::22a]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bcq6r-0005Y4-Uv for pgsql-admin@postgresql.org; Thu, 25 Aug 2016 08:34:03 +0000 Received: by mail-wm0-x22a.google.com with SMTP id i5so59864092wmg.0 for ; Thu, 25 Aug 2016 01:34:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:subject:from:reply-to:to:cc:date:in-reply-to:references :mime-version; bh=KIpLSCbdqSfBG3dg4nElWHNVuSDmm33SrBvFfmoD+Z4=; b=CZxy8zsz41vZuWLsKBOFdc7LDZs605dXwarNOUh1OXITdyueEsl/qCQr7Kx2zMRmq0 b668LcdLUl7Vr/c20LXdFuaKDR0TFL7T8cSh6lOB9MNNyFCd9K0x1nMm7iAb7Cz+nVF7 I6D8Nu/4YwhZtYh6miR6cAQ4O8xTq2W3dFAT7wOMgDsNW7fczTR4Q47Br3+fbv6zjMTZ v4O1u9QjsVfd5HKHQ4JZsnpp+EyNtA6r+1gx4PScvyTasTTUqgAD1re03EQUTdmj+h9d KMoP/R/JHdlXT8GpntSXTiFzNQ5QMdxhsw3yjanMrI0uBnUy4HcbzT5x4NIOnmfmea5k VtnQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:message-id:subject:from:reply-to:to:cc:date :in-reply-to:references:mime-version; bh=KIpLSCbdqSfBG3dg4nElWHNVuSDmm33SrBvFfmoD+Z4=; b=TrisSaj2d7NTteS+tpCmEyjG5/Gvl8Z9ruEeOUhrk2q7JVrNtPWi0rgBfg7xJ1+GLR auhJHirV6zU+RE5TIOKBNXHDK/JJNiS/7+jnF4oZJdoAfq1WGOOfGfL1S9Spofro9ob4 cOgNsfk6+o5eJtqPvG8t+9Ib17iga5ePMm/OyMSQHM6dLvNhG/dlr7klfLGq6vQUM3+Z wVqXi6nPCam8Z1DK3byuG6I8Xxrho2m48rrdkR+sFQaq3yCKfj7b/6rIZtJHwve6cNd7 x+GmXR7snio6HHEKRDGfy7CgHUXmY52RI2KZScqP6pY6U7HZ5fFhWOxFX9HGK487shc+ bS/w== X-Gm-Message-State: AEkoousszYbK7qffeER16Oe+YRVxdyxEIZJ9XjvgmlWpyZOkZj7kX+96w1z0WyCkvn7Pcg== X-Received: by 10.194.184.175 with SMTP id ev15mr6244965wjc.90.1472114040549; Thu, 25 Aug 2016 01:34:00 -0700 (PDT) Received: from enterprisedb01 (static.152.248.213.82.ibercom.com. [82.213.248.152]) by smtp.googlemail.com with ESMTPSA id vv2sm13938856wjc.29.2016.08.25.01.33.59 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 25 Aug 2016 01:33:59 -0700 (PDT) Message-ID: <1472114023.9541.35.camel@gmail.com> Subject: Re: fe_sendauth: no password supplied - PostgreSQL 9.2 From: jaime soler Reply-To: jaime.soler@gmail.com To: Patrick B , Lucas Possamai Cc: pgsql-admin Date: Thu, 25 Aug 2016 10:33:43 +0200 In-Reply-To: References: Content-Type: multipart/alternative; boundary="=-HTVe86GCMhuxgTWhVkgD" X-Mailer: Evolution 3.18.5.2-0ubuntu3 Mime-Version: 1.0 X-Pg-Spam-Score: -2.7 (--) 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 --=-HTVe86GCMhuxgTWhVkgD Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit El lun, 08-08-2016 a las 08:32 +1200, Patrick B escribió: > > > 2016-08-08 8:21 GMT+12:00 Lucas Possamai : > > Change the pg_hba.conf on your slave01 server: > > > > > local   all             all                                     > > > trust > > > host    all             all             0.0.0.0/0               > > > trust > > > host    replication     replicator      0.0.0.0/0               > > > trust > > Replace the 0.0.0.0/0 for the IP address of slave02 server. > > > > Hi Lucas!! > > That worked... thanks a lot! :) I think trust authentication method  is only recommended for testing I'll use md5 as you were using and you need to create a pgpass file with includes replicator password and the replication process doesn't throw any error. > > > Patrick > --=-HTVe86GCMhuxgTWhVkgD Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable
El lun, 08-08-2016 a las 08:32 +1200, Patrick= B escribi=C3=B3:


2016-08-08 8:21 GMT+12= :00 Lucas Possamai <drum.lucas@gmail.com>:
Change the pg_hba.conf on your slave01 serv= er:

local   all   &n= bsp;         all           &nb= sp;                     &= nbsp;   trust
host   = ; all             all       &n= bsp;     0.0.0.0/0=               trust
host    replication     replic= ator      0.0= .0.0/0               trust

Replace the 0.0.0.0/0 for the IP address of slave02= server.



Hi Lucas!!
That worked... thanks a lot! :)

I think trust authentication method  is only recommended for testin= g I'll use md5 as you were using and you need to create a pgpass file with = includes replicator password and the replication process doesn't throw any = error.


Patrick
--=-HTVe86GCMhuxgTWhVkgD--