Database Configuration

Postgresql

Troubleshooting

Connection error

Ref: https://devstudioonline.com/article/configure-postgresql-in-ubuntu-and-connect-with-datagrip

First check the inbound rule of the cloud instance or container where the database was deployed.

Then update:

sudo vim /etc/postgresql/10/main/pg_hba.conf

Add the following:

host all all 0.0.0.0/0 md5

And update:

sudo vim /etc/postgresql/10/main/postgresql.conf

Uncomment the listen_addresses setting and set *:

listen_addresses='*'

Now restart your Postgres service.

sudo service postgresql restart

Cannot install psycopg2

Ref: https://stackoverflow.com/questions/28253681/you-need-to-install-postgresql-server-dev-x-y-for-building-a-server-side-extensi