On 07/25/2018 07:57 PM, Andres Freund wrote: > On 2018-07-25 12:31:01 -0700, Adrian Klaver wrote: >>> Would "permission denied" be relevant? >> >> Logical decoding is something I am still learning. The "permission denied" >> would to me be relevant only to the extent that it seems to be provoking: > > Yes, it looks related. Looks like logical rep was trying to perform the > intiial sync of those tables, and couldn't due to permission errors. I'm not sure what happened, I remember the initial sync of that particular schema failing on one table only, but looking at it now, all tables are empty on the subscriber. >> "LOG: logical decoding found consistent point at 19/E6942440" >> DETAIL: There are no running transactions." >> >> Others with more experience in this area would need to fill whether that >> might account for the 13 million files in the ~snapshot/ directory. > > That indicates there's some error handling issues to be resolved. Petr? It logs "COPY TO STDOUT", does that actually cache to disk (in ~snapshot/)? Would it be safe to delete every file in ~snapshot/ older than some X-number of minutes? (And what a good X might be?) -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
Attachment:
signature.asc
Description: OpenPGP digital signature
