Welcome!
This community is for professionals and enthusiasts of our products and services. Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.
This question has been flagged
1
Reply
40
Views
https://help.ubuntu.com/community/PostgreSQL
sudo -u postgres psqlCREATE USER client_[CLIENT_NAME] WITH PASSWORD '[generate a long random password]';
ALTER USER client_[CLIENT_NAME] CREATEDB;
to test login
psql -u [username] psql
Permissions
nano /etc/postgresql/9.5/main/postgresql.conf
change listen to address to *
nano /etc/postgresql/9.5/main/pg_hba.conf
add lines for each server that will connect
host all postgres 220.233.23.1/32 md5
sudo service postgresql restart
| server: az-db-psql-s12.australiaeast.cloudapp.azure.com |
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up