Re: Postgres install

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

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 ?

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.

Thanks in Advance

--

Regards,
Azim

On 02/05/2018 12:41 PM, Azimuddin Mohammed 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

I am guessing you are referring to?:

https://www.postgresql.org/docs/10/static/index.html

What part do you find 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 ?

For source code install see here:

https://www.postgresql.org/docs/10/static/install-procedure.html

"You can customize the build and installation process by supplying one
or more of the following command line options to configure:

--prefix=PREFIX

Install all files under the directory PREFIX instead of
/usr/local/pgsql. The actual files will be installed into various
subdirectories; no files will ever be installed directly into the PREFIX
directory.
"

The second part of your question has to do with a RPM install, which is
not a source install. Do you want to do a source install, RPM install or
both?

Also what OS are you planning to install to?

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

This would be easier to answer if you where to provide an outline of how
you want your Postgres install to be structured.

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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

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
>
> 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 ?
>
> 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.
>
>
> Thanks in Advance
>
> --
>
> Regards,
> Azim
>
>

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

Hi to all.

I usually install Postgresql on my user to local development using the
Postgresql
Binaries <https://www.enterprisedb.com/download-postgresql-binaries>

I follow some tips from this link Installing Postgresql 9.1 to windows 7
from the binary zip distribution
<https://www.petrikainulainen.net/programming/tips-and-tricks/installing-postgresql-9-1-to-windows-7-from-the-binary-zip-distribution/>

You could do this installation and definitons programmatically, but you
must define a user to run postgres at end.

In my case I use my own linux account.

Always work.

Hope its helps

Samuel