Re: pgstat.tmp

Thanks for the reply. Yes, we had an open file access error backing up that file.

We're currently backing up the entire file system. I wanted to check that this particular file wasn't a necessary file, e.g. if our server goes down and we have to restore OpenNMS from backup. From your answer, I'm thinking it isn't needed and that I'm safe to exclude it from future backups. Is that correct?


Regards, Dominic



From: David S Hustace [mailto:[email protected]]
Sent: Thursday, September 25, 2014 3:28 AM
To: [email protected]
Subject: Re: [opennms-install] pgstat.tmp

On Sep 19, 2014, at 4:09 PM, Brasted, Dominic <[email protected]<mailto:[email protected]>> wrote:


I have a quick question. What is the function of /var/lib/pgsql/data/pg_stat_tmp/pgstat.tmp? We had some trouble backing up the file a few days ago and I'd like to know if it's safe to exclude it.

1) Could you be more specific about the trouble you had?

2) Why would you be backing up that file?  This is a file that PostgreSQL updates quite frequently for it's internal statistics.  I seem to recall you can disable stats via postgresql.conf by setting "track_activities" to "off".  I'm assuming the "trouble backing up the file" was a "file in use" error.

3) I also recommend researching that question in the PostgreSQL forums.


David Hustace

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-install mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-install