I have a rather simple question.
As stated in the pg_hba.conf
file in the postgres data directory:
# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database superuser can access the database using some other method.
# Noninteractive access to all databases is required during automatic
# maintenance (custom daily cronjobs, replication, and similar tasks).
#
# Database administrative login by Unix domain socket
local all postgres peer
...
# "local" is for Unix domain socket connections only
This makes sense on Linux in order to be able to use $ sudo -u postgres psql
to directly login to the database without being actually prompted for a password for the postgres
user of the operating system (which is created when installing postgresql on Linux).
So, by definition, I guess “Unix domain sockets” don’t exist on Windows.
And I can obviously not do: $ sudo -u postgres
on Windows.
Hence my question: does it even make sense for these lines to exist on a Windows machine or could I just comment these local
entries out?
Or does a similar login mechanism exist (e.g. not being prompted for a password for the logged Windows user)?