Learning how to paginate over data using a cursor
- sudo apt update
- sudo apt install postgresql postgresql-contrib
- sudo systemctl start postgresql.service
- sudo -u postgres createuser <user_name>
- sudo -u postgres createdb <db_name>
- sudo -u postgres psql
- psql=# alter user ssahu with encrypted password โโ
- cd /etc/postgresql/12/main
- vi postgresql.conf
- subsection: # - Connection Settings -
- edit listen_addresses = '*' # what IP address(es) to listen on;
- vi pg_hba.conf
- subsection # IPv4 local connections:
- host all all all trust
- service postgresql restart