Article - CS226826
PostgreSQL Tool Triage
Modified: 21-Jan-2016
Applies To
- ThingWorx Platform 6.5
Description
psql terminal:
The psql client is a command-line client distributed with PostgreSQL, often called as interactive terminal. Psql is a simple yet powerful tool with which you can directly interface with the PostgreSQL server. The psql client comes default with the PostgreSQL database.
Key features:
pgAdmin III:
pgAdmin III is an open source administration and development tool for PostgreSQL database. It delivers the needs of both admin and normal users from writing simple SQL queries to developing complex databases.
Key features:
phpPgAdmin:
phpPgAdmin is a web-based client for managing PostgreSQL databases. It provides the user with a convenient way to create databases, create tables, alter tables and query the data using SQL.
Key features:
TeamPostgreSQL:
TeamPostgreSQL is a browser-based tool for PostgreSQL administration. Using TeamPostgreSQL, database objects can be accessed from anywhere in the web browser.
Key features:
pgBadger is a PostgreSQL log analyzer for generating reports from the PostgreSQL log files. It is built in Perl language and uses a javascript and bootstrap libraries. Often seen as a replacement for pgfouine log analyzer.
Key features:
Git download: https://github.com/dalibo/pgbadger/releases
PostgreStats:
Postgrestats is a software that has automated scripts to easily view statistics such as commits, rollbacks, user inserts, updates and deletes in a time-based intervals. Postgrestats gets installed and executes on the database server, it customizes the main conf file. Postgrestats also provides an enterprise application for Replication mode and High Availability.
Key features:
Slemma:
Slemma is a collaborative, data visualization tool for PostgreSQL database. Slemma allows database connections with a near to one-click integration and can generate a dashboard from files. Slemma comes with a commercial license with a $29 per user per month pricing.
Key features:
Ubiq:
Ubiq is a web-based buisness intelligence and reporting tool for PostgreSQL server. Ubiq creates reports and online dashboards, providing the feature to export in multiple formats. Ubiq is distributed with a commercial license.
Key features:
The psql client is a command-line client distributed with PostgreSQL, often called as interactive terminal. Psql is a simple yet powerful tool with which you can directly interface with the PostgreSQL server. The psql client comes default with the PostgreSQL database.
Key features:
- Issue queries either through commands or from a file
- Provides shell-like features to automate tasks
For more information, refer http://www.postgresql.org/docs/9.5/static/app-psql.html
pgAdmin III:
pgAdmin III is an open source administration and development tool for PostgreSQL database. It delivers the needs of both admin and normal users from writing simple SQL queries to developing complex databases.
Key features:
- Open source
- Supports all OS platforms
- Provides Graphical User Interface (GUI)
- No additional drivers are required
- Supports more than 30 different languages
phpPgAdmin:
phpPgAdmin is a web-based client for managing PostgreSQL databases. It provides the user with a convenient way to create databases, create tables, alter tables and query the data using SQL.
Key features:
- Open source and supports PostgreSQL 9.x
- Requires webserver
- Administer multiple servers
- Supports the slony master-slave replication engine
TeamPostgreSQL:
TeamPostgreSQL is a browser-based tool for PostgreSQL administration. Using TeamPostgreSQL, database objects can be accessed from anywhere in the web browser.
Key features:
- Open source and cross-platform support
- Supports SSH for both the web interface and the database connections
- GUI with tabbed SQL editors
Monitoring Tools
pgBadger:pgBadger is a PostgreSQL log analyzer for generating reports from the PostgreSQL log files. It is built in Perl language and uses a javascript and bootstrap libraries. Often seen as a replacement for pgfouine log analyzer.
Key features:
- Open source community project
- Autodetects postgreSQL log file formats (stderr, syslog or csvlog)
- Provides SQL queries related reports and statistics
- Can also set limits to only report errors
- Generates Pie charts and Time based charts
Git download: https://github.com/dalibo/pgbadger/releases
PostgreStats:
Postgrestats is a software that has automated scripts to easily view statistics such as commits, rollbacks, user inserts, updates and deletes in a time-based intervals. Postgrestats gets installed and executes on the database server, it customizes the main conf file. Postgrestats also provides an enterprise application for Replication mode and High Availability.
Key features:
- Open source
- Easy to setup
- Take a snapshot report based on time intervals
- Optional email-on-update
- Text file Data storage
- Also provides enterprise application, PostgreStats Enterprise
Slemma:
Slemma is a collaborative, data visualization tool for PostgreSQL database. Slemma allows database connections with a near to one-click integration and can generate a dashboard from files. Slemma comes with a commercial license with a $29 per user per month pricing.
Key features:
- Create charts and interactive dashboards by selecting tables
- Non-developers can easily create visualizations (with no coding)
- Email dashboards automatically to clients or your entire team
Ubiq:
Ubiq is a web-based buisness intelligence and reporting tool for PostgreSQL server. Ubiq creates reports and online dashboards, providing the feature to export in multiple formats. Ubiq is distributed with a commercial license.
Key features:
- Drag & drop interface to create interactive charts, dashboards and reports
- Apply powerful filters and functions to the data
- Share your work and schedule email reports
This is a printer-friendly version of Article 226826 and may be out of date. For the latest version click CS226826