Monday 30 January 2017

Postgres Installation in Windows Server 2012::

Postgres 9.5.5 Installation  and Table Space creation in Windows Server 2012::
=========================================================

Download Postgres from
https://get.enterprisedb.com/postgresql/postgresql-9.5.5-1-windows-x64.exeRun the windows installer

The default installation path will  be C:\Program Files\PostgreSQL\9.5

The default database created will be 'postgres' with  port '5432'
Set Database password when prompted during the installation.

PgAdmin-3 will be  automatically installed with postgresql.

Once installation is completed try connecting to the database using pgadmin  with the default username and password

For remote connections edit the file
C:\Program Files\PostgreSQL\9.5\data\pg_hba.conf and add the ip as follows based on your network. In my case it is::

host    all             all              192.168.240.0/24                md5

To create table space create folders under D:\
fiscaud
fiscmon
fiscmon
and give all permissions for "Network Service"  for the above folders.

Goto PgAdmin and right click tablespace-->Add Table Space and enter the table space details and path.

No comments:

Post a Comment