Monthly Archives: October 2024

ubuntu 24 install postgresql 17

apt install postgresql-common
/usr/share/postgresql-common/pgdg/apt.postgresql.org.sh

apt update && apt upgrade
apt install postgresql-17

pg_ctlcluster 17 main start
pg_ctlcluster 17 main status
pg_ctl: server is running (PID: 1028)
/usr/lib/postgresql/17/bin/postgres "-D" "/var/lib/postgresql/17/main" "-c" "config_file=/etc/postgresql/17/main/postgresql.conf"

vim /etc/postgresql/17/main/pg_hba.conf
host all all 0.0.0.0/0 md5
host all all ::/0 md5

vim /etc/postgresql/17/main/postgresql.conf
listen_addresses = '*'

pg_ctlcluster 17 main restart

posthog plugin server ยท node error


Error: Encryption keys are not set\n at new EncryptedFields (/code/plugin-server/dist/cdp/encryption-utils.js:10:19)\n at createHub (/code/plugin-server/dist/utils/db/hub.js:183:26)\n at async setupHub (/code/plugin-server/dist/main/pluginsServer.js:156:34)

bash -c "$(curl -fsSL https://raw.githubusercontent.com/posthog/posthog/HEAD/bin/deploy-hobby)"
Try older release instead of latest: d009c8a5b3e1310947711f543ebd2ee63984a1bc