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.
=========================================================
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