where is postres installed?

Hi Arbol,

You can try from the following commands:

dpkg-query -L postgresql-16
which psql
sudo find / -name "postgres" 2>/dev/null

On Fri, 23 Aug 2024 at 05:35, Arbol One <ArbolOne@hotmail.ca> wrote:

Hi Arbol,

Hope above response from Usman must have resolved your issue. You may also
try by finding any binary of PostgreSQL. e.g.

find /usr -name pg_ctl
/usr/local/pgsql/bin/pg_ctl
/usr/lib/postgresql/16/bin/pg_ctl

Regards,
Ikram

On Fri, Aug 23, 2024 at 9:33 AM Muhammad Usman Khan <usman.k@bitnine.net>
wrote:

Hi Arbol,

You can try from the following commands:

dpkg-query -L postgresql-16
which psql
sudo find / -name "postgres" 2>/dev/null

On Fri, 23 Aug 2024 at 05:35, Arbol One <ArbolOne@hotmail.ca> wrote:

After installing PostgreSQL on my Debian-12 machine, I typed 'postgres
--version' and got this msg:
*bash: postgres: command not found*

'psql --version', however, does work and gives me this message :

*psql (PostgreSQL) 16.3 (Debian 16.3-1.pgdg120+1)*

Obviously postgres is not in the path, but I don't know where the
'apt-get' installed it or why it did not add it to the path.

Is there a way I can locate the installation directory?

Thank in advance.
--
*ArbolOne.ca* Using Fire Fox and Thunderbird. ArbolOne is composed of
students and volunteers dedicated to providing free services to charitable
organizations. ArbolOne on Java Development is in progress [ í ]

--
Muhammad Ikram

On Thu, Aug 22, 2024 at 8:36 PM Arbol One <ArbolOne@hotmail.ca> wrote:

After installing PostgreSQL on my Debian-12 machine, I typed 'postgres
--version' and got this msg:
*bash: postgres: command not found*

'psql --version', however, does work and gives me this message :

*psql (PostgreSQL) 16.3 (Debian 16.3-1.pgdg120+1)*

Obviously postgres is not in the path, but I don't know where the
'apt-get' installed it or why it did not add it to the path.

Is there a way I can locate the installation directory?

pg_config | grep BINDIR

--
Death to America, and butter sauce.
Iraq lobster!

Hi Arbol

Use this command and it will show all the files installed by the package.

dpkg-query -L postgresql-16

Regards

Kashif Zeeshan

On Fri, Aug 23, 2024 at 9:50 AM Muhammad Ikram <mmikram@gmail.com> wrote: