I need to do the following to add the "admin" account the Global Administrators of JIRA permission:
https://confluence.atlassian.com/display/JIRA052/Retrieving+the+JIRA+Administrator
However, I kept getting "No relations found." doing \dt. Shouldn't the "public" schema has the JIRA tables?
bash-3.2$ id
uid=863(postgres) gid=25(eng) groups=25(eng)
bash-3.2$ psql -U jirauser -d jiradb -W
Password for user jirauser:
Welcome to psql 8.3.23, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
jiradb=> \dt
No relations found.
jiradb=> \l+
List of databases
Name | Owner | Encoding | Tablespace | Description
-----------+----------+----------+------------+---------------------------
jiradb | jirauser | UTF8 | pg_default |
postgres | postgres | UTF8 | pg_default |
template0 | postgres | UTF8 | pg_default |
template1 | postgres | UTF8 | pg_default | default template database
(4 rows)
jiradb=> \dn+
List of schemas
Name | Owner | Access privileges | Description
--------------------+----------+--------------------------------------------------------+----------------------------------
information_schema | postgres | {postgres=UC/postgres,=U/postgres} |
pg_catalog | postgres | {postgres=UC/postgres,=U/postgres} | system catalog schema
pg_toast | postgres | | reserved schema for TOAST tables
pg_toast_temp_1 | postgres | |
pg_toast_temp_7 | postgres | |
public | postgres | {postgres=UC/postgres,=UC/postgres,tableau=U/postgres} | standard public schema
(6 rows)
jiradb=> \dt public.*
No matching relations found.
jiradb=>
jiradb=> \du
List of roles
Role name | Superuser | Create role | Create DB | Connections | Member of
-----------+-----------+-------------+-----------+-------------+-----------
jirauser | no | no | no | no limit | {}
postgres | yes | yes | yes | no limit | {}
tableau | no | no | no | no limit | {}
(3 rows)
Thank you.
-Indra
