Postgres is constatnly in running state

[wonderer007]

Postgres is constatnly in running state

=====> clippost_db postgres service information
       Config dir:          /var/lib/dokku/services/postgres/clippost_db/data
       Config options:                               
       Data dir:            /var/lib/dokku/services/postgres/clippost_db/data
       Dsn:                 postgres://postgres:5e864d922777139cfad4ad29c52cbd20@dokku-postgres-clippost-db:5432/clippost_db
       Exposed ports:       -                        
       Id:                  6978fec18661d80586eed441c33ba0a7a43d6cd80e8d4e810104673df22f81b7
       Internal ip:                                  
       Links:               -                        
       Service root:        /var/lib/dokku/services/postgres/clippost_db
       Status:              restarting               
       Version:             postgres:14.1

When I check logs it constantly print

022-03-24 01:58:42.304 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:43.305 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:44.306 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:45.307 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:46.309 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:47.310 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:48.311 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:49.312 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:50.313 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:51.314 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:52.315 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:53.317 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:54.318 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory

I have created another Postgres database and linked to app and that is working fine.

Note: I have installed dokku-mariadb

[josegonzalez]

Was this an existing database or a new one? Did you update anything with this database, the plugin, or was there anything you did recently to it if it was a pre-existing one? You originally posted this in an issue about timescaledb, did you try and use that image?

[wonderer007]

It an existing database. The only change I make I was trying to deploy another app on the same server following this guide

The only one thing I did run this command from github page issues and it was clearly mentioned it can cause issues (which I read later).

sudo wget -O /etc/init/docker.conf https://raw.github.com/dotcloud/docker/master/contrib/init/upstart/docker.conf

[josegonzalez]

So this database is unrelated to that new app I guess?

You restarted docker and the issue started happening immediately, or did you have to manually start anything for the postgres service?

[wonderer007]

Database was related to the app (rails). Then I accidentally run this

sudo wget -O /etc/init/docker.conf https://raw.github.com/dotcloud/docker/master/contrib/init/upstart/docker.conf

Also, installed MariaDB for Wordpress. I was trying to install 2 apps (1 rails and 1 Wordpress) on single server but look like I can't

Then current app (rails app) started showing database connection issue. When I tried to rebuild app it start showing error

022-03-24 01:58:42.304 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:43.305 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:44.306 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory
2022-03-24 01:58:45.307 UTC [29] ERROR:  could not open directory "pg_logical/snapshots": No such file or directory

[josegonzalez]

Two apps should work fine on the same server. My guess is that were running an older version of the postgres plugin and recently updated it, but the db wasn't upgraded past 9.3 or something. Seems it's new for 9.4 and maybe you should be able to manually create it?

What is the output of ls -lah /var/lib/dokku/services/postgres/clippost_db/data?

[josegonzalez]

Closing as there hasn't been any update in a while.