But enough about non-Postgres topics on this list :) To go with
Postgres, on a hunch I'd try Patroni first: it does a lot of the
advanced failover stuff, has a great track record, and supposedly runs
on BSD: https://openports.pl/path/databases/patroni
Cheers
Christian
--
Christian Ra
On 10.02.23 04:48, Laurenz Albe wrote:
On Fri, 2023-02-10 at 03:20 +0100, Chris wrote:
In Solr I was using ngrams and customized the
TokenizerFactories until more or less only whitespace was as separator,
while [.:-_\d] remains part of the ngrams. This allows to search for
".12.255/32" or "xzy-e
> The reported error looks like this:
>
> postgres@dellstore ERROR: new row for relation "test_customers"
> violates check constraint "check_age"
..
>
> This errors appears in the serverlog which has many format and
> forwarding options, you can read about them here:
On 03.10.
lastname, age) values ( 'Jimmy', 'Schmoe', 15);
This errors appears in the serverlog which has many format and
forwarding options, you can read about them here:
https://www.postgresql.org/docs/current/runtime-config-logging.html
Cheers
Christian
--
Christian Ramseyer, netnea ag
Network Management. Security. OpenSource.
https://www.netnea.com
on the "andere Marken" uppercase M. Try this:
select id,
marke.name from marke
ORDER BY
left(marke.name,1) <> left(lower(marke.name),1),
marke.name
Fiddle:
http://sqlfiddle.com/#!17/d9d83e/9
Cheers
Christian
--
Christian Ramseyer, netnea ag
Network Management. Security. OpenSource.
https://www.netnea.com
e fantastic https://explain.depesz.com/
This will turn the somewhat hard-to-understand explain output into a
nice colored structure. If it's not obvious from the orange-reddish
boxes where the slowness comes from, please post the link here and
somebody will certainly have some advice.
Cheers
Chri
,Class VIII
|--|
|Class VIIx,Competitive Exam22,Class VIIIabc,Classx
|Class VIIx,Competitive Exam22,Class
VIIIabc |
(I cut some columns at the start to better fi
On 06.05.20 13:48, Guillaume Lelarge wrote:
> Le mer. 6 mai 2020 à 04:18, Christian Ramseyer <mailto:r...@networkz.ch>> a écrit :
>
> Here is a quick, rough example with still some blanks to fill in - I put
> it on github for readability:
> <htt
On 06.05.20 02:00, Tom Lane wrote:
> Christian Ramseyer writes:
>> Can I somehow influence the client:UTF8->server:LATIN1 character set
>> conversion so that instead of failing, it inserts an invalid codepoint
>> character, the utf8 hex bytes as string, drops the charac
ly used etc. But in cases of abnormal
growth that gets worse and worse over time, the above is the first thing
to try in my experience.
Cheers
Christian
--
Christian Ramseyer, netnea ag
Network Management. Security. OpenSource.
https://www.netnea.com
le xxx nologin", but you might add some features
like connecting to the primary server if fail2ban triggered on the
standby. Also I'm not sure if setting nologin is the best way to disable
an account, but I'm sure somebody on here could tell you.
Cheers
Christian
--
Christian
Hello list
I'm slowly converting all of our databases from Postgres 9 and LATIN1 to
Postgres 12 and UTF8, one by one.
I was wondering if there is a solution for this issue: if a database
that is still latin1 has a postgres_fdw foreign table onto a converted
utf8 database, and somehow a character
On 22.04.20 21:10, Christian Ramseyer wrote:
>
> I see that in pgjdbc there are additional options for targetServerType =
> any, primary, secondary, preferSlave and preferSecondary[2]. However
> this seems to be java-specific and not implemented in libpq? Is there a
> way to get th
Hi
I'm setting up a new environment with a primary/hot standby replication
pair.
For read-only clients, I have found the host=host1,host2 connection
string[1] which allows a connection when any one of the servers is up.
However I'm unsure how to achieve something similar for read/write
clients.
14 matches
Mail list logo
