[Dovecot] PostgreSQL user database

[Andrew Hutchings]

Hi Marco,

I cheat by doing:

user_query = SELECT '/mailboxes/%d/%n' as home, uid, gid FROM users 
WHERE username = '%u'

I'm using MySQL, but I think the postgresql should be the same.

Regards
Andrew

Marco Herrn wrote:

>Hi,
>
>I am using postgresql for my password and user databases. The problem
>is, that the information needed in the user database is held in more
>than one table. But it seems to me that dovecot expects to get all the
>information for mailbox, uid, gid and home in _one_ query. Is there a
>way to get around this? Maybe even getting some of this information by
>another way than pgsql (this is more a rethorical question, since I
>have this information in the DB, but sometimes it is useful to get,
>for example the location of the mailbox by another way than the uid
>and gid).
>
>But my primary question is if I can set these fields in different
>queries.
>
>Regards
>Marco
>  
>


-- 
Andrew Hutchings
Systems Operator / Developer / Linux Guru
Netserve Consultants Ltd.
http://www.domaincity.co.uk/