PostgreSQL - ArchWiki - Arch Linux
wiki.archlinux.org › title › PostgreSQLConfigure PostgreSQL to be accessible exclusively through UNIX Sockets. In the connections and authentications section of your configuration, set: /var/lib/postgres/data/postgresql.conf listen_addresses = '' This will disable network listening completely. After this you should restart postgresql.service for the changes to take effect.
PostgreSQL - ArchWiki - Arch Linux
https://wiki.archlinux.org/title/PostgreSQLFamiliarize with PostgreSQL Access the database shell. Become the postgres user. Start the primary database shell, psql, where you can do all your creation of databases/tables, deletion, set permissions, and run raw SQL commands.Use the -d option to connect to the database you created (without specifying a database, psql will try to access a database that matches your …