PostgreSQL
Beküldte pzoli - 2020, szeptember 29 - 5:58du
Raspbian PostgreSQL server
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
- A hozzászóláshoz be kell jelentkezni