Postgres install
Postgres install
От:
Azimuddin Mohammed <azimeiu@gmail.com>
Дата:
Hello,
I need to install postgres without root privileges. I have a postgres user in our companies AD. --
Regards,
Azim
Re: Postgres install
От:
Adrian Klaver <adrian.klaver@aklaver.com>
Дата:
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 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.klaver@aklaver.com
Re: Postgres install
От:
Adrian Klaver <adrian.klaver@aklaver.com>
Дата:
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 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.klaver@aklaver.com
Re: Postgres install
От:
Benjamin Scherrey <scherrey@proteus-tech.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@gmail.com> wrote:
Thanks in Advance3. 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.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 ?1. Is there a website you will refer other the postgres documentation, the one on postgres website is confusingBelow are my questions n concerns:Hello,I need to install postgres without root privileges. I have a postgres user in our companies AD.
--
Regards,
Azim
Re: Postgres install
От:
Benjamin Scherrey <scherrey@proteus-tech.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@gmail.com> wrote:
Thanks in Advance3. 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.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 ?1. Is there a website you will refer other the postgres documentation, the one on postgres website is confusingBelow are my questions n concerns:Hello,I need to install postgres without root privileges. I have a postgres user in our companies AD.
--
Regards,
Azim
Re: Postgres install
От:
Dave Cramer <pg@fastcrypt.com>
Дата:
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 ScherreyOn Feb 6, 2018 9:42 AM, "Azimuddin Mohammed" <azimeiu@gmail.com> wrote:1. Is there a website you will refer other the postgres documentation, the one on postgres website is confusingBelow are my questions n concerns:Hello,I need to install postgres without root privileges. I have a postgres user in our companies AD.
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
Re: Postgres install
От:
Dave Cramer <pg@fastcrypt.com>
Дата:
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 ScherreyOn Feb 6, 2018 9:42 AM, "Azimuddin Mohammed" <azimeiu@gmail.com> wrote:1. Is there a website you will refer other the postgres documentation, the one on postgres website is confusingBelow are my questions n concerns:Hello,I need to install postgres without root privileges. I have a postgres user in our companies AD.
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
Re: Postgres install
От:
Samuel Teixeira Santos <arcanosam@gmail.com>
Дата:
Hi to all.
I usually install Postgresql on my user to local development using the Postgresql Binaries
I follow some tips from this link 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
Re: Postgres install
От:
Samuel Teixeira Santos <arcanosam@gmail.com>
Дата:
Hi to all.
I usually install Postgresql on my user to local development using the Postgresql Binaries
I follow some tips from this link 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