postgresql

Differences

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

Link to this comparison view

Next revision		 Previous revision
postgresql [2023/02/21 08:09] – Complete page transition to DokuWiki eviepostgresql [2023/08/11 22:50] (current) – Use bootnote instead of wrap evie
Line 5: Line 5:
 Install the ''postgresql'' package using Bulge. ''bulge i postgresql'' Install the ''postgresql'' package using Bulge. ''bulge i postgresql''
  
-<WRAP center round important 60%> +<bootnote warning> 
-Until post-install scripts are implemented into Bulge, you are required to manually make the directories and users for PostgreSQL. (This is only required if you'd like to use the PostgreSQL server) +If you're intending to run the PostgreSQL server, be sure to either reboot or run ''systemd-sysusers'' & ''systemd-tmpfiles --create'' before doing so. 
-</WRAP> +</bootnote>
-  +
- +
-<code> +
-groupadd -g 41 postgres +
-useradd  -c "PostgreSQL Server" -g postgres -d /srv/pgsql/data \  +
-         -u 41 postgres  +
- +
-install -v -dm700 /srv/pgsql/data +
-install -v -dm755 /run/postgresql +
- +
-chown -Rv postgres:postgres /srv/pgsql /run/postgresql +
-</code>+
  
 ===== Initial Configuration ===== ===== Initial Configuration =====
Line 73: Line 61:
 In situations where you want database users to be able to connect over the network, and don't want to do [[https://stackoverflow.com/a/16838293/16892221|SSH tunneling]], you can configure PostgreSQL to accept remote connections.  In situations where you want database users to be able to connect over the network, and don't want to do [[https://stackoverflow.com/a/16838293/16892221|SSH tunneling]], you can configure PostgreSQL to accept remote connections. 
  
-<WRAP center round important 60%>+<bootnote critical>
 It is highly recommended you also follow the [[postgresql#Require password for login|Require password]] for login configuration steps. It is highly recommended you also follow the [[postgresql#Require password for login|Require password]] for login configuration steps.
-</WRAP>+</bootnote>
    
  
Line 86: Line 74:
 ... ...
 </code> </code>
-<WRAP center round tip 60%>+<bootnote tip>
 You can use ''*'' to listen on all addresses. You can use ''*'' to listen on all addresses.
-</WRAP>+</bootnote>
  
  
Line 99: Line 87:
 ... ...
 </code> </code>
-<WRAP center round tip 60%>+<bootnote tip>
 You can accept all connections by using ''0.0.0.0/0'' as the IP address. You can accept all connections by using ''0.0.0.0/0'' as the IP address.
-</WRAP>+</bootnote>
  
  
  • postgresql.txt
  • Last modified: 2023/08/11 22:50
  • by evie