Hi everyone, I'm playing with logical replication in postgres-10 and I got it to hang on startup with
> 2018-07-23 13:15:06.577 CDT [18624] FATAL: the database system is starting up > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: shmem_exit(1): 0 > before_shmem_exit callbacks to make > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: shmem_exit(1): 0 on_shmem_exit > callbacks to make > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: proc_exit(1): 1 callbacks to make > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: exit(1) > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: shmem_exit(-1): 0 > before_shmem_exit callbacks to make > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: shmem_exit(-1): 0 on_shmem_exit > callbacks to make > 2018-07-23 13:15:06.577 CDT [18624] DEBUG: proc_exit(-1): 0 callbacks to make ... forever ... After poking around: # find /var/lib/pgsql/10/data/pg_logical/snapshots -printf . | wc -c 12727975 It looks like ZFS simply can't handle this many files: `ls` etc. hang forever. So my question is, does it have to be that many? And if not, is there a knob to keep the number down? TIA -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
signature.asc
Description: OpenPGP digital signature
