First import the public storage GPG key $sudo wget -qO- c | sudo apt-key add – 2. Register the MS-SQL Server repository $sudo add-apt-repository "$(wget -qO- " 3. Install SQL Server $sudo apt-get update $sudo apt-get install -y mssql-server 4. Execute msqql-conf setup to set the SA password and select the version. $sudo /opt/mssql/bin/mssql-conf setup Linux MsSQL & PostgreSQL Linux MsSQL & PostgreSQL Linux MsSQL & PostgreSQL 5.
Confirm that the service is executing $sudo systemctl status mssql-server.service –no-pager Linux MsSQL & PostgreSQL 6. Remember to enable the bot dataset firewall $sudo ufw allow 1433 PostgreSQL installation process: 1. Package update $sudo apt-get update 2. Install the package $sudo apt-get install wget ca-certificates 3. Install PostgreSQL’s GPG-Key $wget –quiet -O – Add Repository $sudo sh -c 'echo "deb lsb_release -cs-pgdg main" >> /etc/apt/sources.list. d/pgdg.list' 5.
Update the package again $sudo apt-get update Linux MsSQL & PostgreSQL 6. Install Postgesql $sudo apt-get install -y postgresql postgresql-contrib 7. r the port number $sudo vim /etc/postgresql/13/main/postgresql.conf and change the monitored IP location to "*" to allow external users to read the database. Linux MsSQL & PostgreSQL Save the modified configuration file and then restart the service.