Jump to content

Administration

Postgres Plus

Postgres Studio is a robust graphical administration console, built on the widely admired pgAdmin foundation. Postgres Studio is a cross-platform tool that speeds application development and administration. From writing simple SQL queries to developing and debugging complex applications, Postgres Studio is a powerful toolset that runs natively on Linux, Mac, and Windows. With Postgres Studio, developers and DBAs can:

  • Build, administer, and deploy database tables and views, stored procedures, triggers, and more
  • Dynamically debug stored procedures
  • In a single windows, browse databases from multiple sources, including Postgres Plus, PostgreSQL and MySQL

Postgres Studio includes native database access (no ODBC layer required) and enables a DBA to complete routine maintenance including:

  • Configuration file editing
  • Auto-vacuum management
  • Logfile browsing
  • Lock analysis
  • Server status and process analysis
  • SQL/shell/batch job scheduling

Postgres Plus Advanced Server

Postgres Plus Advanced Server also includes EDB*Plus. This feature is analogous to SQL*Plustm from Oracle and allows many command line SQL scripts written for SQL*Plus to run unchanged on Postgres Plus Advanced Server.

Next (Cloud Edition)