Update.
Because postfix delivers messages by username I had to switch it to:
default_mail_env = maildir:/var/spool/virtual_mailboxes/%d/%n/

Otherwise ti would create mailboxes in the from
/var/spool/virtual_mailboxes/domain/blah@domain/ (not very useful)

Thanks again Johannes



On 12/26/05, David Bain <david.bain@alteroo.com> wrote:
Surely enough, changing my to default_mail_env
default_mail_env = maildir:/var/spool/virtual_mailboxes/%d/%u/

 Did the trick... thanks Johannes

On 12/25/05, Johannes Berg < johannes@sipsolutions.net> wrote:
On Sun, 2005-12-25 at 10:13 -0500, David Bain wrote:

> What would the query look like in my dovecot-pgsql.conf file to retrieve the appropriate INBOX information?
>
> mine currently looks like this.
> user_query = SELECT '/var/spool/virtual_mailboxes/'||home AS home, uid, gid FROM users WHERE userid = '%u'

never mind my question. What does the userid field in the database look
like? The full email address? Then this default_mail_env should work:

default_mail_env = maildir:/var/spool/virtual_mailboxes/%d/%u/

johannes


-----BEGIN PGP SIGNATURE-----
Comment: Johannes Berg (SIP Solutions)

iQIVAwUAQ6667KVg1VMiehFYAQJwQQ/6AjC0Yz/iOlCU62FIB/xXilL8RWrBydqB
e5EIetk3PildJMiV2oXpdF2lACp8UBaUdpIUqOZcSG2fE9sygUC5ZmeL9YEsVF3+
M3C3LlwBSnUcGQV01xpBSx7+/0kIwQSkOyunztLwMtH1am1IfR7n7my/8MCp2S9j
8paI7T+Q4RMxNENNadtmsp+S+BWAxjWFWGiuYlfaMYnCKmU8uCYRkKB3hBxKg8dF
vwzeYYOroJKgQ76baaxdc0bmF0hE58r5HAow8f024FHXJbp5fduJ0inTNav8euIN
pXsKX3gvoda6vQAh7Mw3O1uoYWpyANr4Aj0AFdVa8z+NZaAQPvlI82V5IPPi5wQv
CXZizWEGuPnT4TI6xu90mk99h92L14OQaHaU4ZcKRwHVw4P36Quzs5eGdeQfQEsC
8IRuG6q/fLWZgnxdl3PL5GvED0NhdnHUx/6z4GYJkeXTYBZ+7fZVL2gVc2JZ6EvW
8uGtPpC5ZYpZSQ5+sj7d2dc3IflloynXRMbYRvWKPUKdqV/dPxI3DGdt6ErojEeb
jj64ugzXSMW/ubaM4SIHlyXRtsp/xzKZVcuG+DIojnKvv/vOpn22GRAYKNhNZGC7
r5KEzG0mzjzApJihmaPuluMtXri71gRyBgMFevuQTd3IDck8eB5gc1JCsSmZmls7
+mAmB2PzAnA=
=mQY/
-----END PGP SIGNATURE-----