The following commands export data without mixing it with role or privilege data so that you can import it to any role you specify. Also, you can make pg_dump compress the data to a tar file for you.
pg_dump --format=t --blobs --verbose --no-privileges --no-owner \
--password --username mydbuser --database mydbname \
--file "mydbname_dump_$(date +%Y%m%...
It is a creative way of thinking. If you know how to handle role exchanges (promoting to primary) and do this often, it could work but I am not sure it makes you happy. Especially not because there is a bug where WALL files are prematurely recycled which makes re establishing the old primary as a slave a pain.
(this is fixed in May 2020)
Since you want to be ...
For partition pruning to work, it is important that your partition key is simple and part of the where clause of your queries. In your example you can simplify to
check((extract(hour from "timestamp")) = 0 # equality
check((extract(hour from "timestamp")) = 1 # etc.
check((extract(hour from "timestamp")) = 23
At this time it ...