[HACKERS] dividing privileges for replication role.

2013-01-18 Thread Tomonari Katsumata
Software Corporation Tomonari Katsumata *** a/src/backend/commands/user.c --- b/src/backend/commands/user.c *** *** 250,256 CreateRole(CreateRoleStmt *stmt) if (dcanlogin) canlogin = intVal(dcanlogin-arg) != 0; if (disreplication

Re: [HACKERS] dividing privileges for replication role.

2013-01-21 Thread Tomonari Katsumata
of switch will be needed. Because some users may need the cyclic situation. I'm not insisting to use replication-role, but I want something to control this behavior. regards, NTT Software Corporation Tomonari Katsumata

Re: [HACKERS] dividing privileges for replication role.

2013-01-23 Thread Tomonari Katsumata
Hi, Tom Thank you for comments. Tomonari Katsumata t.katsumata1...@gmail.com 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

Re: [HACKERS] dividing privileges for replication role.

2013-01-23 Thread Tomonari Katsumata
Hi, Michael 2013/1/23 Michael Paquier michael.paqu...@gmail.com 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

[HACKERS] comment for fast promote

2013-07-25 Thread Tomonari Katsumata
(PROMOTE_SIGNAL_FILE); 9938 fast_promote = true; 9939 } --- Is this command necesary ? regards, -- NTT Software Corporation Tomonari Katsumata -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] comment for fast promote

2013-07-25 Thread Tomonari Katsumata
Hi Fujii-san, Thank you for response. (2013/07/25 21:15), Fujii Masao wrote: On Thu, Jul 25, 2013 at 5:33 PM, Tomonari Katsumata katsumata.tomon...@po.ntts.co.jp wrote: Hi, Now I'm seeing xlog.c in 93_stable for studying fast promote, and I have a question. I think it has an extra

Re: [HACKERS] comment for fast promote

2013-07-27 Thread Tomonari Katsumata
. You can execute checkpoint after fast promotion for that. OK. Then I think we should do below things. - removing normal promotion at all from source - adding the know-how you suggest on document Are there any objection? regards, --- Tomonari Katsumata

Re: [HACKERS] comment for fast promote

2013-08-03 Thread Tomonari Katsumata
are created by user as a trigger_file or pg_ctl promote command. --- Tomonari Katsumata 2013/7/30 Fujii Masao masao.fu...@gmail.com On Sat, Jul 27, 2013 at 6:57 PM, Tomonari Katsumata t.katsumata1...@gmail.com wrote: Hi, Yes, it prevents PROMOTE_SIGNAL_FILE from remaining even

Re: [HACKERS] Should we remove not fast promotion at all?

2013-08-06 Thread Tomonari Katsumata
}/fast_promote is not created automatically) regards, --- Tomonari Katsumata

Re: [HACKERS] Should we remove not fast promotion at all?

2013-08-08 Thread Tomonari Katsumata
it and make a standby on the server, the standby will promote soon. I think this is not so big problem, but not user-friendly. Against this, I'm thinking unlinking these files before starting recovery. This should be fixed in 9.4 too? - Tomonari Katsumata -- Sent via pgsql-hackers

[HACKERS] How to create read-only view on 9.3

2013-08-13 Thread Tomonari Katsumata
on the restored database. I want to make these views read-only like PostgreSQL9.2. How can I do this? Should I make access control on users ? (Sorry, I couldn't find any explanations on document.) regards, NTT Software Corporation Tomonari Katsumata -- Sent via pgsql-hackers mailing

Re: [HACKERS] How to create read-only view on 9.3

2013-08-13 Thread Tomonari Katsumata
Software Corporation Tomonari Katsumata (2013/08/13 19:16), Szymon Guz wrote: On 13 August 2013 11:43, Tomonari Katsumata katsumata.tomon...@po.ntts.co.jp wrote: Hi, Could anyone tell me how to create read-only view on PostgreSQL 9.3 ? I've been testing updatable views and noticed that all

Re: [HACKERS] How to create read-only view on 9.3

2013-08-13 Thread Tomonari Katsumata
was not thinking about changing current 9.3 behavior. So I think it's enough to know the impact and how to avoid that on the release notes. thanks a lot! regards, --- NTT Software Corporation Tomonari Katsumata -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

[HACKERS] The PostgreSQL License requires LICENSE file?

2013-09-03 Thread Tomonari Katsumata
instead of LICENSE. Anybody knows the reason? And is this non problem thing? regards, - Tomonari Katsumata

Re: [HACKERS] The PostgreSQL License requires LICENSE file?

2013-09-03 Thread Tomonari Katsumata
name reference be removed. Thank you for checking it soon. I understands that the PostgreSQL license does not require any specified file name and missing LICENSE is not problem. I'm Sorry for the stupid question. regards, Tomonari Katsumata -- Sent via pgsql-hackers mailing list

Re: [HACKERS] [BUG] Archive recovery failure on 9.3+.

2014-01-09 Thread Tomonari Katsumata
Hi, Somebody is reading this thread? This problem seems still remaining on REL9_3_STABLE. Many users would face this problem, so we should resolve this in next release. I think his patch is reasonable to fix this problem. Please check this again. regards, -- Tomonari

Re: [HACKERS] [BUG] Archive recovery failure on 9.3+.

2014-02-12 Thread Tomonari Katsumata
Hi Heikki, I need PostgreSQL9.3 which fixed this problem. It didn't happen in PostgreSQL9.2, so I agree with your proposal which changes are done against 93_STABLE and master. Can you fix this in next release(9.3.3)? Tomonari Katsumata (2014/01/13 20:16), Heikki Linnakangas

[HACKERS] Little confusing things about client_min_messages.

2014-03-08 Thread Tomonari Katsumata
the attached patch. regards, --- Tomonari Katsumata clear_client_min_messages.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Little confusing things about client_min_messages.

2014-03-09 Thread Tomonari Katsumata
Hi Tom, Bruce, Thank you for your response. (2014/03/09 2:12), Tom Lane wrote: Bruce Momjian br...@momjian.us writes: On Sat, Mar 8, 2014 at 11:31:22AM -0500, Tom Lane wrote: Tomonari Katsumata t.katsumata1...@gmail.com writes: [ client_min_messages = info is not documented ] That's

Re: [HACKERS] Little confusing things about client_min_messages.

2014-03-10 Thread Tomonari Katsumata
Hi 2014-03-10 23:45 GMT+09:00 Tom Lane t...@sss.pgh.pa.us: Tomonari Katsumata katsumata.tomon...@po.ntts.co.jp writes: Adding FATAL and PANIC to client_min_messages is done at below-commit. 8ac386226d76b29a9f54c26b157e04e9b8368606 http://git.postgresql.org/gitweb/?p=postgresql.git

[HACKERS] small typo about comment in xlog.c

2014-04-09 Thread Tomonari Katsumata
A backup started with pg_stop_backup() should be A backup started with pg_start_backup(). This is a bug about source comment, so it's not big problem. But I want to fix the comment. See attached patch. regards, -- Tomonari Katsumata diff --git a/src/backend/access/transam/xlog.c b/src

Re: [HACKERS] 9.4 release notes

2014-05-22 Thread Tomonari Katsumata
of pg_receivexlog. It should jump to pg_recvlogical(app-pgrecvlogical.html). regards, Tomonari Katsumata -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] proposal: rounding up time value less than its unit.

2014-07-10 Thread Tomonari Katsumata
some GUCs have special meaning for 0. And then I made a patch for this. Please check the attached patch. regards, --- Tomonari Katsumata diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 04ddd73..9aaffb0 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml

Re: [HACKERS] proposal: rounding up time value less than its unit.

2014-07-12 Thread Tomonari Katsumata
Hi Robert, Thank you for checking this! I've added it to commitfest. https://commitfest.postgresql.org/action/patch_view?id=1507 regards, Tomonari Katsumata 2014-07-12 6:07 GMT+09:00 Robert Haas robertmh...@gmail.com: On Thu, Jul 10, 2014 at 2:52 AM, Tomonari Katsumata

Re: [HACKERS] proposal: rounding up time value less than its unit.

2014-08-22 Thread Tomonari Katsumata
complaint is fixed, I'm worried about this change will make users confusing. Is it better to raise a message(ex. INFO) when a value less than required unit is set? 2014-08-21 21:00 GMT+09:00 Heikki Linnakangas hlinnakan...@vmware.com: On 07/10/2014 09:52 AM, Tomonari Katsumata wrote: Hi, Several

Re: [HACKERS] proposal: rounding up time value less than its unit.

2014-09-02 Thread Tomonari Katsumata
non-zero value yields a zero. A zero rounded down from non-zero gets an error. I attached new patch. This includes a document about above behavior as Heikki suggested. regards, -- Tomonari Katsumata 2014-08-27 6:49 GMT+09:00 David G Johnston david.g.johns...@gmail.com: Tom Lane-2

Re: [HACKERS] Commitfest status

2014-09-11 Thread Tomonari Katsumata
Hi, I've update my entry. [rounding up time value less than its unit] https://commitfest.postgresql.org/action/patch_view?id=1507 regards, - Tomonari Katsumata (2014/09/12 7:03), Tomas Vondra wrote: On 11.9.2014 21:14, Petr Jelinek wrote: On 11/09/14 18:59, Tomas Vondra wrote