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

  1. [On both nodes] Add PATH
    c:\Program Files\Fujitsu\fsepv14server64\bin
    c:\Program Files\Fujitsu\fsepv14server64\lib
    
  2. Switchover a volume resource to a secondary node
  3. [On a secondary node] Create a folder for an instance (use inst1 as instance name)
    mkdir d:\database\inst1
    
  4. [On a secondary node] Grant Administrator access to the folder for the instance
  5. [On a secondary node] Create the instance
    initdb -D D:\database\inst1 --lc-collate="C" --lc-ctype="C" --encoding=UTF8
    
  6. [On a secondary node] Register the instance with Windows Services
    pg_ctl register -N "inst1" -U Administrator -P <password> -D D:\database\inst1
    
  7. [On a secondary node] Add -o "-p <port number>" to the inst1 service startup options
  8. [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>"
    
  1. [On a secondary node] Start the inst1 service and check connectivity
    sc start inst1
    sc query inst1
    psql -d postgres -l
    
  2. [On a secondary node] Stop the inst1 service
    sc stop inst1
    sc query inst1
    
  3. Switchover the volume resource to the primary node
  4. [On a primary node] Grant Administrator access to the folder for the instance
  5. [On a primary node] Delete all files under the instance folder
  6. [On a primary node] Create the instance
  7. [On a primary node] Register the instance with Windows Services
    Specify the same username and password as those registered on the secondary node.
  8. [On a primary node] Add -o "-p <port number>" to the inst1 service startup options
  9. [On a primary node] Add a PostgreSQL compatible registry entry
  10. [On a primary node] Edit postgresql.conf of inst1 and add the following lines
    listen_addresses = '*'
    port = 27500
    
  11. [On a primary node] Edit pg_hba.conf of inst1 and add the following lines
    host    all             all             10.0.0.0/16            md5
    
  12. [On a primary node] Start the inst1 service and check connectivity

Create a PostgreSQL resource

  1. Create/extend a PostgreSQL resource
  2. Create a dependency between the PostgreSQL resource and the IP resource (only if the IP resource is created)

Configuration required for client connections

  1. [On both nodes] Permit the port number used in the firewall configuration (27500 in the above postgresql.conf configuration)
  2. [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.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment