1

Topic: postgresql tables

==== Required information ====
- iRedMail version: 0.8.5
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Linux/BSD distribution name and version: Ubuntu 12.04
- Related log if you're reporting an issue:
====

I can't find a list of tables used by iRedMail and PGSQL. Does anyone know where I could find the data dictionary of iRedMail?
Thanks

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: postgresql tables

* PostgreSQL data directory: /var/lib/postgresql/9.1/main/
* Configuration directory: /etc/postgresql/9.1/main/
* SQL database "vmail" stores all mail accounts.

You can find more details in iRedMail source code if you want:

- conf/postgresql
- functions/postgresql.sh

3

Re: postgresql tables

Thank you! Your help is very much appreciated!


ZhangHuangbin wrote:

* PostgreSQL data directory: /var/lib/postgresql/9.1/main/
* Configuration directory: /etc/postgresql/9.1/main/
* SQL database "vmail" stores all mail accounts.

You can find more details in iRedMail source code if you want:

- conf/postgresql
- functions/postgresql.sh