Database Engines
You can use PCC to work with database engines that are on your machine or with remote server engines. To work with a remote server engine, you must introduce it to PCC. This procedure is called registering the server.
Your local server is automatically registered to PCC when you install PSQL v12. The local server appears in the PSQL Explorer as the first entry under the Engines node.
►
To register a remote server engine
1
In PSQL Explorer, right-click the top node in the tree (PSQL).
2
Click New > Server.
3
Identify the server that you want to register.
Type the name by which the server is identified on the network or type the IP address of the server.
4
Click Finish.
The server should now appear in the PSQL Explorer window of PCC under the Engines node.
►
To log out from a database engine
These steps do not erase the data or database from the server. A logout only disconnects the communication between the database engine and the PCC on your computer.
1
In PSQL Explorer, expand the Engines node.
2
Right-click the server engine from which you want to log out.
3
Click Logout (name).
Name reflects the name of the user currently logged in to the server through PCC. Name is anonymous if no specific user name and password were provided for a login.
Any nodes expanded for the database engine are collapsed.
►
To reconnect to a database engine
1
In PSQL Explorer, expand the node in the tree for the server engine.
►
To log in to a database engine
1
Right-click the database name in the PCC PSQL Explorer then click Logout (name).
Name reflects the name of the user currently logged in to the server through PCC. By default, name is anonymous, meaning that no specific user name and password were provided for a login.
Any nodes expanded for the database engine are collapsed.
2
Right-click the database name.
3
Click Login.
4
Type a User Name and Password.
You can leave these blank to log in as anonymous.
5
Click OK.
►
To delete a remote database engine
Certain situations, such as a machine no longer in use, can necessitate deleting a remote database engine.
1
In PSQL Explorer, expand the Engines node.
2
Right-click the remote database engine that you want to delete.
3
Click Delete.
Note that the deletion occurs immediately without further prompting.
Database Engine Properties
See Configuration.