Skip to content

Can not create a sockets connection to Postgresql #1536

@ClodoaldoPinto

Description

@ClodoaldoPinto

I have SQLTools PostgreSQL/Cockroach Driver version 0.5.7 installed on VSCode 1.106.0. Fedora Linux.

fipe=> select version();
                                                 version                                                  
----------------------------------------------------------------------------------------------------------
 PostgreSQL 18.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 15.2.1 20251022 (Red Hat 15.2.1-3), 64-bit

When I go to "Add new connetion" I choose Postgresql and fill in the fields with socket connection information

Image

But it creates a connection with server and port:

Image

And tries to connect by TCP/IP

[1763035230433] INFO  (ls): Connection instance created for fipe.
    ns: "conn-manager"
[1763035230435] ERROR (ls): Connecting error: {"code":-32001,"data":{"driver":"PostgreSQL","driverOptions":{}},"name":"error"}
    ns: "conn-manager"
[1763035230435] ERROR (ls): Open connection error
    ns: "conn-manager"
[1763035230435] ERROR (ext): ERROR: Error opening connection no pg_hba.conf entry for host "::1", user "fipe", database "fipe", no encryption, {"code":-32001,"data":{"driver":"PostgreSQL","driverOptions":{}}}
    ns: "error-handler"

Operating System: Fedora Linux 43
KDE Plasma Version: 6.5.2
KDE Frameworks Version: 6.19.0
Qt Version: 6.10.0
Kernel Version: 6.17.7-300.fc43.x86_64 (64-bit)
Graphics Platform: Wayland
Processors: 16 × AMD Ryzen 7 5700X 8-Core Processor
Memory: 32 GiB of RAM (31,2 GiB usable)
Graphics Processor: NVIDIA GeForce RTX 3080 Ti
Manufacturer: Gigabyte Technology Co., Ltd.
Product Name: B550M DS3H

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions