Chapter 15. EDB-Studio
- Table of Contents
- 15.1. Connect to Server
- 15.2. Change Password
- 15.3. EDB-Studio Query Tool
- 15.4. Using EDB-Studio Templates
- 15.4.1. New Procedure Template
- 15.4.2. New Function Template
- 15.4.3. New Triggers Template
- 15.5. EDB-Studio Data Export
- 15.6. Edit Enterprise Tool
- 15.7. View Data Options
- 15.8. Maintain a Database Object
- 15.9. Backup
- 15.10. Restore
- 15.11. Grant Wizard
- 15.12. Database Server Status
- 15.13. EDB-Studio Options
- 15.14. EDB-Studio Options - General
- 15.15. EDB-Studio Options - Preferences
- 15.16. EDB-Studio Options - Query
- 15.17. EDB-Studio Options - Logging
- 15.18. Guru Hints
- 15.18.1. Primary Keys
- 15.18.2. Foreign Key Covering Indexes
- 15.19. EDB-Replication Support
- 15.19.1. Step 1 - Start up and connect to EDB instances
- 15.19.2. Creating an EDB-Replication Cluster on Master and Slave Node(s)
- 15.19.3. Creating Replication Set
- 15.19.4. Adding Tables and Sequences to your Replication Set
- 15.19.5. Specifying Path/Connectivity Information
- 15.19.6. Start up EDB-Replication Instances
- 15.19.7. Creating a Subscription on the Master
This part covers the basics of how to use EDB-Studio, the DBA tool that is shipped along with EnterpriseDB.
15.1. Connect to Server
Use this dialog to add a new server connection to the root of the EDB-Studio tree.
The service field specifies parameters to control the database service process. Its meaning is operating system dependent.
If EDB-Studio is running on a Windows machine, it can control the edb-postmaster service if you have enough access rights. Enter the name of the service. In case of a remote server, it must be prepended by the machine name. EDB-Studio will automatically discover services running on your local machine.
If EDB-Studio is running on a Unix machine, it can control processes running on the local machine if you have enough a ccess rights. Enter a full path and needed options to access the pg_ctl program. When executing service control functions, EDB-Studio will append status start stop keywords to this. Example:
/usr/local/enterprisedb/bin/pg_ctl -D /data/enterprisedb
If the password for that server is empty, you can unselect the "need password" option. When connecting to the database, the password won't be required from you any more. For security reasons, passwords are not stored by EDB-Studio.
This dialog can be launched at a later time to correct or add parameters by executing "properties" when the server is selected.
15.1.1. Control Server
If you entered correct data in the Connect to Server dialog box, EDB-Studio will check if the service is running, and will allow to start and stop the service.