Re: Redundant Database, Pgsql ?

2023-02-22 Thread Marcus Jodorf
On 2/22/23 11:29, David White wrote: If I understand open source Postgres correctly, though, this setup basically requires that the application be read-only, or at least be intelligent enough not to attempt to write to a host if it has failed over to it, right? Don't you have to have human int

Re: Redundant Database, Pgsql ?

2023-02-21 Thread Marcus Jodorf
On 2/21/23 18:04, Lars Schotte wrote: Yes, that looks nice, I am going to try that too. Because every other option is based on some other software, like relayd or nginx, it is all possible, but adds complexity. The best would be to have it inside connection string. /etc/dovecot/dovecot-sql.c

Re: [Dovecot] Custom sql query for keeping quota with dict-sql

2011-06-04 Thread Marcus Jodorf
Marcin Mirosław wrote: > In config snip from Marcus i can't find definition of "quota", what kind > of backend are you using? maildir? Sorry forgot that. I just use maildir quota. plugin { quota = maildir:User Quota } Timo already wrote about the problem with dict-quota and postgres.

Re: [Dovecot] Custom sql query for keeping quota with dict-sql

2011-06-02 Thread Marcus Jodorf
Duane Hill wrote: Am 02.06.2011 um 18:40 schrieb Duane Hill: >> I read wiki a little and it looks i can't define own sql queries, they >> appear to be hardcoded. Am i wrong? Is it possible to write own queries >> to get/set quota using such table schema? No problem. > I'm using mysql here with