This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
how_to:install_postgresql_manually [2012/11/27 16:51] – paul | how_to:install_postgresql_manually [2021/03/08 10:46] (current) – removed paul | ||
---|---|---|---|
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, | ||
- | |||
- | 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:// | ||
- | |||
- | Once you have downloaded the installer run it | ||
- | - For the **Installation Directory**, | ||
- | - The **Data Directory** will usually choose the correct folder which is the **pgsql\data** folder of the VPOP3 installation directory - e.g. '' | ||
- | - When the installer asks for the **Password** enter a password //you will remember//. The default we use is '' | ||
- | - The **Port** will default to '' | ||
- | - For the **Locale** choose '' | ||
- | |||
- | When the installation has finished, uncheck '' | ||
- | |||
- | 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 '' | ||
- | - expand the tree in the left pane | ||
- | - Right-click on Login Roles and choose **New Login Role** | ||
- | - In the **Role name** box enter '' | ||
- | - Go to the **Definition** tab | ||
- | - In the **Password** and **Password (again)** boxes enter '' | ||
- | - Press **OK** | ||
- | - Right-click on **Databases** and choose **New Database** | ||
- | - In the **Name** box enter '' | ||
- | - In the **Owner** box choose '' | ||
- | - Go to the **Definition** tab | ||
- | - In the **Template** box, choose '' | ||
- | - In the **Encoding** box choose '' | ||
- | - Press **OK** | ||
- | - Close down pgAdmin III because everything is now configured correctly | ||
- | |||
- | [[manually_installing_the_postgresql_database_server|See video tutorial]] | ||
- | |||