Following up on timescaledb extra steps to install/configure - Githubissues

RedisLabsModules / automata

MIT License

2 stars 1 forks source link

Following up on timescaledb extra steps to install/configure #5

Open filipecosta90 opened 3 years ago

filipecosta90 commented 3 years ago

@chayim I've bumped into some issues that got resolved after doing the following changes

installation extra steps

changed ppa:timescale/timescaledb-ppa to ppa:timescale/timescaledb-ppa2
Issue related to the one I got, and that was solved by installing acl. https://github.com/georchestra/ansible/issues/55
For some reason thee timescaledb-tune was not present on my installation.

apt install acl
add-apt-repository ppa:timescale/timescaledb-ppa2
go get github.com/timescale/timescaledb-tune/cmd/timescaledb-tune
./go/bin/timescaledb-tune --yes --quiet

configure

# Within /etc/postgresql/13/main/postgresql.conf
listen_addresses = '*'

# Within /etc/postgresql/13/main/pg_hba.conf
ostnossl    all          all            0.0.0.0/0  trust

psql -c "alter user postgres with password 'postgres'"

chayim commented 3 years ago

Can you tell me what the issues were? Our current installation brings down timescale2 and pgsql13, changing the password to the default in the pgsql role (see ansible/roles/postgresql/defaults/main.yml).