On Fri, Jul 17, 2020 at 9:53 AM osumi.takami...@fujitsu.com <osumi.takami...@fujitsu.com> wrote: > > Lastly, I have to admit that > the status of target table where data is loaded by COPY UNLOGGED would be > marked > as invalid and notified to standbys under replication environment > from the point in time when the operation takes place. > But, I'm going to allow users with special privileges (like DBA) to use this > clause > and this kind of tables would be judged by them not to replicate. > Of course, I'm thinking better idea but now what I can say is like this for > replication. >
If you are going to suggest users not to replicate such tables then why can't you suggest them to create such tables as UNLOGGED in the first place? Another idea could be that you create an 'unlogged' table, copy the data to it. Then perform Alter Table .. SET Logged and attach it to the main table. I think for this you need the main table to be partitioned but I think if that is possible then it might be better than all the hacking you are proposing to do in the server for this special operation. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com