Network Computing is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Pervasive Software's Postgres 8

Good


• Reliable even when your system crashes
• Native Windows service support
• Free release under the BSD license

Bad


• Commercial support for only a few recent enterprise-class Linux distributions
• The pgAdmin tends to freeze

Pervasive Postgres 8, starts at $99 annually per server. Pervasive Software, (800) 287-4383. www.pervasive-postgres.com

Once the install wizard did its magic, a helpful configuration tool let me tweak settings for resource usage, query tuning, error reporting, logging and server statistics. This is one feature I wish MySQL had--where MySQL requires manual modification of configuration files, Postgres provides graphical tools to simplify the task.

I created a test user with the "pgAdmin" tool, a GUI for managing users, groups and databases that is much akin to MySQL's Command Center (mysqlcc). With pgAdmin, I was able to do almost everything the command-line tool "psql" would have allowed. Notable exceptions were starting and stopping the database, for which I ran '/opt/ pervasivepostgres/tools/pgAdminIII/bin/pgadmin3'.

  • 1