PostgreSQL: Stop using public schema

[toonsevrin]

This may not be relevant for a lot of people, but by default k3s/kine creates it's tables under the public schema. As you may or may not know, any user in the database can thus access this data by default.

As k3s is mainly for small clusters, I doubt users care about this level of isolation, but in my case I definitely do 😆.

Is it possible to specify another schema then public with the postgresql endpoint?

Thanks a lot!!!

[toonsevrin]

I'd like to clarify that running the following sequency during database bootstrapping does solve this problem. But it would be nice to be able to enforce this from the consumer side (if this sql is not ran for any reason, the public schema is used again).

CREATE SCHEMA k3s;
ALTER DATABASE db SET search_path to k3s;

[fapatel1]

Looks like this was resolved from the PR above (k3s-io/kine#40)

[brandond]

That's an issue, not a PR. Nothing has been changed to allow this. If you'd like to see this fixed, it will require changes to kine. A PR would be welcome.