Re: pg_basebackup - Stale file handle for file under gprof

I am guilty of compiling the code myself and enabling the profiling. I am new to Postgres and was following the previous DBAs work. I now realize this needs to be off and will look to be recompiling the code again. I am thinking I will create a new software home and point the database there.

Natalie Reno
Sr. Database Administrator
Database Infrastructure Team Lead
BioMedical Informatics
Cincinnati Children's Hospital
natalie(dot)reno(at)cchmc(dot)org<mailto:natalie(dot)reno(at)cchmc(dot)org>
513.803.5370

From: Korry Douglas [mailto:korry(dot)douglas(at)enterprisedb(dot)com]
Sent: Friday, February 26, 2016 9:38 AM
To: Reno, Natalie <Natalie(dot)Reno(at)cchmc(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] pg_basebackup - Stale file handle for file under gprof

Did you compile your copy of PostgreSQL 9.5 yourself, and if so, did you enable profiling? If not, which installer did you use?

-- Korry
I have just implemented pg_basebackup on my 9.5 PostgreSQL database. I received the following notification:

pg_basebackup: could not create file "<base_directory>/fullbckp_20160225/gprof/2540/gmon.out": Stale file handle

Is this an issue or can this be ignored since these are tracing files?

Natalie Reno
Sr. Database Administrator
Database Infrastructure Team Lead
BioMedical Informatics
Cincinnati Children's Hospital
natalie(dot)reno(at)cchmc(dot)org<mailto:natalie(dot)reno(at)cchmc(dot)org>
513.803.5370