Re: [GENERAL] Merge a sharded master into a single read-only slave

2014-06-04 Thread Koichi Suzuki
Here's PostgreSQL-based sharding solution which provides both read/write horizontal scalability. http://sourceforge.net/apps/mediawiki/postgres-xc/index.php?title=Main_Page http://sourceforge.net/projects/postgres-xc/ Hope this helps. --- Koichi Suzuki 2014-06-03 3:47 GMT+09:00 Séba

Re: [Postgres-xc-general] [GENERAL] "Tuple not found error" during Index creation

2013-12-12 Thread Koichi Suzuki
In 1.0, we added new APIs to GTM so that vacuum can run with global XID and snapshot. We may need more improvement to use this. It is wonderful if Mason provides a patch to fix this. Regards; --- Koichi Suzuki 2013/12/11 Michael Paquier : > On Tue, Dec 10, 2013 at 11:00 PM, Mason Sh

Re: [GENERAL] Distributed systems and primary keys

2013-07-12 Thread Koichi Suzuki
to be bi-directional replication) people are doing this kind of work. Regards; -- Koichi Suzuki 2013/7/12 Joshua D. Drake > > On 07/12/2013 07:23 AM, Melvin Call wrote: > >> Hello list, >> >> Can anyone point me to some reading material on how auto-genera

Re: [GENERAL] Scalable cluster

2013-03-04 Thread Koichi Suzuki
Version 1.1 will be out in this June time frame, with online node addition/removal, Trigger and improved planner. I'm more than happy if you evaluate XC. Regards; -- Koichi Suzuki 2013/3/4 Greg Jaskiewicz : > > On 4 Mar 2013, at 13:21, Vincent Veyron wrote: > >&

Re: [GENERAL] cloning postgres-xc

2013-02-12 Thread Koichi Suzuki
Yes, this ML is not a right place to discuss this. Could you raise this issue at postgres-xc-general ML? Regards; -- Koichi Suzuki 2013/2/12 Pavan Deolasee : > This may not be the best place to ask these questions and you could > have considered using postgres-xc-general mailin

Re: [GENERAL] Does Version 9.1 Streaming Replication Supports Multi-Master?

2012-01-18 Thread Koichi Suzuki
Yes it does, not for hot standby though. Each node can have streaming replication slave for recovery. Also, GTM has its own backup/recovery mechanism which provide no-loss failover when GTM fails. Regards; -- Koichi Suzuki # For XC to provide hot standby feature, we need to

Re: [GENERAL] Is pglesslog stable for use in 9.0?

2011-03-30 Thread Koichi Suzuki
og for 9.0 locally and test was okay. However, I'd like to provide how to solve such a problem. I will announce when I found a solution for this and pglesslog is available for 9.x Thank you very much; --- Koichi Suzuki -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Pglesslog issue

2010-08-01 Thread Koichi Suzuki
y did them) and then "make" pglesslog. I hope they work fine. Regards; --- Koichi Suzuki 2010/7/29 raghu ram : > Hi, > I was installed the Postgresql 8.3 and trying the use the > "pg_lesslog_1.4.1_pg83" to reduce the size of WAL file when the WAL file is > archived

[GENERAL] Bug-fix and new feature of pg_lesslog is released

2010-05-12 Thread Koichi Suzuki
included in contrib module if it is ported to PostgreSQL 9.1. Best Regards; -- Koichi Suzuki # pg_lesslog is a project to compress large WAL segments when they're stored and restore then for recovery. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Problem with pg_compresslog'd archives

2010-04-19 Thread Koichi Suzuki
Not yet. I'm rebuilding the test suit for better testing. If you're in a hurry, I can send you an update for test. ------ Koichi Suzuki 2010/4/19 Karl Denninger : > Has there been an update on this situation? > > Koichi Suzuki wrote: > > I understand the sit

Re: [GENERAL] [HACKERS] Bug on pg_lesslog

2010-02-11 Thread Koichi Suzuki
Thank you very much for the advice. Yes I think it should go to announce. I will post a message. -- Koichi Suzuki 2010/2/12 Karl Denninger : > Joshua D. Drake wrote: > > On Thu, 2010-02-11 at 23:39 +0900, Koichi Suzuki wrote: > > > Dear Folks; > > A very ser

[GENERAL] Bug on pg_lesslog

2010-02-11 Thread Koichi Suzuki
I'll upload the new version ASAP. Warmest Regards; ------ Koichi Suzuki -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Bug on pg_lesslog

2010-02-11 Thread Koichi Suzuki
I'll upload the new version ASAP. Warmest Regards; ------ Koichi Suzuki -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Problem with pg_compresslog'd archives

2010-02-11 Thread Koichi Suzuki
I understand the situation. I'll upload the improved code ASAP. -- Koichi Suzuki 2010/2/11 Karl Denninger : > Will this come through as a commit on the pgfoundry codebase?  I've > subscribed looking for it > > The last edit, if I read the release notes

Re: [GENERAL] Problem with pg_compresslog'd archives

2010-02-10 Thread Koichi Suzuki
I found it's pg_compresslog problem (calculation of XNOOP record length used in pg_decompresslog).I'm fixing the bug and will upload the fix shortly. Sorry for inconvenience. ------ Koichi Suzuki 2010/2/8 Karl Denninger : > This may belong in a bug report, but I&#x

Re: [GENERAL] [HACKERS] New PostgreSQL Committers

2009-12-07 Thread Koichi Suzuki
gt;>> >> >> +1 > > Outstanding!  Congratulations, all! +1 Appreciate for their contributions. Congratulations all! Koichi Suzuki > > -Kevin > > -- > Sent via pgsql-hackers mailing list (pgsql-hack...@postgresql.org) > To make changes to your subscriptio

Re: [GENERAL] Minimizing Recovery Time (wal replication)

2009-04-14 Thread Koichi Suzuki
in. > > Thanks, > Bryan > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- -- Koichi Suzuki -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] New 8.4 hot standby feature

2009-02-02 Thread Koichi Suzuki
mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- -- Koichi Suzuki -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] lesslog "incorrect resource manager data checksum."

2009-01-05 Thread Koichi Suzuki
d logs that are known to report pg_compresslog problem. Once pg_compresslog will work, I plan to test "the other side" solution with pg_decompresslog :) Thanks for your reply! 2008/11/20 Koichi Suzuki <mailto:koichi@gmail.com>> Hi, Sorry I was out and late

Re: [GENERAL] lesslog "incorrect resource manager data checksum."

2008-11-19 Thread Koichi Suzuki
so I believe the coverage is reasonable. Sorry for the inconvenience and thanks a lot for your help. - Koichi Suzuki 2008/11/18 Jean-Christophe Arnu <[EMAIL PROTECTED]>: > Hi, > > I'm trying to use lesslog 1.1 (out of NTT rpm available on pgfoundry) on my > pg_xlog