dbeaver

How to filter table data:

For example filters price that stars with 14

... AND price LIKE '14%'

 

How to search for multiple table:

product_product && product_template

Connecting to psql remotely dbeaver

The server requested SCRAM-based authentication, but no password was provided.
 Solution: Add progress password

 

$ sudo su - postgres
$ psql

 ALTER USER "postgres" WITH PASSWORD 'password';

 

 

FATAL: no pg_hba.conf entry for host "xx.xx.xx.xxx", user "postgres", database "postgres", SSL on

How to solve this error on dbeaver:

Find out where is your hba file:

$ sudo -u postgres psql 
postgres=# show hba_file;

 /etc/postgresql/13/main/pg_hba.conf

# Add at bottom your eg:  IP  111.111.11.11/21  trust
hostnossl    all          all            0.0.0.0/0  trust

Restarting service:

# /etc/init.d/postgresql restart

# service postgresql restart

Opening port

Firstly check if port is open:

$ namp -p 5432

Opening port to ubuntu 20.04

# nano /etc/postgresql/12/main/postgresql.conf

# Uncomment

Added listen_addresses = '*'

# Restart postgress Service

service postgresql restart