PostgreSQL

Beküldte pzoli - 2020, szeptember 29 - 5:58du

Raspbian PostgreSQL server

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

sudo -u postgres psql
\password postgres

CREATE USER name WITH PASSWORD 'password';

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