Re: replication problems 9.0 - Mailing list pgsql-general

From Rodrigo Gonzalez
Subject Re: replication problems 9.0
Date
Msg-id 4DEEB92D.1090002@estrads.com.ar
Whole thread Raw
In response to Re: replication problems 9.0  (owen marinas <owen.marinas@featureset.com>)
List pgsql-general
I am not an expert but I will try to explain.

replication user has access to WAL stream, bypassing any revoked
permission on any database.

I think that is the reason to force a specific user with specific
permissions for replication....you don't want user x reading WAL stream
while you don't grant the user access to all database objects

I hope I am clear in my poor English

Regards

Rodrigo Gonzalez

On 06/07/2011 08:38 PM, owen marinas wrote:
> Thx, Merci, Gracias Rodrigo
> it worked indeed, Im wondering why replication is not included in "All"
>
> regards
> Owen
>
>
> On Tue, Jun 7, 2011 at 2:40 PM, Rodrigo Gonzalez
> <rjgonzale@estrads.com.ar>  wrote:
>> On 06/07/2011 03:05 PM, Owen Marinas wrote:
>>>
>>> Added the lines in the Master
>>> root@ip-172-19-1-37:~# cat /etc/postgresql/9.0/main/pg_hba.conf |grep
>>> trust
>>> host all postgres 172.19.1.101/32 trust
>>>
>>
>> You need in pg_hba.conf
>>
>> host    replication     repuser         172.19.1.101/32          md5
>>
>> Database must be replication for the replication user
>>
>> Regards
>>
>> Rodrigo Gonzalez
>>
>


pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: replication problems 9.0
Next
From: Toby Corkindale
Date:
Subject: Re: windows vista and windows 7