Hi,
we have a raspberry pi 4 system and want to install timescaledb via docker.
The docker installation is working, hello-world is also starting.
But when pulling and running timescaledb:2.9.3-pg14 (docker run -d --name timescaledb -p 5432:5432 -e POSTGRES_PASSWORD=postgres timescale/timescaledb:2.9.3-pg14
) the container stops after some seconds and following log has been created:
{"log":"The files belonging to this database system will be owned by user \"postgres\".\n","stream":"stdout","time":"2024-02-21T07:55:41.469412786Z"}
{"log":"This user must also own the server process.\n","stream":"stdout","time":"2024-02-21T07:55:41.469575969Z"}
{"log":"\n","stream":"stdout","time":"2024-02-21T07:55:41.469604635Z"}
{"log":"The database cluster will be initialized with locale \"de_AT.UTF-8\".\n","stream":"stdout","time":"2024-02-21T07:55:41.469732392Z"}
{"log":"The default database encoding has accordingly been set to \"UTF8\".\n","stream":"stdout","time":"2024-02-21T07:55:41.469774725Z"}
{"log":"The default text search configuration will be set to \"german\".\n","stream":"stdout","time":"2024-02-21T07:55:41.46980178Z"}
{"log":"\n","stream":"stdout","time":"2024-02-21T07:55:41.46982728Z"}
{"log":"Data page checksums are disabled.\n","stream":"stdout","time":"2024-02-21T07:55:41.469850595Z"}
{"log":"\n","stream":"stdout","time":"2024-02-21T07:55:41.469972371Z"}
{"log":"fixing permissions on existing directory /var/lib/postgresql/data ... ok\n","stream":"stdout","time":"2024-02-21T07:55:41.470135961Z"}
{"log":"creating subdirectories ... ok\n","stream":"stdout","time":"2024-02-21T07:55:41.472492208Z"}
{"log":"selecting dynamic shared memory implementation ... posix\n","stream":"stdout","time":"2024-02-21T07:55:41.472837241Z"}
{"log":"selecting default max_connections ... 100\n","stream":"stdout","time":"2024-02-21T07:55:41.521976322Z"}
{"log":"selecting default shared_buffers ... 128MB\n","stream":"stdout","time":"2024-02-21T07:55:41.600063674Z"}
{"log":"selecting default time zone ... GMT\n","stream":"stdout","time":"2024-02-21T07:55:41.600159006Z"}
{"log":"creating configuration files ... ok\n","stream":"stdout","time":"2024-02-21T07:55:41.607900535Z"}
{"log":"running bootstrap script ... ok\n","stream":"stdout","time":"2024-02-21T07:55:42.146792025Z"}
{"log":"sh: locale: not found\n","stream":"stderr","time":"2024-02-21T07:55:43.346926076Z"}
{"log":"1970-04-30 22:50:40.010 GMT [30] WARNING: no usable system locales were found\n","stream":"stderr","time":"2024-02-21T07:55:43.347382441Z"}
{"log":"performing post-bootstrap initialization ... ok\n","stream":"stdout","time":"2024-02-21T07:55:45.39833749Z"}
{"log":"syncing data to disk ... ok\n","stream":"stdout","time":"2024-02-21T07:55:46.785544194Z"}
{"log":"\n","stream":"stdout","time":"2024-02-21T07:55:46.785623026Z"}
{"log":"initdb: warning: enabling \"trust\" authentication for local connections\n","stream":"stderr","time":"2024-02-21T07:55:46.785917097Z"}
{"log":"You can change this by editing pg_hba.conf or using the option -A, or\n","stream":"stderr","time":"2024-02-21T07:55:46.785983948Z"}
{"log":"--auth-local and --auth-host, the next time you run initdb.\n","stream":"stderr","time":"2024-02-21T07:55:46.78601254Z"}
{"log":"\n","stream":"stdout","time":"2024-02-21T07:55:46.786089057Z"}
{"log":"Success. You can now start the database server using:\n","stream":"stdout","time":"2024-02-21T07:55:46.786130279Z"}
{"log":"\n","stream":"stdout","time":"2024-02-21T07:55:46.786166927Z"}
{"log":" pg_ctl -D /var/lib/postgresql/data -l logfile start\n","stream":"stdout","time":"2024-02-21T07:55:46.78619276Z"}
{"log":"\n","stream":"stdout","time":"2024-02-21T07:55:46.786217167Z"}
{"log":"waiting for server to start....1970-05-10 01:17:52.011 GMT [36] LOG: starting PostgreSQL 14.6 on arm-unknown-linux-musleabihf, compiled by gcc (Alpine 12.2.1_git20220924-r4) 12.2.1 20220924, 32-bit\n","stream":"stdout","time":"2024-02-21T07:55:46.931290622Z"}
{"log":"1970-05-10 01:17:52.011 GMT [36] LOG: listening on Unix socket \"/var/run/postgresql/.s.PGSQL.5432\"\n","stream":"stdout","time":"2024-02-21T07:55:46.936803402Z"}
{"log":"...1970-05-10 01:17:52.011 GMT [36] LOG: startup process (PID 37) was terminated by signal 11: Segmentation fault\n","stream":"stdout","time":"2024-02-21T07:55:49.965505283Z"}
{"log":"1970-05-10 01:17:52.011 GMT [36] LOG: aborting startup due to startup process failure\n","stream":"stdout","time":"2024-02-21T07:55:49.965624985Z"}
{"log":"1970-05-10 01:17:52.011 GMT [36] LOG: database system is shut down\n","stream":"stdout","time":"2024-02-21T07:55:50.091043028Z"}
{"log":" stopped waiting\n","stream":"stdout","time":"2024-02-21T07:55:50.156873694Z"}
{"log":"pg_ctl: could not start server\n","stream":"stderr","time":"2024-02-21T07:55:50.156994785Z"}
{"log":"Examine the log output.\n","stream":"stderr","time":"2024-02-21T07:55:50.157036692Z"}
I tried it also with newer images (timescaledb:latest-pg15), same result.
Our system:
Raspberry Pi 4 Model B Rev 1.4
PRETTY_NAME=“Raspbian GNU/Linux 10 (buster)”
Client: Docker Engine - Community
Version: 25.0.3
API version: 1.44
Go version: go1.21.6
Git commit: 4debf41
Built: Tue Feb 6 21:20:24 2024
OS/Arch: linux/arm
Context: default
Server: Docker Engine - Community
Engine:
Version: 25.0.3
API version: 1.44 (minimum version 1.24)
Go version: go1.21.6
Git commit: f417435
Built: Tue Feb 6 21:20:24 2024
OS/Arch: linux/arm
Experimental: false
containerd:
Version: 1.6.28
GitCommit: ae07eda36dd25f8a1b98dfbf587313b99c0190bb
runc:
Version: 1.1.12
GitCommit: v1.1.12-0-g51d5e94
docker-init:
Version: 0.19.0
GitCommit: de40ad0
Can someone help me to get it running?
Thanks,
Christian