PostgreSQL

Raspbian PostgreSQL server

PostgreSQL server on Raspbian

PostgreSQL select Text field

select convert_from(loread(lo_open(some-text-field::int, x'40000'::int), x'40000'::int),  'UTF8') from candidate;

PostgreSQL change default password

sudo -u postgres psql
\password postgres

PostgreSQL create user

CREATE USER name WITH PASSWORD 'password';

PostgreSQL remote access

postgresql.conf

listen_addresses = 'localhost,$LISTENING_IP'

pg_hba.conf

host    all             all             192.168.1.0/24          md5
sudo /etc/init.d/postgresql restart
sudo pg_ctlcluster 12 main start
sudo systemctl status postgresql@12-main

pgAdmin4 telepítése

How-to install pgAdmin-4 on Ubuntu 20.04Lts Linux