Thread: locale per db / table / column
Hi All I'm a new Postgres User and because I'm from Israel I use the Hebrew set in locale. from reading the documents I realized that all the databases created under directory that was created with initdb while locale was set to something will be sorted by this locale with no way to set it to other locale in the future. I hope I'm wrong as some of my db need to be only English and some Hebrew. If I'm wrong please explain, if not, is there a way to go around this problem ? maybe by making more then one data directory ? can one postmaster run on more then one data dir ? -------------------------- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 http://sites.canaan.co.il --------------------------
Ben-Nes Michael writes: > >from reading the documents I realized that all the databases created under > directory that was created with initdb while locale was set to something > will be sorted by this locale with no way to set it to other locale in the > future. Correct. > If I'm wrong please explain, if not, is there a way to go around this > problem ? maybe by making more then one data directory ? Yes. > can one postmaster run on more then one data dir ? No, but you can start more than one postmaster, each on different data directories. -- Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
What is the down side of using more then one postmaster process ? If I activate more then one postmaster does that mean that each postmaster will listen to a unique port ? or is it like apache that you can run few httpd process that's listen to the same port (80 most of the time) ? > Ben-Nes Michael writes: > > > >from reading the documents I realized that all the databases created under > > directory that was created with initdb while locale was set to something > > will be sorted by this locale with no way to set it to other locale in the > > future. > > Correct. > > > If I'm wrong please explain, if not, is there a way to go around this > > problem ? maybe by making more then one data directory ? > > Yes. > > > can one postmaster run on more then one data dir ? > > No, but you can start more than one postmaster, each on different data > directories. > > -- > Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter > > -------------------------- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 http://sites.canaan.co.il --------------------------
Ben-Nes Michael writes: > What is the down side of using more then one postmaster process ? More resource usage. > If I activate more then one postmaster does that mean that each postmaster > will listen to a unique port ? Yes, you will have to pick different ports. -- Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter