Raspberry PI: initializing database failed

[andushow]

Describe the bug Tryiong to start stemapipe as a process in raspberry pi

PRETTY_NAME="Raspbian GNU/Linux 11 (bullseye)"
NAME="Raspbian GNU/Linux"
VERSION_ID="11"
VERSION="11 (bullseye)"
VERSION_CODENAME=bullseye
ID=raspbian
ID_LIKE=debian
HOME_URL="http://www.raspbian.org/"
SUPPORT_URL="http://www.raspbian.org/RaspbianForums"
BUG_REPORT_URL="http://www.raspbian.org/RaspbianBugs"

Steampipe version (steampipe -v) v0.23.1

To reproduce steampipe service start

Expected behavior service starts

Additional context

2024-05-12 09:21:06.689 UTC [INFO]  steampipe [a487]: steampipe start [a487]
2024-05-12 09:21:06.689 UTC [INFO]  steampipe [a487]: Version:   v0.23.1
2024-05-12 09:21:06.689 UTC [INFO]  steampipe [a487]: Log level: TRACE
2024-05-12 09:21:06.689 UTC [INFO]  steampipe [a487]: Log date:  2024-05-12
2024-05-12 09:21:06.689 UTC [INFO]  steampipe [a487]: ********************************************************
2024-05-12 09:21:06.691 UTC [TRACE] steampipe [a487]: parse complete after 1 decode passes
2024-05-12 09:21:06.691 UTC [TRACE] steampipe [a487]: ensureInstallDir /home/pi/.steampipe
2024-05-12 09:21:06.691 UTC [INFO]  steampipe [a487]: ensureDefaultConfigFile
2024-05-12 09:21:06.691 UTC [INFO]  steampipe [a487]: loadConfig is loading connection config
2024-05-12 09:21:06.692 UTC [INFO]  steampipe [a487]: loadConfig calling initializePlugins
2024-05-12 09:21:06.693 UTC [INFO]  steampipe [a487]: loadConfig is loading connection config
2024-05-12 09:21:06.694 UTC [TRACE] steampipe [a487]: startService - listenAddresses=["*"]
2024-05-12 09:21:06.738 UTC [TRACE] steampipe [a487]: initdb start: /home/pi/.steampipe/db/14.2.0/postgres/bin/initdb --auth=trust --username=root --pgdata=/home/pi/.steampipe/db/14.2.0/data --encoding=UTF-8
2024-05-12 09:21:06.739 UTC [TRACE] steampipe [a487]: initdb failed:
2024-05-12 09:21:06.739 UTC [TRACE] steampipe [a487]: initDatabase failed: fork/exec /home/pi/.steampipe/db/14.2.0/postgres/bin/initdb: no such file or directory

[e-gineer]

Hey @andushow ... sorry to hear you hit a bump running Steampipe.

Questions:

1. I'm curious, why are you using raspberry pi to run steampipe? Any specific use case?
2. Does the /home/pi/.steampipe/db/14.2.0/postgres/bin/initdb file actually exist? The error says it does not.
3. If you delete the entire /home/pi/.steampipe directory and try again, do you see the same error?

[andushow]

First of all, is steampipe supposed to work on raspberry ?

[kaidaguerre]

we have not tested Steampipe on a Raspberry Pi