Home Forums HDP on Linux – Installation Setting up ambari Server issue with Postgresql

Tagged: ,

This topic contains 3 replies, has 2 voices, and was last updated by  Markus F 4 months, 3 weeks ago.

  • Creator
    Topic
  • #52612

    Markus F
    Participant

    Hi everyone,

    I tried to setup the ambari server but getting a error message like this:

    [ec2-user@ip-10-0-0-112 etc]$ sudo ambari-server setup
    Using python /usr/bin/python2.6
    Setup ambari-server
    Checking SELinux…
    SELinux status is ‘enabled’
    SELinux mode is ‘permissive’
    WARNING: SELinux is set to ‘permissive’ mode and temporarily disabled.
    OK to continue [y/n] (y)?
    Ambari-server daemon is configured to run under user ‘root’. Change this setting [y/n] (n)?
    Adjusting ambari-server permissions and ownership…
    Checking iptables…
    Checking JDK…
    Do you want to change Oracle JDK [y/n] (n)?
    Completing setup…
    Configuring database…
    Enter advanced database configuration [y/n] (n)?
    Default properties detected. Using built-in database.
    Checking PostgreSQL…
    Running initdb: This may take upto a minute.
    About to start PostgreSQL
    ERROR: Exiting with exit code 1.
    REASON: Unable to start PostgreSQL server. Exiting
    [ec2-user@ip-10-0-0-112 etc]$

    tried to stop and sto/restart/start the postgresql …but no luck

    when i tried …the following came up:

    [ec2-user@ip-10-0-0-112 etc]$ sudo /etc/init.d/postgresql restart
    Stopping postgresql service: [ OK ]
    Starting postgresql service: [FAILED]

    this is what is installed:

    postgresql-8.4.20-1.el6_5.x86_64
    postgresql-libs-8.4.20-1.el6_5.x86_64
    postgresql-server-8.4.20-1.el6_5.x86_64

    …anyone could please help ?

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #52653

    Markus F
    Participant

    Issue resolved. :) Needed to add “127.0.0.1 localhost localhost.localdomain” to the /etc/hosts file

    Collapse
    #52652

    Markus F
    Participant

    1) cat /var/lib/pgsql/pgstartup.log:

    [ec2-user@ip-10-0-0-112 ~]$ sudo cat /var/lib/pgsql/pgstartup.log
    The files belonging to this database system will be owned by user “postgres”.
    This user must also own the server process.

    The database cluster will be initialized with locale en_US.UTF-8.
    The default database encoding has accordingly been set to UTF8.
    The default text search configuration will be set to “english”.

    fixing permissions on existing directory /var/lib/pgsql/data … ok
    creating subdirectories … ok
    selecting default max_connections … 100
    selecting default shared_buffers … 32MB
    creating configuration files … ok
    creating template1 database in /var/lib/pgsql/data/base/1 … ok
    initializing pg_authid … ok
    initializing dependencies … ok
    creating system views … ok
    loading system objects’ descriptions … ok
    creating conversions … ok
    creating dictionaries … ok
    setting privileges on built-in objects … ok
    creating information schema … ok
    vacuuming database template1 … ok
    copying template1 to template0 … ok
    copying template1 to postgres … ok

    Success. You can now start the database server using:

    /usr/bin/postgres -D /var/lib/pgsql/data
    or
    /usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start

    LOG: could not translate host name “localhost”, service “5432″ to address: Name or service not known
    WARNING: could not create listen socket for “localhost”
    FATAL: could not create any TCP/IP sockets
    LOG: could not translate host name “localhost”, service “5432″ to address: Name or service not known
    WARNING: could not create listen socket for “localhost”
    FATAL: could not create any TCP/IP sockets
    LOG: could not translate host name “localhost”, service “5432″ to address: Name or service not known
    WARNING: could not create listen socket for “localhost”

    2) cat /var/lib/pgsql/data/pg_log/postgresql-Wed.log
    -> could not find file or directory

    Collapse
    #52622

    Jeff Sposetti
    Moderator

    Any errors or info in the following?

    1) cat /var/lib/pgsql/pgstartup.log
    2) cat /var/lib/pgsql/data/pg_log/postgresql-Wed.log

    Collapse
Viewing 3 replies - 1 through 3 (of 3 total)