[AMBARI-25021] ambari-server setup fails without local Postgres even for remote DBs

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: ambari-server
• Assignee: Unassigned
• Reporter: Attila Doroszlai
• Created: 07/Dec/18 18:58
• Updated: 29/Mar/23 08:06

Description

The call to setup Ambari Server with a remote DB fails if Ambari Server host doesn't have Postgres installed.

ambari-server setup -s --database mysql --databasehost db --databaseport=3306 --databasename ambari --databaseusername=ambari --databasepassword=bigdata

Using python  /usr/bin/python
Setup ambari-server
Traceback (most recent call last):
  File "/usr/sbin/ambari-server.py", line 45, in <module>
    from ambari_server.serverSetup import reset, setup, setup_jce_policy, setup_jdbc
  File "/usr/lib/ambari-server/lib/ambari_server/serverSetup.py", line 89, in <module>
    JDBC_DB_OPTION_VALUES = get_supported_jdbc_drivers()
  File "/usr/lib/ambari-server/lib/ambari_server/serverSetup.py", line 86, in get_supported_jdbc_drivers
    factory = DBMSConfigFactory()
  File "/usr/lib/ambari-server/lib/ambari_server/dbConfiguration.py", line 390, in __init__
    from ambari_server.dbConfiguration_linux import createPGConfig, createOracleConfig, createMySQLConfig, \
  File "/usr/lib/ambari-server/lib/ambari_server/dbConfiguration_linux.py", line 348, in <module>
    class PGConfig(LinuxDBMSConfig):
  File "/usr/lib/ambari-server/lib/ambari_server/dbConfiguration_linux.py", line 378, in PGConfig
    raise FatalException(1, "Cannot find postgresql-setup script.")
ambari_commons.exceptions.FatalException: 'Fatal exception: Cannot find postgresql-setup script., exit code 1'

The ambari-server package has dependency on postgresql-server. Still, it would be nice not to fail unnecessarily.