Re: Postgres install - Mailing list pgsql-admin

From Dave Cramer
Subject Re: Postgres install
Date
Msg-id CADK3HHKFej9skf9WVsezok4hsVuj14qMctjMM34U2rE-YTO97Q@mail.gmail.com
Whole thread Raw
In response to Re: Postgres install  (Benjamin Scherrey <scherrey@proteus-tech.com>)
Responses Re: Postgres install  (Samuel Teixeira Santos <arcanosam@gmail.com>)
Re: Postgres install  (Samuel Teixeira Santos <arcanosam@gmail.com>)
List pgsql-admin



On 5 February 2018 at 19:01, Benjamin Scherrey <scherrey@proteus-tech.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@gmail.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

 

Thanks in Advance

--

Regards,
Azim


pgsql-admin by date:

Previous
From: Benjamin Scherrey
Date:
Subject: Re: Postgres install
Next
From: robert
Date:
Subject: ubuntu pg_wrapper selects the wrong version for pg_restore