timescaledb-wale
timescaledb-wale copied to clipboard
timescale
Timescale wale waiting to start
Hi Guys -
I am working with two docker containers: the first being your official timescale container and the second being this wale sidecar. What I am trying to accomplish is daily backups using a google cloud bucket.
My steps so far have been thus:
- Create a google application credentials json
- Reference this json in a .env file. My .env file looks like this:
PGDATA=/media/timescale-data/pgdata PGCONF_BACKUP_DIR=/media/timescale-data/pgconf START_MODE=BACKUP_PUSH WALE_GS_PREFIX=gs://walbackups/timescale GOOGLE_APPLICATION_CREDENTIALS=./service_account.json - Next I run the wale container with this command:
sudo docker run -v TimescaleVolume:/media/timescale --env-file=.env timescale/timescaledb -wale - I mounted a persistent volume to persisent the data through container restarts (this works)
- Finally I try starting the timescale container, referencing the same env file and volume:
sudo docker run -d -p 5434:5432 -v TimescaleVolume:/media/timescale-data --env-file .env timescale/timescaledb
Are there any obvious steps I am missing? I did not modify any postgres configuration files. Perhaps that is what I am missing.
Thanks a lot for your help, Tyler
Update: It seems env variables are not being passed in properly:
After trying this command:
sudo docker exec be6ab0b6cbb0 wal-e backup-list
I get:
ERROR MSG: no storage prefix defined HINT: Either set one of the --wabs-prefix or --s3-prefix options or define one of the WALE_WABS_PREFIX, WAL E_S3_PREFIX, or WALE_SWIFT_PREFIX environment variables.
I tried passing in the WALE_GS_PREFIX specifically through -e WALE_GS_PREFIX=gs://walbackups/timescale
Any clue why this would be? Is GS not supported by your container? Thanks.
Ok I definitely need to add a WALE_INIT_LOCKFILE. will update after trying this.
Yes I am still getting the same error:
ERROR MSG: no storage prefix defined HINT: Either set one of the --wabs-prefix or --s3-prefix options or define one of the WALE_WABS_PREFIX, WAL E_S3_PREFIX, or WALE_SWIFT_PREFIX environment variables.
Clearly the env file is being read, but is not parsing the WALE_GS_PREFIX var
I think this image is not supporting GS. I can see from the original code base that GS storage was only recently added.
