pid_file for redhat and centos;

Yes, this is default pidfile for puppetdb from official puppet repository:

# grep ^PIDFILE /etc/init.d/puppetdb 
PIDFILE="/var/run/$prog/$prog"