Should work without superuser
Closed this issue · 3 comments
pgsh 0.10.6
Hosted SQL often comes without superuser access. It'd be useful to use pgsh with a hosted DB. pgsh init fails if a superuser is not supplied: it'd be nice if it succeeded and put pgsh into a limited functionality mode.
Can you expand a bit on your use case / the context for using a hosted database without superuser access during development? I want to make sure I understand the rationale behind this request so I can understand exactly what a limited functionality mode might look like.
@bryanlarsen are you able to run the following for your user? Working on a patch now that would check for the required permissions rather than explicitly for superuser.
GRANT EXECUTE ON FUNCTION pg_stat_file(text) TO ?;
ALTER ROLE ? CREATEDB;Was trying to look through the RDS documentation but not sure if pg_stat_file is something you'll be able to get -- if not, I can hide it behind a check as well :)