Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

unable to start postgres for ambari

Highlighted

unable to start postgres for ambari

Super Guru

I am trying to start ambari and it fails while starting postgres on the sandbox.

[root@sandbox ~]# ambari-server restart Using python /usr/bin/python2 Restarting ambari-server Using python /usr/bin/python2 Stopping ambari-server Ambari Server is not running Using python /usr/bin/python2 Starting ambari-server Ambari Server running with administrator privileges. Running initdb: This may take upto a minute. About to start PostgreSQL ERROR: Exiting with exit code 3. REASON: Unable to start PostgreSQL server. Status stopped. . Exiting

I tried to start postgres

[root@sandbox ~]# service postgresql start Starting postgresql service: [FAILED]

Then I ran a postgres status:

[root@sandbox ~]# service postgresql status postmaster is stopped

I am not sure how to start postmaster. I tried

[root@sandbox ~]# pg_ctl start pg_ctl: cannot be run as root Please log in (using, e.g., "su") as the (unprivileged) user that will own the server process.

Any other ideas?

19 REPLIES 19

Re: unable to start postgres for ambari

su - postgres
pg_ctl status
pg_ctl start

Re: unable to start postgres for ambari

Super Guru

@Jitendra Yadav thanks for your response. It did not work.

Re: unable to start postgres for ambari

I didn't expected it to work :) , just shared because you had issue with pg_ctl start pg_ctl with root.

can you please check postgres logs on below location and see if there is any clue?

/var/lib/pgsql/data/pg_log

Re: unable to start postgres for ambari

Super Guru

@Jitendra Yadav I looked at the logs and all I found is this:

CONTEXT: line 79 of configuration file "/var/lib/pgsql/data/pg_hba.conf"

FATAL: could not load pg_hba.conf

Any ideas?

Re: unable to start postgres for ambari

Sunile, is there anything interesting in /var/lib/pgsql/pgstartup.log?

Re: unable to start postgres for ambari

New Contributor

Please check /tmp permissions then restart ambari server.

Re: unable to start postgres for ambari

New Contributor

Also select Enter advanced database configuration [y/n] (n)? y

Re: unable to start postgres for ambari

Super Guru

5491-2016-07-04-23-08-00.jpg

@Mudit Kumar tmp permissions look good. How do I enter advanced database configuration? And why?

Re: unable to start postgres for ambari

Super Guru

@slachterman I check the pgstartup.log and see this:

runuser: cannot set groups: Operation not permitted runuser: cannot set groups: Operation not permitted runuser: cannot set groups: Operation not permitted runuser: cannot set groups: Operation not permitted