I installed postgresql from the package manager
sudo apt-get install postgresql postgresql-contrib
and I want to know what files it installed, including any startup scripts or modifications to any shell scripts.
When I run dpkg-query, this is the output:
# dpkg-query -L postgresql
/.
/usr
/usr/share
/usr/share/doc
/usr/share/doc/postgresql
/usr/share/doc/postgresql/changelog.gz
/usr/share/doc/postgresql/copyright
As you can see, it is not listing a lot of the crucial files, including (but not limited to):
/usr/lib/postgresql (the binaries)
/var/lib/postgresql (the data directory and the database initialization via initdb)
/etc/postgresql (the configuration files)
/var/log/postgresql (the log file)
Also I want to know what changes it made to global startup scripts in order for it to be loaded when operating system starts.
Why are all these important details missing from the output of dpkg-query and how can I list this information?