Q: How do I connect to sqld via psql ?

[tjyang]

• According to Performance Testing doc
  we can use psql to test out slqd running on port 5432.

psql -h 127.0.0.1 -p 5432 < pg_bench_schema.sql

• Here is the error message

[me@rocky9t01a pgbench]$ pwd;ls -lrt;psql -h 192.168.1.234  -p 5432  < pg_bench_schema.sql
/home/me/github/learn-tursodatabase/libsql/libsql-server/perf/pgbench
total 12
-rw-r--r-- 1 me me 195 Nov 24 10:18 README.md
-rw-r--r-- 1 me me  21 Nov 24 10:18 pg_bench_script.sql
-rw-r--r-- 1 me me 122 Nov 24 10:18 pg_bench_schema.sql
psql: error: connection to server at "192.168.1.234", port 5432 failed: received invalid response to SSL negotiation: H
[me@rocky9t01a pgbench]$

• sqld version

[me@rocky9t01a ~]$ sqld -V
sqld sqld 0.22.6 (19c5cb7b 2023-11-24)
[me@rocky9t01a ~]$

• running sqld

[me@rocky9t01a ~]$ netstat -antulp |grep 5432
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
tcp        0      0 192.168.1.234:5432      0.0.0.0:*               LISTEN      374367/sqld
tcp        0      0 192.168.1.234:36412     192.168.1.234:5432      TIME_WAIT   -
tcp        0      0 192.168.1.234:5432      192.168.1.234:49542     TIME_WAIT   -
[me@rocky9t01a pgbench]$ nc -zv 192.168.1.234 5432
Ncat: Version 7.92 ( https://nmap.org/ncat )
Ncat: Connected to 192.168.1.234:5432.
Ncat: 0 bytes sent, 0 bytes received in 0.04 seconds.
[me@rocky9t01a pgbench]$

• end