PostgreSQL Installation

Send SMS from PostgreSQL (part 1/4)
PostgreSQL Installation

PostgreSQL is a highly stable database management system, which is known for its high level of resilience, integrity, and correctness. It is used as a primary data store or data warehouse for many web, mobile and analytic applications. The Ozeki Gateway works well with it, if you set it up correctly. This video series will guide you through the setup process. The first video on this page is responsible for the installation of the PostgreSQL on your computer.

Video content
1. Download PostgreSQL
2. Install PostgreSQL
3. Install PostgreSQL's ODBC Driver

First, you need to visit the PostgreSQL Download page. Here, make sure to choose the latest version of the program, which will be located on the top of the list. Click the Download button located under the Windows x86-64 title. It will be suitable for your Windows 10. You can see all your options, and the button you need to click on Figure 1.

postgre sqls webpage
Figure 1 - PostgreSQL's webpage

Now your browser will start the download process. This should not take long, but it depends on your internet speed. If it is finished, click the downloaded file and it will open the installer. You can see the process on Figure 2.

start installation from webbrowser
Figure 2 - Start installation from webbrowser

Now you get to choose the installation directory for your program. You can see that on default settings, the program will be installed on the C drive. To change that, you can click on the folder icon on the right. Now you can choose an installation folder, or create a new one. Make sure that you have enough free disk space where the installation location is. If you have the location, please click the Next button.

choose installation directory for the database server
Figure 3 - Choose installation directory for the database server

Now you get to select the different components you wish to install. To have a versatile software, we advise you to select all the possible options. If you have all the boxes ticked, click the Next button to proceed to the next step. You can see all your option on Figure 4.

select components to install
Figure 4 - Select components to install

As you can see on Figure 5, now you get to choose the folder you wish to store your data. If you use the software heavily, the space requirements will grow massively, so make sure to reserve enough space for it. You could change the default storage space with the folder icon on the right.

choose data dir for the postgresql server
Figure 5 - Choose data directory for the PostgreSQL server

Now you have to create a strong password for your PostgreSQL software. Make sure that your password is hard to guess, and that only you know it. This way you can have a secure software which only you could have access to. As you can see on Figure 6, you have to enter the password twice, to avoid typing errors.

specify password for postgresql superuser
Figure 6 - Specify password for PostgreSQL's superuser

In this step, you get to choose the port number of he connection for your server. A port number is a way to identify a specific process to which an Internet or other network message is to be forwarded when it arrives at a server. In this case, the port number should be 5432. Click the Next button if you have the port number typed in. You can see on Figure 7, what you need to type in.

specify postgresql port number
Figure 7 - Specify PostgreSQL's port number

In this step, you get to create a database cluster. A Database Cluster combines multiple servers to a single database. This way, if one server is not capable of managing the dataflow, the other server could help. In case of an error, you could use the cluster server in the downtime of the original serve, so you will have a more stable system. As you can see on Figure 8, all you have to do is provide a location where the database cluster should be.

select database cluster
Figure 8 - Select [Default local] database cluster

Here, you get to see a summery of all the configuration of your server. If you are satisfied with all the properties, click the Next button and it will start the installation process.


read preinstallation summary
Figure 9 - Read pre installation summary

The installation procedure should not take long. On Figure 10, you can see the progress bar, which lets you know that the setup is working. If it is finished, it should automatically jump to the next step.

wait untill the installation is finished
Figure 10 - Wait until the installation is finished

If you see this window, it means that your installation is finished without any error. Make sure to tick in the option below the Launch Stack Builder at exit? title, that you can see on Figure 11. It will launch Stack Builder which will install software necessary for your server.

postgresql database server's installation has been finished
Figure 11 - PostgreSQL database server's installation has been finished

Now you are in Stack Builder. Here you need to choose which software you are installing. As you can see on Figure 12, on the dropdown menu, you will find your options. Please choose the PostgreSQL 10 on port 5432. Click Next if you are ready to proceed to the next step.

install postgresql odbc driver
Figure 12 - Install PostgreSQL's ODBC Driver

here you can choose which applications you wish to install. Make sure to choose at least the psqlODBC(64bit), you can see on Figure 13. It is a powerful drive that lets you connect live to anything that supports ODBC connectivity. It means that you can have access to your database virtually from anywhere through a standard ODBC Driver interface.

select psqlodbc driver
Figure 13 - Select 'psqlODBC' driver

Here, you need to select a destination folder where the installer should download the psqlODBC diver. Make sure that you have enough free space at the location you are choosing, Click the Next button to proceed. You can see the button on Figure 14.

select destination folder to download psqlodbc driver package
Figure 14 - Select destination folder to download 'psqlODBC' driver packages

Now you are at the psqlODBC Setup Wizard. This will guide you through the steps you need to take to have a connection with any ODBC driver interface. Click the Next button the proceed to the next step. You can see the button of Figure 15.

start installler of psqlodbc
Figure 15 - Start the installer of the 'psqlODBC' driver

Now you need to choose a directory for the installation of the driver. Make sure that you have enough space in that directory. If you have the right installation destination, click the Next button to proceed to the next step. You can see the default installation directory on Figure 16.

choose installation dir
Figure 16 - Choose installation directory for the driver

Now you are ready to start the installation. On this step, just click the Next button and the installation will start. You can see this step on Figure 17.

start psqlodbc driver installation
Figure 17 - Start 'psqlODBC' driver installation

Here you only need to wait for the installation to finish. You can supervise the process with the green progression bar. If it is finished, you just need to click the Next button to proceed to the next step.

wait until the driver's installation is finished
Figure 18 - Wait until the driver's installation is finished

This is the final step of the installation is only clicking the Finish button. After it, you have a working copy of PostgreSQL and the psqlODBC driver. You can see the final step on Figure 19.

psqlodbc driver installation is finished
Figure 19 - psqlODBC driver's installation has been finished

We hope that this guide was helpfull. If you have any problem with any of the steps, feel free to contact us at info@ozeki.hu

More information