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@xxxxxxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
