Issue when using postgres as db

[tobiasredel]

I have followed the getting started manual for using postgres but when booting up i see the following error in the logs:

In Connection.php line 825:

could not find driver (Connection: pgsql, SQL: select exists (select 1 from
pg_class c, pg_namespace n where n.nspname = 'public' and c.relname = 'mig
rations' and c.relkind in ('r', 'p') and n.oid = c.relnamespace))

[hektyc]

PostgreSQL internal and external works perfectly fine. Most likely you have something misconfigured in your setup but no one can answer that but you because you didn't provide any information to show how you configured it.

[tobiasredel]

i use docker compose, i removed app urls and db password from the below

m3u-editor:
image: sparkison/m3u-editor:latest
container_name: m3u-editor
environment:
- PUID=$PUID
- PGID=$PGID
- TZ=$TZ
- APP_URL=.....# or http://192.168.0.123 or https://your-custom-tld.com
- REVERB_HOST=........ # or 192.168.0.123 or your-custom-tld.com
- REVERB_SCHEME=https # or https if using custom TLD with https
- ENABLE_POSTGRES=true # <----- start here
- PG_DATABASE=m3ue # <----- DB name
- PG_USER=m3ue # <----- DB user
- PG_PASSWORD=.... # <----- DB password
- PG_PORT=5432 # <----- DB port (optional, defaults to 5432)
- DB_CONNECTION=pgsql # <----- set to pgsql (default is sqlite)
- DB_HOST=localhost # <----- make sure set to localhost
- DB_PORT=5432 # <----- using default Postgres port
- DB_DATABASE=m3ue # <----- should match PG_DATABASE
- DB_USERNAME=m3ue # <----- should match PG_USER
- DB_PASSWORD=..... # <----- should match PG_PASSWORD
volumes:
- $DOCKERDIR/m3ueditor:/var/www/config
- m3u_pgdata:/var/lib/postgresql/data # <----- link volume pgsql data to retain data
restart: unless-stopped
ports:
#- 36400:36400 # app
- 36800:36800 # websockets/broadcasting

[tobiasredel]

Ah, i guess postgres is only available to the dev branch not latest / master, right?

[hektyc]

Yes that is my understanding. PostgreSQL is still only available in dev. Has been working great.

[sparkison]

Ah, i guess postgres is only available to the dev branch not latest / master, right?

Yes, Postgres support is only in the dev branch atm. Was hoping to get a release out last week but didn't have time, so hopefully have something out by this weekend if all goes well...