How to retain roles/owns with fly pg import

I tried --no-owner=false, --no-no-owner, --owner, I never seem to have any roles from the source db.

You may be encountering this classic Postgres nuance:

Note that roles are defined at the database cluster level


Since pg_dump dumps [only] a single database, you can’t extract roles with that utility

(fly pg import is just a thin wrapper around pg_dump | psql, so it inherits this same limitation.)

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.