Differences

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

--- postgresqlcommands [2025/03/28 15:59] – z0hpvk
+++ postgresqlcommands [2025/04/17 10:16] (current) – z0hpvk
@@ Line 1: / Line 1: @@
 ==== Installation ====
-=== Ubuntu ===
+=== Linux ===
-[[https://www.postgresql.org/download/linux/ubuntu/]]\\
+[[https://www.postgresql.org/download/linux/debian/]]\\
+[[https://www.postgresql.org/download/linux/redhat/]]\\
 === Create Cluster ===
-The installation above will create a default cluster for you. \\
+The Debian or Ubuntu installation will create a default instance. \\
-If you wish to create a new one run the following command as postgres ... \\
+Create new instances using the commands below ... \\
-<code>
+<code bash>
-pg_createcluster -d /var/lib/postgresql/14/main 14 main
+# Debian / Ubuntu
+pg_createcluster -d /var/lib/postgresql/17/main 17 main
+# Redhat / Fedora
+# Default Data Directory: /var/lib/pgsql/17/data
+sudo /usr/pgsql-17/bin/postgresql-17-setup initdb
+/usr/pgsql-17/bin/initdb -D /var/lib/pgsql/17/main
 </code>
 === Instance Details ===
 <code>
-pg_config
+/usr/lib/postgresql/17/bin/pg_config
 /usr/lib/postgresql/17/bin/pg_controldata -D $PGDATA
 /usr/lib/postgresql/17/bin/pg_waldump $PGDATA/pg_wal/<WAL_FILE>