Postgresql Cluster Initialisation Errors

Note: Please note that the instructions in this article should only be attempted by technical people like IT techs.

If PostgreSQL fails to initialise the database cluster while installing PostgreSQL, or manually through the command prompt then you may need to complete some manual steps to get PostgreSQL to install.

In some instances, Cubit Estimating simply refuses to initialise default database either by install from Cubit Estimating installer or through PostgreSQL installer.

In such a scenario, you will need to create the cluster in the local environment to some temporary folder  using the command as shown in the Fig.1

Initdb.exe –A md5 –Upostgres –Eutf8 –W –D”<Temp PostgreSQL Data Folder>”

After the execution of the command, copy the content of the folder to the client’s PostgreSQL data folder to C:\Program Files\PostgreSQL\10\data.

Fig.1 Create Temp Environment

If the PostgreSQL service  is not registered at this stage, then you can register it by  using the following command as shown in Fig.2:

pg_ctl.exe register -N postgresql-x64-10 -D"C:\Program Files\Postgresql\10\data"

Fig.2 Register Service