Re: [HACKERS] dividing privileges for replication role.

2013-01-23 Thread Tomonari Katsumata
Hi, Michael 2013/1/23 Michael Paquier > > > On Wed, Jan 23, 2013 at 5:46 PM, Tomonari Katsumata < > t.katsumata1...@gmail.com> wrote: > >> ex: >> >> primary_conninfo = 'port=5432 standby_mode=master-cascade' >> primary_conninfo = 'port=5432 standby_mode=master-only' >> primary_conninfo = '

Re: [HACKERS] dividing privileges for replication role.

2013-01-23 Thread Michael Paquier
On Wed, Jan 23, 2013 at 5:46 PM, Tomonari Katsumata < t.katsumata1...@gmail.com> wrote: > ex: > > primary_conninfo = 'port=5432 standby_mode=master-cascade' > primary_conninfo = 'port=5432 standby_mode=master-only' > primary_conninfo = 'port=5432 standby_mode=cascade-only' > > I think it wil

Re: [HACKERS] dividing privileges for replication role.

2013-01-23 Thread Tomonari Katsumata
Hi, Tom Thank you for comments. > Tomonari Katsumata writes: > >> Why is it better to do this with a privilege, rather than just using > >> pg_hba.conf? > > > > You are right. > > Handling with pg_hba.conf is an easy way. > > > But I think many users think about switch over, so > > the pg_hba.co

Re: [HACKERS] dividing privileges for replication role.

2013-01-21 Thread Tom Lane
Tomonari Katsumata writes: >> Why is it better to do this with a privilege, rather than just using >> pg_hba.conf? > You are right. > Handling with pg_hba.conf is an easy way. > But I think many users think about switch over, so > the pg_hba.conf is same on master and standby. > it's not convini

Re: [HACKERS] dividing privileges for replication role.

2013-01-21 Thread Tomonari Katsumata
Hi, Magnus, Josh, Michael, Craig Thank you for comments and registring to CommitFest. >> I made a patch to divide privileges for replication role. >> >> Currently(9.2), the privilege for replication role is >> true / false which means that standby server is able to >> connect to another server or

Re: [HACKERS] dividing privileges for replication role.

2013-01-20 Thread Craig Ringer
On 01/19/2013 11:47 AM, Tomonari Katsumata wrote: > > Hi, > > I made a patch to divide privileges for replication role. > I've added your patch to the commitfest tracking app for the post-9.3 release; see https://commitfest.postgresql.org/action/patch_view?id=1072 . If it's convenient for you to

Re: [HACKERS] dividing privileges for replication role.

2013-01-20 Thread Michael Paquier
On Sat, Jan 19, 2013 at 12:47 PM, Tomonari Katsumata < t.katsumata1...@gmail.com> wrote: > a) adding new privileges for replication:"MASTER REPLICATION" and "CASCADE > REPLICATION" > >"MASTER REPLICATION": Replication-connection to master server is only > allowed >"CASCADE REPLICATION": R

Re: [HACKERS] dividing privileges for replication role.

2013-01-20 Thread Josh Berkus
Katsumata-san, > In this patch, I made below. > a) adding new privileges for replication:"MASTER REPLICATION" and "CASCADE > REPLICATION" >"MASTER REPLICATION": Replication-connection to master server is only > allowed >"CASCADE REPLICATION": Replication-connection to cascade server is on

Re: [HACKERS] dividing privileges for replication role.

2013-01-20 Thread Magnus Hagander
On Sat, Jan 19, 2013 at 4:47 AM, Tomonari Katsumata wrote: > Hi, > > I made a patch to divide privileges for replication role. > > Currently(9.2), the privilege for replication role is > true / false which means that standby server is able to > connect to another server or not with the replication