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 :

From: Harsh Singh <itsharshonly(at)gmail(dot)com>
To: Patel Akash <patelakash20(at)gmail(dot)com>
Cc: pgsql-in-general(at)postgresql(dot)org
Subject: 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 :
Date: 2016-03-30 14:14:05
Message-ID: CACodpG=1rqn5y7g=7Hm2M5BZG+Sx4Dx-FppdHyuLvqhjZppXhg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-in-general

initdb cannot be run as root user. You need to switch to a non root user to
run it.
On Mar 30, 2016 1:46 PM, "Patel Akash" <patelakash20(at)gmail(dot)com> wrote:

> 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
>

In response to

Browse pgsql-in-general by date

  From Date Subject
Next Message Andre Mikulec 2016-04-06 06:23:31 pl/r extension trying to compile with mingw64
Previous Message Patel Akash 2016-03-30 08:16:04 Any process to Initialize the Postgresql DB [postgresql-9.2.4-1-linux-x64.run] with root [super] user on Linux/RHEL 7.x :