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/02/27 12:30] – 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 76: Line 81:
 </code> </code>
  
-===== Uninstall =====+====== Uninstall PostgreSQL ====== 
 + 
 +Thanks to: https://askubuntu.com/questions/32730/how-to-remove-postgres-from-my-installation
  
-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>
  
 ====== PostgreSQL for DaVinci Resolve ====== ====== PostgreSQL for DaVinci Resolve ======
 +DaVinci Resolve Project Server is the easy and best way to do work sharing and collaboration with resolve. It's supported under windows and mac. The latest version of this can be downloaded from the [[https://www.blackmagicdesign.com/support/family/davinci-resolve-and-fusion|Blackmagic Design support center]] under Latest Downloads.
 +
 +DaVinci Resolve Project Server 17 (Version 17.0), uses ''PostgreSQL 9.5''. To use a remote database (I've got my own virtual server), one can download/install this on a linux machine:
 +
  
   * [[https://www.qnap.com/en-in/how-to/tutorial/article/how-can-i-collaborate-davinci-resolve-studio-16-between-macos-and-windows-in-qts-4-4-3]]   * [[https://www.qnap.com/en-in/how-to/tutorial/article/how-can-i-collaborate-davinci-resolve-studio-16-between-macos-and-windows-in-qts-4-4-3]]
   * https://www.postgresql.org/download/linux/ubuntu/   * https://www.postgresql.org/download/linux/ubuntu/
- 
  
 Add PostgreSQL package repository (taken from: https://www.postgresql.org/download/linux/ubuntu/) Add PostgreSQL package repository (taken from: https://www.postgresql.org/download/linux/ubuntu/)
  • server_configuration/postgres.1614429022.txt.gz
  • Last modified: 2025/03/27 15:42
  • (external edit)