Hallo zusammen,
aus irgendeinem Grund wird plötzlich eine Datenbank “central_db” nicht mehr im PgAdmin 4 v3.5 angezeigt. Die Datenbank selbst ist allerdings noch da und scheint auch ohne schwierigkeiten zu funktionieren. Die Anmeldung am PostgreSQL Server erfolgt mit dem user “postgres”, dieser ist / hat SuperUser Rechte.
Könnt ihr bitte helfen.
Vielen Dank im voraus
muku
$ sudo -u postgres psql -d central_db
could not change directory to "/home/dsmn": Permission denied
psql (9.4.15)
Type "help" for help.
central_db=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
------------+----------+----------+-------------+-------------+-----------------------
central_db | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/postgres +
| | | | | dwh_etl=c/postgres +
| | | | | central=CTc/postgres
dma_live | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/postgres +
| | | | | postgres=CTc/postgres
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres=CTc/postgres+
| | | | | =c/postgres
(5 rows)
central_db=# SELECT grantee, privilege_type
FROM information_schema.role_table_grants
WHERE table_name='transaction_billing';
grantee | privilege_type
---------+----------------
central | INSERT
central | SELECT
central | UPDATE
central | DELETE
central | TRUNCATE
central | REFERENCES
central | TRIGGER
(7 rows)
central_db=# \dt
List of relations
Schema | Name | Type | Owner
--------+------------------------------+-------+----------
public | billing_text | table | central
public | client_organization | table | central
public | external_service_call_status | table | postgres
public | processing_file | table | central
public | scoring_log | table | central
public | scoring_log_param | table | central
public | scoring_log_slot | table | central
public | transaction_billing | table | central
public | transaction_billing_movement | table | central
(9 rows)