Nick Verlinden wrote:This is the procedure I used to set up a shared db on my Synology NAS. Maybe the procedure can be used directly on QNAP, but I would'nt know. I don't have one.
Resolve 14 Database Setup On Synology NAS
1. Enable SSH access on Synology NAS
2. SSH to nas and log in with the account you created during nas setup
3. sudo su - (Use same password as user account)
4. su – postgres
5. createuser –d –a –P resolve
a. Enter password: DaVinci
6. edit the file /etc/postgresql/pg_hba.conf
7. add a line to allow the set of IPs of your LAN/WAN that can connect
a. host all all 192.168.1.0/24 trust
8. Modify the config file /etc/postgresql/postgresql.conf and allow all connection as by default only local host can connect to the service. That is done by changing to this: listen_addresses = ’*’
9. Pg_ctl –m fast restart
10. Perform commands in psql (copy paste these commands to notepad, remove spaces at end of each line, and paste in terminal):
a. update pg_database set datallowconn = TRUE where datname = 'template0';
b. \c template0
c. update pg_database set datistemplate = FALSE where datname = 'template1';
d. drop database template1;
e. create database template1 with encoding = 'UTF-8' lc_collate = 'en_US.UTF8' lc_ctype = 'en_US.UTF8' template = template0;
f. update pg_database set datistemplate = TRUE where datname = 'template1';
g. \c template1
h. update pg_database set datallowconn = FALSE where datname = 'template0';
i. \q
11. Create resolve user database
a. createdb -E UTF8 -O resolve resolve
12. Restart your Synology NAS
13. In DaVinci resolve project manager, click "New Database" and enter following data in the "create" tab:
TYPE: PostgreSQL
Name: resolve14
Location: [DNS NAME OF YOUR NAS HERE]
Username: resolve
Password: DaVinci
Click the "Create" button.
Hi Nick,
I'm about to use the method you listed to create a shared postgreSQL database on my Synology NAS. A couple of questions I'm clueless about.
1. Do you need to install postgreSQL on the Synology or does it come pre-installed? I have the model DS3018xs which is relatively new and has the latest DSM installed.
2. Have you setup an automatic backup for the database? Or do you know of a way of doing it once it's setup?
3. Is it better or have you tried a VM as a database server inside the Synology? I can kind of imagine a use case where if the Synology fails and yo have the VM backed up on an external drive for example, recovering the database could be done pretty quickly right? All you have to do is run backed up VM in one of your computers or a replacement Synology and be up and running in no time.
I mainly work on feature films and have ongoing work on multiple films at any given time. A failed database or a failed Synology could be fairly disastrous. Just trying to think ahead of a worry free shared database before I decide the Synology route.
Any suggestions would be appreciated.
Cheers.
Din