User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
how_to:install_postgresql_manually [2021/03/08 10:46]
paul removed
— (current)
Line 1: Line 1:
-======Install PostgreSQL manually====== 
-VPOP3 version 3.x and later require a PostgreSQL installation to be able to work. For most users, the installer will automatically install PostgreSQL on the same PC as VPOP3 and configure it appropriately,​ but this article explains how to manually install and configure PostgreSQL for advanced users who may want install it differently (eg on a different PC or drive) or if you are having problems using the normal installer. 
-VPOP3 versions 3 or 4 require PostgreSQL 8.3 or later. VPOP3 version 5 requires PostgreSQL 9.1 or later. So, it may be best to install PostgreSQL 9.1 if you are installing manually, to avoid the need for a database server upgrade if you upgrade to VPOP3 version 5 later. (There are no known incompatibilities between VPOP3 versions 3-4 and PostgreSQL 9.1 - later versions of PostgreSQL may introduce incompatibilities) 
-Download the relevant version of PostgreSQL from http://​​products-services-training/​pgdownload#​windows - note that VPOP3 will work with either the 32 or 64 bit versions of PostgreSQL, although the standard distribution distributes the 32 bit version. You can use whichever version you wish. 
-Once you have downloaded the installer run it 
-  - For the **Installation Directory**,​ we recommend you use the **pgsql** folder of the VPOP3 installation directory - e.g. ''​c:​\VPOP3\pgsql''​ 
-  - The **Data Directory** will usually choose the correct folder which is the **pgsql\data** folder of the VPOP3 installation directory - e.g. ''​c:​\VPOP3\pgsql\data''​ 
-  - When the installer asks for the **Password** enter a password //you will remember//. The default we use is ''​pgsqlpass'',​ but obviously you may use any password you prefer. However, if you forget the password you may have big problems in the future, so make sure you do not forget it! 
-  - The **Port** will default to ''​5432''​. We would recommend leaving it at that unless you have other software using that port on this computer (e.g. another PostgreSQL installation) 
-  - For the **Locale** choose ''​C''​ 
-When the installation has finished, uncheck ''​Launch Stack Builder on Exit''​ and Finish 
-Finally, you need to create a user and database for VPOP3 to use. 
-  - Go to Start -> Programs -> PostgreSQL 9.1 -> pgAdmin III (assuming you installed PostgreSQL 9.1. If you installed a different version, the path may be different) 
-  - Right-click the **PostgreSQL Database Server 9.1 (Local)** in the left pane, and choose **Connect** 
-  - In the **Connect to Server** box enter the password you defined in step 3 above (eg ''​pgsqlpass''​) and press **OK** 
-  - expand the tree in the left pane 
-  - Right-click on Login Roles and choose **New Login Role** 
-  - In the **Role name** box enter ''​vpop3''​ 
-  - Go to the **Definition** tab 
-  - In the **Password** and **Password (again)** boxes enter ''​vpop3pass''​ 
-  - Press **OK** 
-  - Right-click on **Databases** and choose **New Database** 
-  - In the **Name** box enter ''​vpop3''​ 
-  - In the **Owner** box choose ''​vpop3''​ 
-  - Go to the **Definition** tab 
-  - In the **Template** box, choose ''​Template0''​ 
-  - In the **Encoding** box choose ''​SQL_ASCII''​ 
-  - Press **OK** 
-  - Close down pgAdmin III because everything is now configured correctly 
-[[manually_installing_the_postgresql_database_server|See video tutorial]]