We’re using the managed service for Timescale. We’re trying to implement our own backup implementation where we run a pg_dump on the public schema once a day and have our backups ready in case needed. We have a python script doing this which basically does the following :
pg_dump -Fc -f $FILE postgres://:@:/ -n public -w
The issue is that tables with References do not get their data inserted on the backup. The columns and Indexes, Triggers get backed up but the data does not at all
How can I also backup the references of those said tables using pg_dump?