Re: Case Insensitive

Hi Sridhar, There are a few workarounds available, hope this will help you. 1) Use the citext extension 2) Use ILIKE instead of LIKE 3) Use Postgres lower() function 4) Add an index on lower(ename) Thanks & Regards, *Shreeyansh DBA Team* www.shreeyansh.com On Thu, Mar 28, 2019 at 1:5

Re: Multiple postgresql clusters with same version and separate binaries

Hi Erika, You can create the different version services and use these services for PostgreSQL start/stop. ex. service postgresql-10 start service postgresql-9.6 start Thanks & Regards, *Shreeyansh DBA Team* www.shreeyansh.com On Fri, Jan 4, 2019 at 7:51 PM Erika Knihti-Van Dries

Re: Fwd: postgres instalation

While you installing PostgreSQL via Source then by default it will contain only (Bin, lib, include, share) if you want to install the documentation (HTML and man pages) use following command:- make install-docs. On Wed, Feb 7, 2018 at 9:11 AM, Adrian Klaver wrote:

Re: PostgreSQL Active-Active

You can achieve this HA with forward and backward reverse synchronous streaming replication with 3 nodes automatic failover with pgpool in PostgreSQL. There is always downtime but it should not be more than a minute its depends on your hardware and network bandwidth speed availability. -- [image