Re: how to add a replication connection entry in pg_hba.con file

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: srao(at)interrasystems(dot)com
Cc: Sanjay Rao <srao(at)noida(dot)interrasystems(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: how to add a replication connection entry in pg_hba.con file
Date: 2011-06-09 15:35:39
Message-ID: 4DF0E84B.8070800@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 09/06/2011 16:08, Sanjay Rao wrote:
> how to add a replication connection entry in pg_hba.con file ? I am
> getting this error at standby server
>
> 2011-06-09 20:37:16 IST FATAL: could not connect to the primary server:
> FATAL: no pg_hba.conf entry for replication connection from host
> "192.168.4.145", user "postgres", SSL off

It's a plain text file, so you just edit it with your favourite text
editor, and add a line as needed. The file is well documented via comments.

Is that what you mean?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Radosław Smogura 2011-06-09 15:49:47 Re: Best Practices - Securing an Enterprise application using JBOSS & Postgres
Previous Message Alan Hodgson 2011-06-09 15:08:55 Re: Write performance on a large database