Related to https://canary.discord.com/channels/465764339174080512/1277614467399680060

Currently a new server, with a fresh install of postgres 17 (other versions may be impacted) creates users with no permissions. To manually fix:

# log into an account with sudo, likely `ploi`)
ssh ploi@ipaddress

# jump into postgres (you'll need the sudo password)
sudo -u postgres psql

# show your users (make a note of which user you want to use for dbuser below)
\du

# connect to your database(s)
\c databasename

# grant permissions (change dbuser to your user)
GRANT CREATE ON SCHEMA public TO dbuser;
GRANT USAGE ON SCHEMA public TO dbuser;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO dbuser;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO dbuser;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO dbuser;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO dbuser;

### DONE ###

This doesn't help any future users, though, as this process will have to be run again for any new users/databases

Fix Postgres 17 user permissions

1 total vote
Quick Actions
Activity
View recent activity and updates
Use arrow keys to navigate