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.
From: Korry Douglas [mailto:korry.douglas@enterprisedb.com] Sent: Friday, February 26, 2016 9:38 AM To: Reno, Natalie <Natalie.Reno@cchmc.org> Cc: pgsql-admin@postgresql.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?