|
osdir.com mailing list archive |
|
Subject: Re: md5 Authentication problem - msg#00007List: db.postgresql.pgpool.generalPlease look into this to know why it's not possible to support md5 in pgpoool: http://lists.pgfoundry.org/pipermail/pgpool-general/2008-August/001171.html -- Tatsuo Ishii SRA OSS, Inc. Japan > Hi All, > > I got a scenario where I am using: > > master slave mode = true > load balancing mode = true > replication mode = false > > Where I got one master and one slave with Slony replication, and both of > those database servers are using md5 authentication. Now I figured out md5 > is currently not supported for pool_hba.conf file. How is it possible to > cater for such a scenario and I dont want to change the authentication > methods for db server. Is there a workaround? > > Also wanted to ask if anyone has an idea to when md5 will be supported in > pool_hba.conf file? > > Regards, > Shoaib Thread at a glance:
Previous Message by Date: click to view message previewRe: "Hot" adding a new node under pgpool-IISample scripts are in the docs. See "online recovery" section in pgpool-en.html. -- Tatsuo Ishii SRA OSS, Inc. Japan > >From what I understand, setting up "online recovery" is pretty > intensive - basically creating scripts that will repopulate the > database - is this correct? Or are there scripts provided that > already will aid in doing "online recovery"? > > On Tue, Sep 2, 2008 at 7:24 PM, Tatsuo Ishii > <ishii-r5vX20e9KLfqq2nvvmkE/A@xxxxxxxxxxxxxxxx> wrote: > >> >From what I understand, pgpool-II has the ability to add a node > >> without restarting pgpool? > > > > Yes. > > > >> I could not find information on how to > >> accomplish this, especially if the IP or host of the node is unknown > >> at the time you start pgpool. What is the correct procedure to > >> accomplish this? > > > > You need to set up the "Online recovery" setting (see docs for more > > info). Add the new node to pgpool.conf. Reload pgpool.conf. Shutdown > > postmaster running on the new node. Do "online recovery". That's it. > > -- > > Tatsuo Ishii > > SRA OSS, Inc. Japan > > Next Message by Date: click to view message previewRe: md5 Authentication problemOn Wed, Sep 3, 2008 at 7:16 PM, Tatsuo Ishii <ishii-r5vX20e9KLfqq2nvvmkE/A@xxxxxxxxxxxxxxxx> wrote: Maybe this should be in the FAQ (I know I have to write but...) Please look into this to know why it's not possible to support md5 in pgpoool: http://lists.pgfoundry.org/pipermail/pgpool-general/2008-August/001171.html --That will certainly help adding it part of FAQ.Regards,Shoaib > Hi All, > > I got a scenario where I am using: > > master slave mode = true > load balancing mode = true > replication mode = false > > Where I got one master and one slave with Slony replication, and both of > those database servers are using md5 authentication. Now I figured out md5 > is currently not supported for pool_hba.conf file. How is it possible to > cater for such a scenario and I dont want to change the authentication > methods for db server. Is there a workaround? > > Also wanted to ask if anyone has an idea to when md5 will be supported in > pool_hba.conf file? > > Regards, > Shoaib _______________________________________________ Pgpool-general mailing list Pgpool-general-JL6EbXIHTPOxbKUeIHjxjQ@xxxxxxxxxxxxxxxx http://pgfoundry.org/mailman/listinfo/pgpool-general Previous Message by Thread: click to view message previewmd5 Authentication problemHi All,I got a scenario where I am using:master slave mode = trueload balancing mode = truereplication mode = falseWhere I got one master and one slave with Slony replication, and both of those database servers are using md5 authentication. Now I figured out md5 is currently not supported for pool_hba.conf file. How is it possible to cater for such a scenario and I dont want to change the authentication methods for db server. Is there a workaround? Also wanted to ask if anyone has an idea to when md5 will be supported in pool_hba.conf file?Regards,Shoaib _______________________________________________ Pgpool-general mailing list Pgpool-general-JL6EbXIHTPOxbKUeIHjxjQ@xxxxxxxxxxxxxxxx http://pgfoundry.org/mailman/listinfo/pgpool-general Next Message by Thread: click to view message previewRe: md5 Authentication problemOn Wed, Sep 3, 2008 at 7:16 PM, Tatsuo Ishii <ishii-r5vX20e9KLfqq2nvvmkE/A@xxxxxxxxxxxxxxxx> wrote: Maybe this should be in the FAQ (I know I have to write but...) Please look into this to know why it's not possible to support md5 in pgpoool: http://lists.pgfoundry.org/pipermail/pgpool-general/2008-August/001171.html --That will certainly help adding it part of FAQ.Regards,Shoaib > Hi All, > > I got a scenario where I am using: > > master slave mode = true > load balancing mode = true > replication mode = false > > Where I got one master and one slave with Slony replication, and both of > those database servers are using md5 authentication. Now I figured out md5 > is currently not supported for pool_hba.conf file. How is it possible to > cater for such a scenario and I dont want to change the authentication > methods for db server. Is there a workaround? > > Also wanted to ask if anyone has an idea to when md5 will be supported in > pool_hba.conf file? > > Regards, > Shoaib _______________________________________________ Pgpool-general mailing list Pgpool-general-JL6EbXIHTPOxbKUeIHjxjQ@xxxxxxxxxxxxxxxx http://pgfoundry.org/mailman/listinfo/pgpool-general Loading Comments...
|
|
