Re: Postgres install

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Benjamin Scherrey <scherrey(at)proteus-tech(dot)com>
Cc: Azimuddin Mohammed <azimeiu(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres install
Date: 2018-02-06 00:38:27
Message-ID: CADK3HHKFej9skf9WVsezok4hsVuj14qMctjMM34U2rE-YTO97Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On 5 February 2018 at 19:01, Benjamin Scherrey <scherrey(at)proteus-tech(dot)com>
wrote:

> One option you should seriously consider is using Docker to containerize
> your postgres installation. The installation thinks it has root access but
> you don't need any rights beyond the standard user role that way you can
> use the standard builds without changes. This assumes you're running under
> Linux.
>
> - - Ben Scherrey
>
> On Feb 6, 2018 9:42 AM, "Azimuddin Mohammed" <azimeiu(at)gmail(dot)com> wrote:
>
>> Hello,
>> I need to install postgres without root privileges. I have a postgres
>> user in our companies AD.
>> Below are my questions n concerns:
>>
>> 1. Is there a website you will refer other the postgres documentation,
>> the one on postgres website is confusing
>>
>> What is confusing ?

> 2. What is the default location of postgress install from a source code?
>> i.e if I run rmp -ivh <rpm name> where will it install by default? can this
>> be changed ?
>>
> How are you going to do that without root ?

>
>> 3. Important parameters I need to change ? I am planning to have
>> different drive location for my data directory or any important parameter,
>> please let me know.
>>
>> There are lots, but changing the data dir is not particularly difficult.
https://www.postgresql.org/docs/9.3/static/runtime-config-file-locations.html

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

>
>> Thanks in Advance
>>
>> --
>>
>> Regards,
>> Azim
>>
>>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message robert 2018-02-06 06:06:55 ubuntu pg_wrapper selects the wrong version for pg_restore
Previous Message Benjamin Scherrey 2018-02-06 00:01:43 Re: Postgres install

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Finzel 2018-02-06 06:50:56 Alter table set logged hanging after writing out all WAL
Previous Message Benjamin Scherrey 2018-02-06 00:01:43 Re: Postgres install