Re: [ADMIN] Refined LC_COLLATE or multiple database clusters? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [ADMIN] Refined LC_COLLATE or multiple database clusters?
Date
Msg-id 20467.1086789212@sss.pgh.pa.us
Whole thread Raw
List pgsql-hackers
Grega Bremec <grega.bremec@noviforum.si> writes:
> Collate order for those databases, however, needs to be different.

If you need multiple LC_COLLATE settings then you have to run multiple
postmasters.  There is no other solution today, nor likely to be one in
the near future.

> Also, running several postmasters on this same machine is not an option,

Sure it is.  Just don't go overboard with the shared_buffers settings.
Let the kernel do the bulk of the buffering and you'll be fine.

            regards, tom lane

pgsql-hackers by date:

Previous
From: pgsql@mohawksoft.com
Date:
Subject: Re: Improving postgresql.conf
Next
From: Tom Lane
Date:
Subject: Re: Question regarding dynamic_library_path