Before installing FUJITSU Software Enterprise Postgres
- [On both nodes] Install LifeKeeper
- Create a Communication Path
- Create/extend an IP resource (optional)
- Create/extend a volume resource
Installing FUJITSU Software Enterprise Postgres
[On both nodes] Run the FUJITSU Software Enterprise Postgres installer to install FUJITSU Software Enterprise Postgres.
After installing FUJITSU Software Enterprise Postgres
- [On both nodes] Add PATH
c:\Program Files\Fujitsu\fsepv14server64\bin c:\Program Files\Fujitsu\fsepv14server64\lib
- Switchover a volume resource to a secondary node
- [On a secondary node] Create a folder for an instance (use inst1 as instance name)
mkdir d:\database\inst1
- [On a secondary node] Grant Administrator access to the folder for the instance
- [On a secondary node] Create the instance
initdb -D D:\database\inst1 --lc-collate="C" --lc-ctype="C" --encoding=UTF8
- [On a secondary node] Register the instance with Windows Services
pg_ctl register -N "inst1" -U Administrator -P <password> -D D:\database\inst1
- [On a secondary node] Add
-o "-p <port number>"
to the inst1 service startup options - [On a secondary node] Add a PostgreSQL compatible registry entry
reg add HKLM\SOFTWARE\PostgreSQL\Installations\<Any name> /v "Base Directory" /t REG_SZ /d "<FUJITSU Software Enterprise Postgres installation folder>"
- [On a secondary node] Start the inst1 service and check connectivity
sc start inst1 sc query inst1 psql -d postgres -l
- [On a secondary node] Stop the inst1 service
sc stop inst1 sc query inst1
- Switchover the volume resource to the primary node
- [On a primary node] Grant Administrator access to the folder for the instance
- [On a primary node] Delete all files under the instance folder
- [On a primary node] Create the instance
- [On a primary node] Register the instance with Windows Services
Specify the same username and password as those registered on the secondary node. - [On a primary node] Add
-o "-p <port number>"
to the inst1 service startup options - [On a primary node] Add a PostgreSQL compatible registry entry
- [On a primary node] Edit postgresql.conf of inst1 and add the following lines
listen_addresses = '*' port = 27500
- [On a primary node] Edit pg_hba.conf of inst1 and add the following lines
host all all 10.0.0.0/16 md5
- [On a primary node] Start the inst1 service and check connectivity
Create a PostgreSQL resource
- Create/extend a PostgreSQL resource
- Create a dependency between the PostgreSQL resource and the IP resource (only if the IP resource is created)
Configuration required for client connections
- [On both nodes] Permit the port number used in the firewall configuration (27500 in the above postgresql.conf configuration)
- [On a primary node] Set password for MD5 connection
psql -d postgres ALTER ROLE "Administrator" PASSWORD '<password>';
<password> is the password specified when registering the instance to the Windows service.
Post your comment on this topic.