Any process to Initialize the Postgresql DB [postgresql-9.2.4-1-linux-x64.run] with root [super] user on Linux/RHEL 7.x :

From: Patel Akash <patelakash20(at)gmail(dot)com>
To: pgsql-in-general(at)postgresql(dot)org
Subject: Any process to Initialize the Postgresql DB [postgresql-9.2.4-1-linux-x64.run] with root [super] user on Linux/RHEL 7.x :
Date: 2016-03-30 08:16:04
Message-ID: CADD9ygK=yyAufP6YNDu4Qg4g_ZMOVjpBknC6jMt4y=cMi=VkMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-in-general

Hi Team,

In my workspace, i have maven script that automatically pick up the
'postgresql-9.2.4-1-linux-x64.run' file from the source location and
extract it and then try to initialize the DB with root user with below
command :

i.e:

INITIALISING THE DB ...

/linux-work/target/expandedPostgres/pgsql/bin/initdb -U sudouser -E UTF8
--locale C -A md5 --pwfile=.pgpass -D
/linux-work/main/target/expandedPostgres/data

here; 'sudouser' is the non root user

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

its failing with below error:

********************************************************

[DEBUG] initdb: cannot be run as root
[DEBUG] Please log in (using, e.g., "su") as the (unprivileged) user that
will
[DEBUG] own the server process.
Failed to execute DATABASE INITIALISATION

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Can you guide me, what are the steps i am missing here ?? and or any other
guidance to resolve this issue ?

Thanks,
Akash

Responses

Browse pgsql-in-general by date

  From Date Subject
Next Message Harsh Singh 2016-03-30 14:14:05 Re: Any process to Initialize the Postgresql DB [postgresql-9.2.4-1-linux-x64.run] with root [super] user on Linux/RHEL 7.x :
Previous Message Scott Marlowe 2016-03-11 15:10:30 Re: Regarding connection drops for every few minutes