[root@hs-10-20-30-199 ~]# su - lightdb Last login: Wed May 25 13:16:32 CST 2022 from 10.188.120.129 on pts/10 [lightdb@hs-10-20-30-199 ~]$ ltsql ltsql: error: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.LIGHTDB.5432"? [lightdb@hs-10-20-30-199 ~]$ ltsql -p8000 ltsql (13.3-22.2) Type "help" for help. lightdb@postgres=# create database ltdb; NOTICE: Canopy partially supports CREATE DATABASE for distributed databases DETAIL: Canopy does not propagate CREATE DATABASE command to workers HINT: You can manually create a database and its extensions on workers. CREATE DATABASE lightdb@postgres=# create user ltuser with password 'ltpwd'; NOTICE: not propagating CREATE ROLE/USER commands to worker nodes HINT: Connect to worker nodes directly to manually create all necessary users and roles. CREATE ROLE lightdb@postgres=# alter database ltdb owner to ltuser; ALTER DATABASE lightdb@postgres=# exit [lightdb@hs-10-20-30-199 ~]$ ltsql -Ultuser -p8000 ltsql (13.3-22.2) Type "help" for help. ltuser@postgres=> select current_user; current_user -------------- ltuser (1 row)