1 Topic by bravonet

  • bravonet
  • Member
  • Offline
  • Registered: 2013-07-30
  • Posts: 2

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 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,091

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 Reply by bravonet

  • bravonet
  • Member
  • Offline
  • Registered: 2013-07-30
  • Posts: 2

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