Postgresql Cluster Initialisation Errors

Follow


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\9.2\data.


image1.jpgFig.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-9.2 -D"C:\Program Files\Postgresql\9.2\data"


image2.jpgFig.2 Register Service

 

1 out of 1 found this helpful

Comments

3 comments
  • Dear madam

    Thanks for you solution , but its sill not working. i have tried a lot of methods and nearly 15 times i have uninstalled and reinstalled Postgre SQL. but still it showing "Database cluster initialisation failed ".while trying your solution it asking password but my command prompt does not taking my password. how can i enter my password.

    please help me madam 🙏 please

    0
    Comment actions Permalink
  • Here im using Windows 10
    Pls try to help me

    0
    Comment actions Permalink
  • Dear Naga Vamsi,
    I have created a support ticket now to assist you further.

    0
    Comment actions Permalink

Please sign in to leave a comment.