http://www.thelinuxwiki.com/index.php?action=history&feed=atom&title=postgres 2026-04-29T07:23:57Z Revision history for this page on the wiki MediaWiki 1.21.5 http://www.thelinuxwiki.com/index.php?title=postgres&diff=1415&oldid=prev 2021-11-16T16:57:27Z

<p>Created page with &quot;==controlling access/authentication== file: pg_hba.conf path: /etc/postgresql/&lt;version&gt;/main/ example of no auth from local any user add line... local all all trust resta...&quot;</p> <p><b>New page</b></p><div>==controlling access/authentication==<br /> <br /> file: pg_hba.conf<br /> path: /etc/postgresql/&lt;version&gt;/main/<br /> <br /> example of no auth from local any user<br /> <br /> add line...<br /> local all all trust<br /> <br /> restart server?<br /> <br /> ==basic commands via CLI==<br /> <br /> connect as user postgres<br /> psql -U postgres<br /> postgres-#<br /> <br /> list all databases<br /> postgres-# \l<br /> List of databases<br /> Name | Owner | Encoding | Collate | Ctype | Access privileges <br /> -----------+-------------+----------+-------------+-------------+-----------------------<br /> postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | <br /> template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +<br /> | | | | | postgres=CTc/postgres<br /> template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +<br /> | | | | | postgres=CTc/postgres<br /> <br /> quit<br /> \q</div>

Nighthawk