can't connect with dbeaver postgres - can connect with psql

[joshuascottpaul]

can't connect with dbeaver postgres - can connect with psql

dbeaver config: localhost, 5432, nc_timebilling.db

error: can't connect with dbeaver postgres - no databases found on the server

works: $ psql --host localhost nc_timebilling.db

[benbjohnson]

Thanks for the bug report. Do you see any activity in the postlite log?

[joshuascottpaul]

when i connect with psql $ psql --host localhost nc_timebilling.db psql (14.2, server 13.0.0) Type "help" for help.

nc_timebilling.db=>

$ postlite -data-dir /Users/jpaul/Desktop listening on :5432 connection accepted: 127.0.0.1:53331 received ssl request message: &pgproto3.SSLRequest{} received startup message: &pgproto3.StartupMessage{ProtocolVersion:0x30000, Parameters:map[string]string{"application_name":"psql", "client_encoding":"UTF8", "database":"nc_timebilling.db", "user":"jpaul"}}

when i connect with dbeaver

$ postlite -data-dir /Users/jpaul/Desktop listening on :5432 connection accepted: 127.0.0.1:53313 received ssl request message: &pgproto3.SSLRequest{} received startup message: &pgproto3.StartupMessage{ProtocolVersion:0x30000, Parameters:map[string]string{"DateStyle":"ISO", "TimeZone":"America/Vancouver", "client_encoding":"UTF8", "database":"nc_timebilling.db", "extra_float_digits":"2", "user":"jpaul"}} [recv] &pgproto3.Parse{Name:"", Query:"SET extra_float_digits = 3", ParameterOIDs:[]uint32(nil)} query rewrite: SELECT 'SET' [recv(p)] &pgproto3.Bind{DestinationPortal:"", PreparedStatement:"", ParameterFormatCodes:[]int16(nil), Parameters:[][]uint8(nil), ResultFormatCodes:[]int16{}} [recv(p)] &pgproto3.Execute{Portal:"", MaxRows:0x1} [recv] &pgproto3.Sync{} [recv] &pgproto3.Parse{Name:"", Query:"SET application_name = 'PostgreSQL JDBC Driver'", ParameterOIDs:[]uint32(nil)} query rewrite: SELECT 'SET' [recv(p)] &pgproto3.Bind{DestinationPortal:"", PreparedStatement:"", ParameterFormatCodes:[]int16(nil), Parameters:[][]uint8(nil), ResultFormatCodes:[]int16{}} [recv(p)] &pgproto3.Execute{Portal:"", MaxRows:0x1} [recv] &pgproto3.Sync{} [recv] &pgproto3.Parse{Name:"", Query:"SET application_name = 'DBeaver 22.0.2 - Read PostgreSQL database list'", ParameterOIDs:[]uint32(nil)} query rewrite: SELECT 'SET' [recv(p)] &pgproto3.Bind{DestinationPortal:"", PreparedStatement:"", ParameterFormatCodes:[]int16(nil), Parameters:[][]uint8(nil), ResultFormatCodes:[]int16{}} [recv(p)] &pgproto3.Execute{Portal:"", MaxRows:0x1} [recv] &pgproto3.Sync{} [recv] &pgproto3.Parse{Name:"", Query:"SELECT db.oid,db.* FROM pg_catalog.pg_database db WHERE 1 = 1 AND datallowconn AND NOT datistemplate OR db.datname =$1\nORDER BY db.datname", ParameterOIDs:[]uint32{0x413}} [recv(p)] &pgproto3.Bind{DestinationPortal:"", PreparedStatement:"", ParameterFormatCodes:[]int16{0}, Parameters:[][]uint8{[]uint8{0x6e, 0x63, 0x5f, 0x74, 0x69, 0x6d, 0x65, 0x62, 0x69, 0x6c, 0x6c, 0x69, 0x6e, 0x67, 0x2e, 0x64, 0x62}}, ResultFormatCodes:[]int16{}} [recv(p)] &pgproto3.Describe{ObjectType:0x50, Name:""} [recv(p)] &pgproto3.Execute{Portal:"", MaxRows:0x0} [recv] &pgproto3.Sync{} [recv] &pgproto3.Terminate{} connection closed: 127.0.0.1:53313 ^CSIGINT received, shutting down accept tcp [::]:5432: use of closed network connection