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 |