Differences

This shows you the differences between two versions of the page.

--- user:rolf001:linux:start [2023/11/22 22:07] – [Github Desktop] rolf.becker
+++ user:rolf001:linux:start [2023/11/22 23:05] (current) – rolf.becker
@@ Line 1: / Line 1: @@
+~~NOTOC~~
 ====== Linux Notes (Ubuntu 22.04) ======
 ===== Github Desktop =====
@@ Line 11: / Line 13: @@
 sudo apt update && sudo apt install github-desktop
 </code>
+===== PostgreSQL on Linux =====
+The Ubuntu software repo might not provide the latest stable release:
+"PostgreSQL is available in all Ubuntu versions by default. However, Ubuntu "snapshots" a specific version of PostgreSQL that is then supported throughout the lifetime of that Ubuntu version. Other versions of PostgreSQL are available through the PostgreSQL apt repository." \\
+(Text copied from the following installation instructions)
+Installation instruction of latest stable release: https://www.postgresql.org/download/linux/ubuntu/
+After installation give the user postgres a password. Use psql on a terminal. The password is needed to be able to use pgadmin4. Both applications are running on localhost.
+<code>
+# in bash terminal login as user postgres who has access to the databases.
+sudo -i -u postgres
+# start the CLI
+psql
+# set the password for user postgres
+ALTER USER postgres WITH PASSWORD 'your_new_password';
+</code>
+Often not need bot nn case you want to or have to alter the `pg_hba.conf`file:
+<code>
+# Add the following to pg_hba.conf:
+host    all             postgres            127.0.0.1/32            md5
+</code>
+Restart PostgreSQL after making changes to the pg_hba.conf file:
+<code>
+sudo systemctl restart postgresql
+</code>