1 | | oh, btw, I change the permissions before running the command and psql said "GRANT". |
| 1 | more info about the database |
| 2 | |
| 3 | {{{ |
| 4 | mediagoblin-# \du |
| 5 | List of roles |
| 6 | Role name | Attributes | Member of |
| 7 | ---------------+------------------------------------------------+----------- |
| 8 | goblinartists | | {} |
| 9 | mediagoblin | | {} |
| 10 | postgres | Superuser, Create role, Create DB, Replication | {} |
| 11 | |
| 12 | mediagoblin-# \dt |
| 13 | List of relations |
| 14 | Schema | Name | Type | Owner |
| 15 | --------+------------------------+-------+---------- |
| 16 | public | ascii__mediadata | table | postgres |
| 17 | public | core__attachment_files | table | postgres |
| 18 | public | core__file_keynames | table | postgres |
| 19 | public | core__media_comments | table | postgres |
| 20 | public | core__media_entries | table | postgres |
| 21 | public | core__media_tags | table | postgres |
| 22 | public | core__mediafiles | table | postgres |
| 23 | public | core__migrations | table | postgres |
| 24 | public | core__tags | table | postgres |
| 25 | public | core__users | table | postgres |
| 26 | public | image__mediadata | table | postgres |
| 27 | public | video__mediadata | table | postgres |
| 28 | (12 rows) |
| 29 | |
| 30 | mediagoblin-# |
| 31 | }}} |
| 32 | |