server_configuration:postgres

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
server_configuration:postgres [2021/03/04 09:58] – davidserver_configuration:postgres [2025/03/27 15:42] (current) – external edit 127.0.0.1
Line 9: Line 9:
  
 ==== Installation ==== ==== Installation ====
 +
 +If you don't want the included version, you can use the official apt repository from PostgreSQL: https://www.postgresql.org/download/linux/ubuntu/
  
 <code bash> <code bash>
Line 16: Line 18:
 apt-get update && apt-get upgrade -y apt-get update && apt-get upgrade -y
  
-# Find PostgreSQP versions+# View packages 
 +apt-cache search postgres | grep '^postgresql-*[0-9]* ' 
 + 
 +# Find PostgreSQL versions (old syntax)
 apt-cache search postgres apt-cache search postgres
  
Line 78: Line 83:
 ====== Uninstall PostgreSQL ====== ====== Uninstall PostgreSQL ======
  
-https://askubuntu.com/questions/32730/how-to-remove-postgres-from-my-installation+Thanks to: https://askubuntu.com/questions/32730/how-to-remove-postgres-from-my-installation 
 <code bash> <code bash>
 +# Stop the daemon
 +/etc/init.d/postgresql stop
 +
 sudo apt-get --purge remove postgresql* sudo apt-get --purge remove postgresql*
  
Line 88: Line 97:
  
 # Remove accounts # Remove accounts
-deluser postgres +sudo deluser postgres 
-delgroup postgres+sudo delgroup postgres
  
 # Remove unused packages # Remove unused packages
Line 97: Line 106:
 Remove open firewall port: Remove open firewall port:
 <code bash> <code bash>
-ufw delete allow 5432+sudo ufw delete allow 5432
 </code> </code>
  
  • server_configuration/postgres.1614851891.txt.gz
  • Last modified: 2025/03/27 15:42
  • (external edit)