Davinci resolve crashes when connecting to Database Postgresql is not configured correctly and blocks remote connections (check steps 2.1 - 2.3)Ģ. Your Postgres port is not open or blocked by your server firewall (open port 5432) PgAdming cannot connect to postgres server. In davinci resolve hit ' New Database', simply select ' PostgreSQL' and enter your database name as name, also enter your serverIP/domain, username and of course your created password.ġ. This makes it easy to manage users, adding new users or removing old users. Optionally create new user in the ' Login/Group Roles' section. Use pgadmin to connect to your newly created postgresql server, by clicking ' Add New Server' on the Dashboard.Ĭreate database.png (20.52 KiB) Viewed 3457 times Then run: Code: Select all \password and enter your desired new password.Įxit back out by typing: Code: Select all \q Login and connect as default user (postgres) Code: Select all sudo -u postgres psql Just add the following at the end of the file:Ĭode: Select all host all all 0.0.0.0/0 md5Again, hit CTRL+O to save, and CTRL+X to exit the editor, if you are using nano editor as I do.Ģ.2 Set password for postgres database user Next edit the ' pg_hba.conf' file which in my case was again located in ' /etc/postgresql/14.1/main/'. Under the tab 'CONNECTIONS AND AUTHENTICATION' remove the number sign ('#') in front of ' listen_addresses' and change it to: Code: Select all listen_addresses = '*' # what IP address(es) to listen on Hit CTRL+O to save, and CTRL+X to exit the editor, if you are using nano editor as I do. Now edit the ' nf' file, which in my case was located in ' /etc/postgresql/14.1/main/'.Ĭode: Select all sudo nano /etc/postgresql/14.1/main/nf (list of all versions with release date: *URL 3*) Code: Select all sudo apt-get install postgresql-14 Install Posgresql 14.x, in my case the newest version is 14.1 Have pgadmin 4 installed on your local machine.ġ.1 Add postgresql repository, since ubuntu repository does not include postgresqlĬreate the file repository configuration:Ĭode: Select all sudo sh -c 'echo "deb $(lsb_release -cs)-pgdg main" > /etc/apt//pgdg.list'Import the repository signing key:Ĭode: Select all wget -quiet -O - | sudo apt-key add -Update the package lists: Make sure your Server Firewall does not block port 5432.Ĥ. (supposedly comming to free version soon)ģ. You can only connect to your database if you have the Studio version of Resolve. Make sure you postgresql version except 14.x installed.Ģ. I hope to help some people with this Tutorial.ġ. Since I could not find any tutorial on how to install a resolve postgresql Database on a Headleass ubuntu server and configure it, I will write one here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |