> On 09/08/2019 22:16 Coy Hile via dovecot <[email protected]> wrote: > > > Hi all, > > In an earlier thread, > https://dovecot.org/pipermail/dovecot/2019-August/116694.html I got a lot of > useful help about migration. On my older host, everything was static; on the > newer host, I’m storing user information in Postgres. usernames are of the > form <login@REALM>, say ‘[email protected]’ as basically a Kerberos principal, > and authentication and individual lookups work. > > My `users` table looks thus: > > mail=> \d users > Table "public.users" > Column | Type | Modifiers > ----------+------+----------- > username | text | not null > domain | text | not null > password | text | not null > > mail=> > > and contains, as an example: > > username | domain | > password > ------------------+-------------+------------------------------------------------------------------------------------------------------- > [email protected] | coyhile.com | [REDACTED] > (1 row) > > Naively, I’d expect something this to work for the iteration query: > > iterate_query = SELECT username, domain FROM users > > > But, when I do that, I end up > > doveadm backup -D -A -R -f ssh -i id_rsa.dsync imap01.coyhile.com > /opt/local/bin/doveadm dsync-server -A > doveadm([email protected]@coyhile.com): Info: User no longer exists, skipping > [root@81716ec5-bca4-6d53-ed81-bd1a55d46b4f /tmp]# > > Note the extra “@coyhile.com” in there. > > Thanks, > > — > Coy Hile > [email protected]
If your username field already contains domain, you do not need to return domain field separately. It is only needed if your username field only contains local part. Aki
