What do you like best?
- Extensive documentation
- Multiple deployment models: Desktop mode, using a purpose built runtime and server mode, supporting multiple users over the web
- Tools: Powerful query tool with colour syntax highlighting, fast datagrid for display/entry of data, graphical query plan display, grant Wizard for rapid updates to ACLs and supporting pl/pgsql and edb-spl
- Routine maintenance: Auto-vacuum management, monitoring dashboard, backup, restore, vacuum and analyze on demand and SQL/shell/batch job scheduling agent
- Create, view and edit all common PostgreSQL objects: Objects are displayed with their SQL definition, and a user friendly list of properties. Dependent, and dependency objects may also be browsed, and object statistics viewed where appropriate.
What do you dislike?
- The windows animations slow thing's down to much.
- It's a single window application and it doesn't allow me to drag windows
around on my desktop, hide the windows I don't need etc.
- Some screens appear slow to me with a 'loading' icon, even without the windows it takes took long to 'draw' the screen. Where in pgAdmin 3 a lot of items are near instance, in pgAdmin4 it takes time to display.
- Clicking on a table in the tree doesnt do anything in pgAdmin4, in pgAdmin3 it shows me the table definition.
Recommendations to others considering the product
PgAdmin is a good tool to use if you don't have experience with command line or if you prefer to work with a graphical user interface. You can made almost all that you need.
What business problems are you solving with the product? What benefits have you realized?
In my company we can made easy and fast query for any requirement that any instance of the company made. It is designed for viewing, browsing, querying and developing complex PostgreSQL databases.
Also we can store information of vital importance for the company with the security of a robust backup and recovery system that allows us to safeguard our information