Skip to content

Latest commit

 

History

History
19 lines (16 loc) · 1013 Bytes

README.md

File metadata and controls

19 lines (16 loc) · 1013 Bytes

A collection of PSQL scripts to query sensors.AFRICA's database

Requirements

  1. A URL connection string/parameters to access PostgreSQL htools database; Request from sensors' tech admins
  2. JDBC Driver or postgres client in instances where the scripts are run locally.

Tips

  1. Tools to use: DBeaver ( comments are formated properly when using editors like DBeaver SQL editor and Visual Studio Code )
  2. PostgreSQL clients:
    1. node-postgres
    2. psycopg

Troubleshooting

Working with PostgreSQL on a MAC can be problematic especially when trying to restore backup data. To resolve some of these issues, you could:

  1. Open Terminal and run the command below. 
    sudo mkdir -p /etc/paths.d && echo /Applications/Postgres.app/Contents/Versions/latest/bin | sudo tee /etc/paths.d/postgresapp
  2. Download and install PostgreSQL which sets a lot of configurations for you.