Role permissions for postgres?

[shaun]

We need to run some postgres commands making a table and inserting rows locally, ideally before the first deployment.

You could leverage the release_command configuration option within your fly.toml file.

Fly Launch configuration (fly.toml)

If you have already attached the PG to your app, you should be able to call a script via the release_command to handle the migration/seed process. As long as the script leverages the DATABASE_URL envvar to establish the connection you shouldn’t run into any permissions issues.

With regards to the permission issues, this may help provide some context with whats going on there.

Sidekiq worker insufficient Postgres privileges

Hey @julianrubisch, When a table is created it will receive an owner, which is typically the user who created the table. \dt List of relations Schema | Name | Type | Owner --------+-------+-------+--------------------- public | names | table | foo public | users | table | foo (2 rows) By default, no other standard users will be able to access the given table until permissions are explicitly granted. There are a number of ways you could address this and it ultimately…

Let me know if you have any questions on this!