PostgreSQL is the database that is included with ZENworks. As an embedded database it is intended to be used by smaller organizations and in test environments up to 5000 devices. If PostgreSQL is installed on a separate database server it will support environments up to 20,000 devices. For organizations exceeding 20,000 managed devices, an MS SQL server or Oracle server implementation is highly recommended. If you start with a PostgreSQL database and find that your environment has outgrown it, ZENworks includes a database migration tool that allows you to easily upgrade from PostgreSQL to either Oracle or MS SQL.
This chapter provides best practices when using PostgreSQL with ZENworks. For detailed PostgreSQL documentation and information, visit the PostgreSQL website.