Hi, I recently set up a Postgres database on Koyeb with my first project, and today I can only see the status as “Degraded”. I don’t have any settings for configuring my database. The application works, and the Koyeb interface shows that all systems are operational, but I still cannot access the configuration of my Postgres database.
I tried using the interface with different browsers (Edge and Safari), but it does not make any difference.
Is this a known issue today (even though all systems are apperently operational?)
Thank you
Ps: I’m not allowed to share screenshots, but if required I can provide them.
I’ve actually was debugging issue with your DB. It appears that you changed some settings. Maybe added a new role?
The change worked, but wasn’t properly saved in our log. I was trying to find out why, but couldn’t. I was planning to continue work on it on Monday, but it seems that you’ve deleted the DB.
We will try to improve our UI to better show why the service has “Degraded” status.
Yes, I removed the DB. You can try to recreate the condition with the script I used to set it up. It is a setup for PostgREST, so we need two extra roles:
CREATE SCHEMA IF NOT EXISTS “api”;
CREATE ROLE anon NOLOGIN;
GRANT USAGE ON SCHEMA api TO anon;
– Create tables
CREATE TABLE api.data (
id serial PRIMARY KEY,
title varchar(1000) NOT NULL,
type varchar(30) NOT NULL,
start varchar(10) NOT NULL CHECK ( start ~* ‘^-?\d{4}-\d{2}-\d{2}$’ ),
“end” varchar(10) CHECK ( “end” ~* ‘^(-?\d{4}-\d{2}-\d{2})|(ongoing)$’ )
);
– Grant permissions (eg. select to anon…)
GRANT SELECT ON api.data TO anon;
------------------------------------ Role based auth ------------------------------------
CREATE ROLE “user” NOLOGIN;
GRANT USAGE ON SCHEMA api TO “user”;
– user is our standard, authenticated, user
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA api TO “user”;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA api TO “user”;
– Grant the current DB user to switch to anon and “user” roles
GRANT anon TO CURRENT_USER;
GRANT “user” TO CURRENT_USER;