Jump to content
The Uniform Server Community
Sign in to follow this  
Nicero

How to install PostgreSQL

Recommended Posts

If you wish to install PostgreSQL and make it work with Uniform Server you may find useful the following guidelines.

 

1. Stop UniformServer (Apache and MySql) from running

 

2. Download PostgreSQL latest stable release for Windows (these guildelines apply to version 9.5.3)

 

3. Download PhpPgAdmin (which is the PhpMyAdmin for PostgreSQL)

 

4. Launch PostgreSQL installer and choose the Uniform 'core' folder (\UniServerZ\core) as PostgreSQL installation folder. Default username is postgres.

 

5. Once installed you may rename the folder with a shorter name for ex. 'postgres'

 

6. Open httpd.conf (\[uniformServer_path]\core\apache2\conf) and add the following line to the and of the file:

 

LoadFile "\[uniformServer_path]\core\[postgres_path]\bin\libpq.dll"

 

7. Unzip PhpPgAdmin into the Uniform Server www path

 

8. If you wish, rename PhpPgAdmin folder to a shorter name

 

9. Open PhpPgAdmin configuration file config.inc.php (PhpPgAdmin/conf/) and change the two following lines as below:

 

$conf['servers'][0]['host'] = 'localhost';
$conf['extra_login_security'] = false;

 

10. Enable PostgreSQL PHP extensions using the Uniform Server systray console:

 

Menu PHP -> Edit Basic and Modules -> PHP Modules Enable/Disable

 

php_pdo_pgsql.dll
php_pgsql.dll

 

11. Start PostgreSQL. PostgreSQL must be started and stopped using its console. Go to

 

\[uniformServer_path]\core\[postgres_path]\scripts\

 

and start PostgreSQL:

 

serverctl.vbs start

 

serverctl.vbs has other parameters: serverctl.vbs reload|wait|start|stop

12. Start Apache as usual from the Uniform console.

 

13. Open the browser and type:

 

http://localhost/[phppgadmin_path]/

 

Use the default postgres user chosen during installation or any other user set and the chosen password to login in PhpPgAdmin.

 

These installation guidelines work properly even if you are keeping all Uniform Server installation and your work on a portable USB harddisk as I do. In this case you may delete from your Windows Start menu all the references to the PostgreSQL installation.

 

 

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...