Hi all, I'm currently playing a few ideas out in my head and wanted to see if this was feasible. There may be some limitation I am not aware of.
I would like to create a foreign table into a hot standby instance using FDW's. I appreciate that the hot standby is always going to be read-only, and that foreign tables are currently read-only anyway. Can anyone tell me if there is any reason this wouldn't work? I'm unable to test it just yet as I've not setup replication, nor am I on a recent enough postgres. yet. ;-) While I'm at it, is there any facility (future?) to provide a *foreign* * schema* variant - such that I could access an entire schema using FDW's? Cheers, Tim