Re: [Pgpool-general] authentication problems

2010-04-13 Thread Christophe Philemotte
> In my configuration I have enabled the "enable_pool_hba" option, and, in > "pool_hba.conf" I have all the IP in trusted authentication mode (it just > can be trust, reject or PAM). > In my "pg_hba.conf" file, I have those same IPs but, this time, in > "password" authernticacion mode. I think you

Re: [Pgpool-general] authentication problems

2010-04-12 Thread Christophe Philemotte
e hostdatabase user localhost md5 before, the password authentication type will not work. > So my question: Is it possible to recover (pcp_recovery_node) with "password > method" ? I do, it works. > If it is not is it possible to do so with PAM? I do not t

Re: [Pgpool-general] Database verification

2010-03-11 Thread Christophe Philemotte
It's ok from this side, now. I don't forget. Just don't have the time. Christophe On Thu, Mar 11, 2010 at 10:59 AM, Tomasz Chmielewski wrote: > Am 05.03.2010 09:22, Christophe Philemotte wrote: >>>> >>>> you're rigth, I do not know data-wise dif

Re: [Pgpool-general] Database verification

2010-03-05 Thread Christophe Philemotte
ed it. Before publishing it, I have to resolve some formal legal issues with one of my clients. I'll tell you when it is published. Regards, Christophe Philemotte ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] Database verification

2010-03-04 Thread Christophe Philemotte
solution to check if backends are synchronized or not. Do you think that could interest people? Or do you know an existing tool? Christophe Philemotte ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] Database verification

2010-03-04 Thread Christophe Philemotte
Hi Arjen Roodselaar, There exist some diff tools: - apgdiff http://apgdiff.sourceforge.net/ - pgdiff http://pgdiff.sourceforge.net/ or your home-made diff tool. Regards, Christophe Philemotte On Thu, Mar 4, 2010 at 11:19 AM, Arjen Roodselaar wrote: > Hi all, > > I recently star

Re: [Pgpool-general] health check failed due an Interrupted system call

2010-03-01 Thread Christophe Philemotte
Thanks Tatsuo Ishii. I do not have control on infrastructure. And the hosting service we use do not report, this time, any network problem or work. The PostgreSQL did not have any problem and was still running. The most probable reason is then the network. Christophe Philemotte On Mon, Mar 1

[Pgpool-general] health check failed due an Interrupted system call

2010-03-01 Thread Christophe Philemotte
gpool-II 2.3.2.1). It seems that its is read(). It is the first time I notice this kind of error. Usually, it a timed out connection one. So, I'm not confident about reproducing it. How can I interpret this error? Is it simply because read() was blocked? Christophe

[Pgpool-general] pg_dump

2010-02-01 Thread Christophe Philemotte
any known issues with pg_dump with pgpool-II 2.3.1? Christophe Philemotte ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] Pgpool-general Digest, Vol 63, Issue 1

2010-02-01 Thread Christophe Philemotte
do not directly use a Serial data type. I would like to understand the reasons that are behind your advice. Could you explain why? Thanks, Christophe Philemotte ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general

Re: [Pgpool-general] Online recovery during load

2010-02-01 Thread Christophe Philemotte
uot;" ];then psql -p $port -c "SELECT setval(oid, nextval(oid)) FROM pg_class WHERE relkind = 'S'" $i fi done Mentioning this issue and its fix in the pgpool documentation should worthful IMHO. Now, the online recovery w

Re: [Pgpool-general] Online recovery during load

2010-01-15 Thread Christophe Philemotte
m the front-ends of the web platform (i.e. open connection, send a > request, (supposedly) close connection), everything goes fine. But > with "persistent" connections, so to speak, pgpool-II is not always > capable of dropping them. Ok, it is my feeling I've just exposed abo

[Pgpool-general] Online recovery during load

2010-01-13 Thread Christophe Philemotte
set up better pgpool? If you need any config elements or whatever, please tell me. Anyway, thanks to the pgpool's team for this great software :). Christophe Philemotte ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general