# 🔴 Relacyjna Baza danych PostgreSQL

**URL:** <https://ai-speaker.discourse.group/t/relacyjna-baza-danych-postgresql/1014>\
**Category:** Projekty\
**Created:** [27 Listopad 2020 14:13 UTC](https://ai-speaker.discourse.group/t/relacyjna-baza-danych-postgresql/1014 "2020-11-27T14:13:42Z")\
**Posts on this page:** 1\
**Showing post:** 35

<div class="post-metadata">

**Autor:** ![Cezary.K](https://avatars.discourse-cdn.com/v4/letter/c/a88e4f/32.png) [@Cezary.K](https://ai-speaker.discourse.group/u/Cezary.K)\
**Data wpisu:** [23 Sierpień 2022 11:53 UTC](https://ai-speaker.discourse.group/t/relacyjna-baza-danych-postgresql/1014/35 "2022-08-23T11:53:57Z")

</div>

Czy ktoś jest w stanie podpowiedzieć dlaczego po przejściu na repozytoria Termux nie mogę uruchomić ponownie bazy w/g opisu @jolka ?

```auto
~ $ createuser --superuser --pwprompt ais
Enter password for new role: 
Enter it again: 
createuser: error: connection to server on socket "/data/data/com.termux/files/usr/tmp/.s.PGSQL.5432" failed: FATAL: role "u0_a57" does not exist
~ $ pg_ctl -D $PREFIX/var/lib/postgresql start
pg_ctl: another server might be running; trying to start server anyway
waiting for server to start....2022-08-23 13:43:57.256 CEST [24260] FATAL: lock file "postmaster.pid" already exists
2022-08-23 13:43:57.256 CEST [24260] HINT: Is another postmaster (PID 5148) running in data directory "/data/data/com.termux/files/usr/var/lib/postgresql"?
 stopped waiting
pg_ctl: could not start server
Examine the log output.
~ $ createuser --interactive ais
Shall the new role be a superuser? (y/n) y
createuser: error: connection to server on socket "/data/data/com.termux/files/usr/tmp/.s.PGSQL.5432" failed: FATAL: role "u0_a57" does not exist

```

Z dokumentacji tyle (nie mam kompetencji do zrozumienia co z czym):

 ![obraz](https://global.discourse-cdn.com/free1/uploads/ai_speaker/original/2X/d/da62e8768e8857af9b6ad5b5af69c34cd308d940.png)

> **[DROP ROLE](https://www.postgresql.org/docs/14/sql-droprole.html)**
>
> DROP ROLE DROP ROLE — remove a database role Synopsis DROP ROLE \[IF EXISTS \] name \[, ...\] Description …

> **[22.4. Dropping Roles](https://www.postgresql.org/docs/14/role-removal.html)**
>
> 22.4. Dropping Roles Because roles can own database objects and can hold privileges to access other objects, dropping a role is …

> **[REASSIGN OWNED](https://www.postgresql.org/docs/14/sql-reassign-owned.html)**
>
> REASSIGN OWNED REASSIGN OWNED — change the ownership of database objects owned by a database role Synopsis REASSIGN OWNED BY …

---

_[View the full topic](https://ai-speaker.discourse.group/t/relacyjna-baza-danych-postgresql/1014)._