How to use PostgreSQL client applications

PostgreSQL client applications

You have access to a variety of GUI (graphical user interface) client apps for PostgreSQL database management. You may explore databases and execute SQL queries with these client programs, among other things.

pgAdmin III is one of the most well-liked and often used PostgreSQL client software. There are versions of this application available for Linux, Mac OS X, and Microsoft Windows, and it is free to download and use.

Using pgAdmin III

To download pgAdmin III, visit http://www.pgadmin.org/download. Follow the instructions for your computer’s operating system to install the application.

After you have downloaded and installed pgAdmin III, you can use it to manage your PostgreSQL databases. To do this, follow these steps:

1. You must first set up a remote PostgreSQL connection, either by using a SSH tunnel, or by using a direct connection to the Hostvento Hosting server.For detailed information about how to set up a remote PostgreSQL connection, please see this article.
2. After you have established a remote connection to the server, start pgAdmin III.
3. On the File menu, click Add Server.
4. On the Properties tab, in the Name text box, type a name for the server connection. The name can be whatever you want.
5. In the Host text box, type localhost.
6. Confirm that the Port text box value is set to 5432.
7. In the Maintenance DB text box, type the name of the PostgreSQL database that you want to access.
8. In the Username text box, type the username for the PostgreSQL database.
9. In the Password text box, type the username’s password.To have pgAdmin III remember the password, select the Store password check box.
10. Click OK. pgAdmin III connects to the server.
11. In the Object browser pane, click the + icon next to the connection name you specified in step 4. The tree expands to show Databases, Tablespaces, Group Roles, and Login Roles.
12. Click Databases, and then click the name of the database you specified in step 7.
    • To access the PostgreSQL console for the database, on the Plugins menu, click PSQL Console.
    • To run the SQL query tool, on the Tools menu, click Query tool.

Cron jobs do not run on Magento 1.8 after upgrade