The following instructions will guide you through how to manually add the FME Server Database Respository to an existing FME Server 2012 installation.  The FME Server Database Repository is a PostgreSQL 9.0 database.  These instructions will install the delivered PostgreSQL software, register it as a Windows Service and have the required FMESERVER schema created.
 

The location of the PostgreSQL folders can be found at:

<install_dir>\Utilities\pgsql

 

Under <install_dir>\Utilities\pgsql\bin, we need to run the pg_ctl.exe executable with different commands.

 

For more details, run "pg_ctl.exe -h" to see the usage details.

 

For 'installing' the database, we'll need to use the 'initdb" command.

 

c:\> pg_ctl.exe initdb -D <databaseDir>

 

By default, the <databaseDir> is "<install_dir>\Utilities\pgsql\data".  As an example the command may look like this:
 

c:\> pg_ctl.exe initdb -D c:\apps\FMEServer\Utilities\pgsql\data

 

For registering as a Windows Service, we'll need to use the "register" command.

 

> pg_ctl.exe register -N <serviceName> -U <username> -P <passwd> -D <databaseDir>

 

where the default values are...

 

<serviceName> = "FME Server Database"

<username>/<passwd> = User with Admin. privileges

<databaseDir> = "<install_dir>\Utilities\pgsql\data"

 

Once this is created we'll need to create the FMESERVER schema in the PostgreSQL database where the FME Server Repository will be stored.

<install_dir>\utilities\setupPostGreSQL.bat

Set the Repository for FME Server