Re: [GENERAL] Active/Active clustering in postgres

2014-11-26 Thread Suzuki Hironobu
(2014/11/27 2:20), John R Pierce wrote: On 11/26/2014 2:36 AM, Postgres India wrote: I am looking for PostgreSQL active/active clustering and whether PostgreSQL support any form of shared-storage clustering . Is there any methods or tools for implementing active/active clustering on Postgres su

Re: [GENERAL] 9.2 Replication in Ubuntu ; need help

2013-09-18 Thread Suzuki Hironobu
/13 0:58), AI Rumman wrote: Yes, I can access to the primary server perfectly. On Thu, Sep 12, 2013 at 11:55 AM, Suzuki Hironobu wrote: Hi, (13/09/12 23:53), AI Rumman wrote: Hi, I am trying to setup replication with Postgresql 9.2 in Ubuntu on Amazon Ec2. But stuck in the process. Postg

Re: [GENERAL] Number of WAL segment

2013-09-17 Thread Suzuki Hironobu
Hi, (13/09/17 21:46), tdev457 wrote: Hi, I am using PostgreSQL 8.3.8!!! How can I increase number of WAL segments in pg_xlog??? Current settings are: checkpoint_segments=10 checkpoint_completion_target=0.5 WAL segments are generated every 10 min and I want to keep WAL segments in pg_xlog for at

Re: [GENERAL] 9.2 Replication in Ubuntu ; need help

2013-09-12 Thread Suzuki Hironobu
Which value does pg_is_recovery() return on the primary server? (13/09/13 0:58), AI Rumman wrote: Yes, I can access to the primary server perfectly. On Thu, Sep 12, 2013 at 11:55 AM, Suzuki Hironobuwrote: Hi, (13/09/12 23:53), AI Rumman wrote: Hi, I am trying to setup replication wit

Re: [GENERAL] 9.2 Replication in Ubuntu ; need help

2013-09-12 Thread Suzuki Hironobu
Hi, (13/09/12 23:53), AI Rumman wrote: Hi, I am trying to setup replication with Postgresql 9.2 in Ubuntu on Amazon Ec2. But stuck in the process. Postgresql standby log is showing: 2013-09-12 14:45:47 UTC LOG: entering standby mode 2013-09-12 14:45:47 UTC LOG: redo starts at 1/3920 2013

Re: [GENERAL] psql client memory usage

2013-09-06 Thread Suzuki Hironobu
(13/09/06 21:06), Tim Kane wrote: Hi all, I have a fairly simple query, running on a particularly large table. For illustration: echo "select * from really_big_table;" | psql my_database > /dev/null When I monitor the memory usage of the psql session, it continually grows. In fact, for this

Re: [GENERAL] Question About WAL filename and its time stamp

2013-09-05 Thread Suzuki Hironobu
Hi, (13/09/05 22:19), ascot.m...@gmail.com wrote: Hi, From the pg_xlog folder, I found some files with interesting time stamps: older file names with newer timestamps, can you please advise why? Set 1: How come 00040F49008D is 10 minutes newer than 00040F49008E? -rw

Re: [GENERAL] Migration from DB2 to PostgreSQL-TIMESTAMP(arg1,arg1)

2013-06-27 Thread Suzuki Hironobu
On 2013-06-27 20:43, sachin kotwal wrote: While migrating my application from DB2 to PostgreSQL. I want to migrate TIMESTAMP() function of DB2 into PostgreSQL. Example in DB2: #SELECT TIMESTAMP('2013-01-01','12:13:14') FROM SYSIBM.SYSDUMMY1 1 -- 2013-01-01-12.13.14.

Re: [GENERAL] pgmemcache vs pgmemcached

2009-11-14 Thread Suzuki Hironobu
Juan Backson wrote: Hi, I had a chat with Suzuki Hironobu (pgmemcached maintainer) earlier this year and we pretty much decided that pgmemcache was the way to go after which Suzuku wrote a large patch to make it also support libmemcached behaviors and earlier PostgreSQL's