How can I check if PostgreSQL is installed or not via Linux script?

We can simply write:

psql --version

output show like:

psql (PostgreSQL) 11.5 (Ubuntu 11.5-1.pgdg18.04+1)

If it is debian based.

aptitude show postgresql | grep State

But I guess you can just try to launch it with some flag like --version, that simply prints some info and exits.

You can check if the service is available. Try

service postgresql status
if [ "$?" -gt "0" ]; then
  echo "Not installed".
else
  echo "Intalled"
fi

or in a broader range of Linux distros systemctl status postgresql can be used.

There is no single simple way to do it, because PostgreSQL might be installed and set up in many different ways:

• Installed from source in a user home directory
• Installed from source into /opt or /usr/local, manually started or started by an init script
• Installed from distributor rpm / deb packages and started via init script
• Installed from 3rd party rpm / deb packages and started via init script
• Installed from packages but not set to start
• Client installed, connecting to a server on a different computer
• Installed and running but not on the default PATH or default port

You can't rely on psql being on the PATH. You can't rely on there being only one psql on the system (multiple versions might be installed in different ways). You can't do it based on port, as there's no guarantee it's on port 5432, or that there aren't multiple versions.

Prompt the user and ask them.

There is no straightforward way to do this. All you can do is check with the package manager (rpm, dpkg) or probe some likely locations for the files you want. Or you could try to connect to a likely port (5432) and see if you get a PostgreSQL protocol response. But none of this is going to be very robust. You might want to review your requirements.

And if everything else fails from these great choice of answers, you can always use "find" like this. Or you may need to use sudo

If you are root, just type $$> find / -name 'postgres'

If you are a user, you will need sudo priv's to run it through all the directories

I run it this way, from the / base to find the whole path that the element is found in. This will return any files or directories with the "postgres" in it.

You could do the same thing looking for the pg_hba.conf or postgresql.conf files also.

If you are running Debian Linux (or derivative) and if you have a postive return with > which psql, then simply type psql -V (capital "V") and you will get a return like: psql (PostgreSQL) 9.4.8

For many years I used the command:

ps aux | grep postgres

On one hand it is useful (for any process) and gives useful info (but from process POV). But on the other hand it is for checking if the server you know, you already installed is running.

At some point I found this tutorial, where the usage of the locate command is shown. It looks like this command is much more to the point for this case.

aptitude show postgresql | grep Version worked for me

dpkg -l | grep postgres

RUN the above command and if you get the output as shown in the image then it does not exist on your system

Source:-Click here for more info

Go to bin directory of postgres db such as /opt/postgresql/bin & run below command :

[...bin]# ./psql --version

psql (PostgreSQL) 9.0.4

Here you go . .

You may also check in /opt mount in following path /opt/PostgresPlus/9.5AS/bin/

Well, all answersabove are good but not in all cases.

Basically check the folder /etc/postgresql/

in most cases there will be one subfolder eg. /etc/postgresql/11/ (or /etc/postgresql/12) which means that you have installed 11 (or 12) version, however in many cases you may have many of such subfolders, so having them all means that all those versions had been ever installed and could be in use ... so be aware of this important trace.

ps using Ubuntu 18.04

Go window services ad search for PostGreSQL. here I found

WARNING: this is only checking if postgres CLIENT is installed (which can be installed WITHOUT installing the server)

psql --version; 

AI suggested this:

pg_isready 
/var/run/postgresql:5432 - accepting connections

possibly a ubuntu only way is to use absolute path to the binary:

/usr/lib/postgresql/14/bin/postgres --version
postgres (PostgreSQL) 14.13 (Ubuntu 14.13-1.pgdg22.04+1)

/usr/lib/postgresql/12/bin/postgres --version
postgres (PostgreSQL) 12.20 (Ubuntu 12.20-1.pgdg22.04+1)

but it is very bewildering that this is so tricky and that this use case was not documented by postgres developers?

during install a soft link should be put from under /usr/lib/postgresql/14/bin/postgres to /usr/bin

that points to the (lastest?) postgres binary installed, so a simple postgres --version would work and show if postgres SERVER is installed.