What kind of client authentication when connecting to a local instance?

[Seddryck]

I'm a bit struggling to connect to a local instance of GlareDB. I'm successful with psql but not with the Npgsql data provider in .NET. Could you confirm if the client authentication is Trust Authentication?

[64J0]

I'm also having trouble using npgsql!

It does not work with dbeaver too.

But it works with psql.

[talagluck]

Thanks for opening this issue @Seddryck and thanks for adding, @64J0!

We don't recommend the local server use-case for anything aside from testing, really, and we haven't tested it much with other tools.

@64J0, are your issues with npgsql and dbeaver for the local server, or for GlareDB Cloud? What errors are you getting?

[64J0]

@64J0, are your issues with npgsql and dbeaver for the local server, or for GlareDB Cloud? What errors are you getting?

For the local server. It's related to the protocol these tools use. I did open an issue at the npgsql repo as well -> npgsql/npgsql#5809.

[talagluck]

Thanks for the update, @64J0!

We're currently working on the connection to dbeaver. The error I'm hitting:

SQL Error [XX000]: ERROR: Error during planning: Invalid function 'format_type'.
Did you mean 'flatten'?

has to do with a Postgres function which hasn't yet been implemented in GlareDB, and so we're working on implementing that now. This is connecting to GlareDB Cloud, rather than the local postgres server.

Could you please share the error you're getting as well as how you're specifying your config?

I'd also love to know more about how you're using the local server - it's not something we really document, and it would be great to understand what need it's meeting.

[Seddryck]

Regarding the use case for the local server instance, I'm trying to use it for some integration tests in our CI/CD pipelines. We don't want these pipelines to rely on remote (especially web) resources.

[talagluck]

Thanks for the follow up, @Seddryck! Has this been blocking your usage of GlareDB?

[talagluck]

I wanted to follow up with our progress here. We have a PR open to implement the function which unblocks the first bug we were hitting (the unimplemented format_type function). The issue is that we're still hitting a second error here due to the connection query generated by DBeaver, and the way that DataFusion handles columns in joins with the same name; it won't be possible for us to resolve this directly.

However, we're in the process of building a new execution engine, which we're planning on merging into this repo in the next month or two. Once we have that, we should be able to bypass this issue entirely.

Thanks for your patience, and please let me know if there's anything else we can do to help!