Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id B36371337BE3 for ; Wed, 30 Mar 2011 15:37:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 67518-05 for ; Wed, 30 Mar 2011 18:37:49 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-qw0-f46.google.com (mail-qw0-f46.google.com [209.85.216.46]) by mail.postgresql.org (Postfix) with ESMTP id 0CB9F1337B9C for ; Wed, 30 Mar 2011 15:37:48 -0300 (ADT) Received: by qwk3 with SMTP id 3so1009626qwk.19 for ; Wed, 30 Mar 2011 11:37:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:date:message-id:subject:from:to :content-type; bh=iZfV+iL+rNIcP2yvTkI7xZUNWI/UdJM1uAPFc3y1Byo=; b=EnvcZAC1Qq+81Ugnb3ZYcIKjwbiyxni07QKD51VJCNIPUInfgh6zRy8kOn+9dluhPR tombmi9EvN5Cw6c/IRQk0qVVNeFRXHjMCKAeiNVDS8//AJdgSHJPVYOmadAlnkI2NEbU ghvUJSUzc50DQM58nlt3hvNtb3IgyrqF7mzFc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=Dv3n6S1O7KEAkWtAVXIWl+O5WBpQAswdGqmfvw0Mp3XLqUtN2UNWpH09Umya1YFy4X d5Wox6BpPemRiIm3g13iK82O1DkMNewWp8uxxUAe3Qu5VPnXtKA3CgBa8nPOw5vbEZxz ZfjFWLt6PGLS+XZ0wOBHoJMshMo5UqZV5Bono= MIME-Version: 1.0 Received: by 10.224.64.86 with SMTP id d22mr1407578qai.359.1301510268656; Wed, 30 Mar 2011 11:37:48 -0700 (PDT) Received: by 10.224.67.77 with HTTP; Wed, 30 Mar 2011 11:37:48 -0700 (PDT) Date: Wed, 30 Mar 2011 20:37:48 +0200 Message-ID: Subject: problem with an account name 'replication' for streaming replication From: Uwe Bartels To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=0016e64ba30a3c1c79049fb779ce X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.692 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, FS_REPLICA=3.599, HTML_MESSAGE=0.001, HTML_OBFUSCATE_05_10=0.26, NORMAL_HTTP_TO_IP=0.001, SARE_SPEC_REPLICA=0.72, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: ** X-Archive-Number: 201103/279 X-Sequence-Number: 37151 --0016e64ba30a3c1c79049fb779ce Content-Type: text/plain; charset=ISO-8859-1 Hi, when I used the postgres login 'replication' as the account for streaming replication I get the following error message: 2011-03-28 18:06:47 CEST FATAL: could not connect to the primary server: FATAL: no pg_hba.conf entry for replication connection from host "172.16.56.122", user "replication", SSL off The corresponding pg_hba.conf entry was correct and there was no other matching entry before that line. # TYPE DATABASE USER CIDR-ADDRESS METHOD host replication replication 172.16.56.122/32 md5 By changing the account name - everything worked as smoth as I am used to with postgres. Best Regards, Uwe --0016e64ba30a3c1c79049fb779ce Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi,

when I used the postgres login 'replication' as the acco= unt for streaming replication I get the following error message:
2011-03= -28 18:06:47 CEST FATAL:=A0 could not connect to the primary server: FATAL:= =A0 no pg_hba.conf entry for replication connection from host "172.16.= 56.122", user "replication", SSL off

The corresponding pg_hba.conf entry was correct and there was no other = matching entry before that line.
# TYPE=A0 DATABASE=A0=A0=A0=A0=A0=A0=A0= USER=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 CIDR-ADDRESS=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 METHOD
host=A0=A0=A0 replication=A0=A0=A0=A0 replication =A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 172.1= 6.56.122/32=A0=A0=A0=A0=A0=A0=A0 md5

By changing the account name - everything worked as smoth as I am used = to with postgres.

Best Regards,
Uwe
--0016e64ba30a3c1c79049fb779ce--