gunicsba
gunicsba
So I assume we can't use pg_dump to create backups of the cstore files?
FYI: when working with partitioned tables you want to use SELECT * FROM ONLY table. Otherwise you'd dump the data from the table twice if you copy it out from...
To reproduce: Log into the template1 database. Install cstore_fdw there. Create a server there. Try to use cstore -> Success. Create a new database. (it will be based on template1)...
I ended up writing a shell script that creates the folder after database creation, this solved the issue. (Not that ugly workaround)
@mtuncer I think preventing cstore table creation in template databases is acceptable.
We'd need this tablespace option too. We plan to move to AWS and have a lot of data already stored in cstore. What I'd like to try is: move everything...
Personally I like that cstore_fdw uses its own file storage approach, because we can take file system level backups.
@mattwiller we ended up doing that, the bigger the file the more timeout we set. Once it times out, the next try uploads it without any problems. So the base...
Same here I'm trying to get an accurate reading of pulses between 50 and 2000Hz but readings are all over the place...