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...