Collapse AllExpand All

12. PostgreSQL Security

Security is a critical part of database administration. After installing xTuple, the following steps (described in detail below) should be taken to prevent intruders from accessing your data.

  1. Update your pg_hba.conf file

  2. Enable enhanced authentication

  3. Enable enhanced authentication

  4. Use strong passwords

  5. Require new passwords periodically

  6. Remove unused accounts

The first action, updating your pg_hba.conf file, is the only one that requires technical knowledge. You may be able to update the file by following the directions below. If you are unsure of how to change, or uncomfortable with changing the file, you may need to contact an xTuple partner, or xTuple directly, to assist with the update. Normal hourly consulting fees will apply.

If you have any questions, please contact xTuple.