Re: [HACKERS] Streaming replication and privilege

2010-03-08 Thread Fujii Masao
On Fri, Mar 5, 2010 at 3:14 AM, Josh Berkus wrote: > On 3/4/10 2:47 AM, Fujii Masao wrote: >> This TODO item really needs to be addressed for 9.0? Frankly I'm not >> familiar with that area, so I've not work on it at all yet, but I'm >> going to create the patch if many people want it for 9.0. Wha

Re: [HACKERS] Streaming replication and privilege

2010-03-04 Thread Josh Berkus
On 3/4/10 2:47 AM, Fujii Masao wrote: > This TODO item really needs to be addressed for 9.0? Frankly I'm not > familiar with that area, so I've not work on it at all yet, but I'm > going to create the patch if many people want it for 9.0. What is > your opinion? I think it falls under "nice to hav

Re: [HACKERS] Streaming replication and privilege

2010-03-04 Thread Robert Haas
On Thu, Mar 4, 2010 at 5:47 AM, Fujii Masao wrote: > Currently superuser privilege is required when the standby connects > to the primary. But there is the complaint that we should add new > privilege for replication and use it instead of superuser because > current approach is not good for securi

[HACKERS] Streaming replication and privilege

2010-03-04 Thread Fujii Masao
Hi, Currently superuser privilege is required when the standby connects to the primary. But there is the complaint that we should add new privilege for replication and use it instead of superuser because current approach is not good for security (*1). This has been listed as one of TODO items of S