This article will list some of the most popular postGreSql tools out there and how to use one of them with your Opencart Mysql Database.
What is postGreSql?
PostGreSql is defined as an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards-compliance.
PostgreSQL is cross-platform and runs on many operating systems including Linux, FreeBSD, Solaris, and Microsoft Windows. Mac OS X, starting with OS X 10.7 Lion, has the server as its standard default database in the server edition, and PostgreSQL client tools in the desktop edition. The vast majority of Linux distributions have it available in supplied packages.
Simply put, it will be an easy way to connect to your Opencart DB where by being able to work with the database content. By far, the most popular postGreSql client out there is NaviCat. http://www.navicat.com/products/navicat-for-postgresql . You choose the correct operating system for you:
Setting up for Remote Mysql in cPanel
Your database may very well not be set up to accept remote connections. To do this, login to cPanel and scroll to your Database Block and click on Remote Mysql:
You will need to add the IP address of the person trying to connect. That’s you, or someone else. You’ll also need to get the server’s secondary IP address as well. Once the host is added then you can move on to connecting with NaviCat.
Using NaviCat PostGreSql
Download the free trial and install it on your Windows/Mac Machine. For this demo we will be using Windows 7. Once it is installed, load it up. Once loaded click on the Connection button. You will get a screen that looks somewhat like this:
Now fill out the appropriate information and click on Test Connection. Once you connect then you are ready to go!