Re: pgstat.tmp

David S Hustace <[email protected]> Thu, 25 Sep 2014 04:28:28 -0400

Newsgroups	gmane.network.opennms.install
Message-ID	<[email protected]>

On Sep 19, 2014, at 4:09 PM, Brasted, Dominic <[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

signature.asc (application/pgp-signature, 203 B)