cancel
Showing results for 
Search instead for 
Did you mean: 

edb postgres installation fialed

Adventurer

edb postgres installation fialed

Hello Experts,

 

I am learning postgres, today i tied to install edb postgres advance server on my virutal box, running on OEL 7.5.

 

I have executed installaction script as root

 

[root@pgsql-lnx1 edbpostgres_sw]# ./edb-as10-server-10.5.12-1-linux-x64.run

provided all the necessary information,

 

i got summary on installation as below .

 

The following settings will be used for the installation::

Installation Directory: /opt/edbpostgres/pghome/10.6
Server Installation Directory: /opt/edbpostgres/pghome/10.6
Data Directory: /pgdata/edbdatadir
WAL Directory: /pgdata/edb_pg_wal
Database Port: 5444
Database Superuser: enterprisedb
Operating System Account: enterprisedb
Database Service: edb-as-10
Command Line Tools Installation Directory: /opt/edbpostgres/pghome/10.6
pgAdmin4 Installation Directory: /opt/edbpostgres/pghome/10.6/pgAdmin4
StackBuilderPlus Installation Directory:
/opt/edbpostgres/pghome/10.6/stackbuilderplus

 

Setup is now ready to begin installing EDB Postgres Advanced Server on your
computer.

Do you want to continue? [Y/n]: Y

----------------------------------------------------------------------------
Please wait while Setup installs EDB Postgres Advanced Server on your computer.

Installing EDB Postgres Advanced Server
0% ______________ 50% ______________ 100%
########################################Warning: Problem running post-install step. Installation may not complete
correctly
The database cluster initialisation failed.  >>>>>>>> ******
Press [Enter] to continue:
#----------------------------------------------------------------------------
Setup has finished installing EDB Postgres Advanced Server on your computer.

 

 

where can i see installation log files?

how do i determine the cuase of faiure?

please advise 

 

here is my os details :

[root@pgsql-lnx1 edbpostgres_sw]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.5 (Maipo)
[root@pgsql-lnx1 edbpostgres_sw]# uname -a
Linux pgsql-lnx1 4.1.12-112.16.4.el7uek.x86_64 #2 SMP Mon Mar 12 23:57:12 PDT 2018 x86_64 x86_64 x86_64 GNU/Linux
[root@pgsql-lnx1 edbpostgres_sw]#

 

 

Thanks and Rregards,

Pavan Sunakra

 

4 REPLIES 4
Level 3 Adventurer

Re: edb postgres installation fialed

Hi Pavan,

 

As per the error you shared it looks the directory where you are creating the data directory and wal directory i.e.
Data Directory: /pgdata/edbdatadir
WAL Directory: /pgdata/edb_pg_wal

Doesn't have the enterprisedb user permission. Hence please check if the owner of /pgdata is enterprisedb and the mod is 700. Also make sure that the data directory folder is empty.
You will find the installer logs at /tmp/bitrock_installer.log (check the latest) and /tmp/install-edb-as10-server.log. Kindly share it with us.
Hope this helps.

Please let us know if the issue still exists.

 

--

Ajinkya

Highlighted
Adventurer

Re: edb postgres installation fialed

Hi Pavan,

                   Please check your os bit version and compared to your EDB software bit version.

Keep on mind Where your run this installation check your permisiion ..

These two is the problem is """""The database cluster initialisation failed."""""

 

NOTE

FYI

    64 bit postgres s/w is not supported your os 32 bit..

 

Thanks

Dineshkumar Ashokan

Dineshkumar Ashokan
Adventurer

Re: edb postgres installation fialed

Hello Ajinkya,

 

Thank you so much for your reply and providing me the location of installer log files. it is really helped me to find the cause.

[22:35:22] Running the post-installation/upgrade actions:
Creating service user account...
Executing /opt/edbpostgres/pghome/10.6/installer/server/createuser.sh "enterprisedb" "/opt/edbpostgres/pghome/10.6"
Script exit code: 0

Script output:
/opt/edbpostgres/pghome/10.6/installer/server/createuser.sh ran to completion

Script stderr:
useradd: warning: the home directory already exists.
Not copying any file from skel directory into it.

Initialising the database cluster (this may take a few minutes)...
Executing /opt/edbpostgres/pghome/10.6/installer/server/initcluster.sh "enterprisedb" "enterprisedb" "/opt/edbpostgres/pghome/10.6/installer/server" "/opt/edbpostgres/pghome/10.6" "/pgdata/edbdatadir" "/pgdata/edbdatadir/pg_wal" 5444 en_NZ.iso88591 oracle 100 mixed
Script exit code: 1

Script output:
User enterprisedb does not have required permissions on directory /opt/edbpostgres/pghome/10.6


Script stderr:
child process exited abnormally

Error running /opt/edbpostgres/pghome/10.6/installer/server/initcluster.sh "enterprisedb" "enterprisedb" "/opt/edbpostgres/pghome/10.6/installer/server" "/opt/edbpostgres/pghome/10.6" "/pgdata/edbdatadir" "/pgdata/edbdatadir/pg_wal" 5444 en_NZ.iso88591 oracle 100 mixed: child process exited abnormally
Problem running post-install step. Installation may not complete correctly
The database cluster initialisation failed.
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed
Log finished 02/12/2019 at 22:35:59

 

here question is installatino process is created enterpriedb user and why it pick up proper permission for enterprisedb user?

 

Level 3 Adventurer

Re: edb postgres installation fialed

Hi Pavan,

 

When we use the default directories then the installation process takes care of permissions to the directory.
However since you are using customized directory hence in your case, user has to take care of the required permissions on the directory.

I have attached both the test cases for your reference.

Hope this answers your question.
Please feel free to reach us if you have any queries.

 

--

Ajinkya