Re: utf8 vs UTF-8

Hello, Tom Lane wrote: >>  test1  | loc_test | UTF8   | libc | en_US.UTF-8 | en_US.UTF-8 >>  test3  | troels   | UTF8   | libc | en_US.utf8  | en_US.utf8 > > On most if not all platforms, both those spellings of the locale names > will be taken as valid.  You might try running "locale -a"

Re: utf8 vs UTF-8

Hellok Hans Schou wrote:   > test3   | troels   | UTF8 | libc | en_US.utf8 |  en_US.utf8 [...]   how did you create test3? For this example, I used specified it at creation time: CREATE DATABASE test3 TEMPLATE template0 LOCALE 'en_US.utf8'; In the real-world example I'm working wit

utf8 vs UTF-8

en_US.utf8 | en_US.utf8 OS is Ubuntu. -- Kind regards, Troels Arvin

Re: Initiate backup from routine?

Hello, David wrote: /  Are you able to install an untrusted language handler into the database?/ Yes, if need be. -- Regards, Troels Arvin

Initiate backup from routine?

ccess on the DB server (so no sudo option), and we would like to allow this to happen without having to involve a DBA. Is it possible to call pg_dump (or equivalent action) through a procedure/function? -- Regards, Troels Arvin

Calculating vm.nr_hugepages

ormula can I use? It's OK for me for it to be slightly wrong compared to "postgres -C", but if it's wrong, it needs to be slightly higher than what "postgres -C" outputs, so that I'm sure there's enough huge pages for Postgres to be able to use them properly. -- Kind regards, Troels Arvin