How to install PostgreSQL binaries on a different directory than the default one

Started by Allie Crawfordabout 5 years ago3 messagesgeneral
Jump to latest
#1Allie Crawford
CrawfordMA@ChurchofJesusChrist.org

Hi,
I am new in postgresql and I am trying to install PostgreSQL on Linux server but instead of using the default location for the binaries I want to install them in a different directory.
I have research for a while and I cannot find any information on how to do that using the dnf utility which is what the PostgreSQL website gives me as instruction when I go the download page.

I have a directory called /pg01 that I want to use to install the binaries. The postgreSQL download site (https://www.postgresql.org/download/linux/redhat/ ) gives me the following steps to install the binaries:

Steps to install postgresql 13

sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql
sudo dnf install -y postgresql13-server
sudo /usr/pgsql-13/bin/postgresql-13-setup initdb
sudo systemctl enable postgresql-13
sudo systemctl start postgresql-13

That set of instructions shown right above, installs the binaries under the /usr/pgsql-13, and what I want is to install the binaries under /pg01 instead of /usr.

My question is, what are the changes I need to do in the instructions detailed right above, so that I can get the binary installation under the /pg01 directory instead of the default /usr directory.

Thanks in advance for any help you can five me on this.

Regards,
Allie

#2rob stone
floriparob@gmail.com
In reply to: Allie Crawford (#1)
Re: How to install PostgreSQL binaries on a different directory than the default one

Hello,

On Fri, 2021-04-02 at 22:01 +0000, Allie Crawford wrote:

Hi,
I am new in postgresql and I am trying to install PostgreSQL on Linux
server but instead of using the default location for the binaries I
want to install them in a different directory.
I have research for a while and I cannot find any information on how
to do that using the dnf utility which is what the PostgreSQL website
gives me as instruction when I go the download page.
 
I have a directory called /pg01 that I want to use to install the
binaries. The postgreSQL download site (
https://www.postgresql.org/download/linux/redhat/ ) gives me the
following steps to install the binaries:
 
 
That set of instructions shown right above, installs the binaries
under the/usr/pgsql-13, and what I want is to install the binaries
under /pg01 instead of /usr.
My question is, what are the changes I need to do in the instructions
detailed right above, so that I can get the binary installation under
the /pg01 directory instead of the default /usr directory.
 
Thanks in advance for any help you can five me on this.
 
Regards,
Allie

Most Linux distros keep the binaries by major version. So when you
install version 14 it will go into /usr/pgsql-14.
Thus, by using different port numbers you can run multiple versions on
the same box.
Useful for development, QA, etc.

HTH,
Robert

#3Benedict Holland
benedict.m.holland@gmail.com
In reply to: rob stone (#2)
Re: How to install PostgreSQL binaries on a different directory than the default one

Why not use the docker container?

Thanks,
Ben

On Fri, Apr 2, 2021, 8:25 PM rob stone <floriparob@gmail.com> wrote:

Show quoted text

Hello,

On Fri, 2021-04-02 at 22:01 +0000, Allie Crawford wrote:

Hi,
I am new in postgresql and I am trying to install PostgreSQL on Linux
server but instead of using the default location for the binaries I
want to install them in a different directory.
I have research for a while and I cannot find any information on how
to do that using the dnf utility which is what the PostgreSQL website
gives me as instruction when I go the download page.

I have a directory called /pg01 that I want to use to install the
binaries. The postgreSQL download site (
https://www.postgresql.org/download/linux/redhat/ ) gives me the
following steps to install the binaries:

That set of instructions shown right above, installs the binaries
under the/usr/pgsql-13, and what I want is to install the binaries
under /pg01 instead of /usr.
My question is, what are the changes I need to do in the instructions
detailed right above, so that I can get the binary installation under
the /pg01 directory instead of the default /usr directory.

Thanks in advance for any help you can five me on this.

Regards,
Allie

Most Linux distros keep the binaries by major version. So when you
install version 14 it will go into /usr/pgsql-14.
Thus, by using different port numbers you can run multiple versions on
the same box.
Useful for development, QA, etc.

HTH,
Robert