• State Not Answered
  • Replies replies
    3
  • Subscribers subscribers
    3
  • Views views
    383
  • Users 0 members are here
  • Locked Locked
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

NFR 2.5 - Database grow - hands on for maintence

michaelkuerschn
Hello,

I manage a NFR 2.5 installation on Windows platform. It is a small installation with some servers with shares, running jobs and a really small part of reports. I see in this installation, the postgresql database grow and grow and grow. The postgresql system need 35 GB file space.

Is there no task to shrink or delete old entries? No autovacuum active on the postgres system to manage the NFR database? I found no information in handbook or documentation for a guideline to manage the postgresql NFR installation.

Have a reader on this forum a guideline to manage the NFR installation? Or is the only way to extend the filespace??

Thanks for support
  • 0
    On 11/27/2015 2:16 AM, michaelkuerschner wrote:
    >
    > Hello,
    >
    > I manage a NFR 2.5 installation on Windows platform. It is a small
    > installation with some servers with shares, running jobs and a really
    > small part of reports. I see in this installation, the postgresql
    > database grow and grow and grow. The postgresql system need 35 GB file
    > space.
    >
    > Is there no task to shrink or delete old entries? No autovacuum active
    > on the postgres system to manage the NFR database? I found no
    > information in handbook or documentation for a guideline to manage the
    > postgresql NFR installation.
    >
    > Have a reader on this forum a guideline to manage the NFR installation?
    > Or is the only way to extend the filespace??
    >
    > Thanks for support
  • 0
    On 11/27/2015 2:16 AM, michaelkuerschner wrote:
    >
    > Hello,
    >
    > I manage a NFR 2.5 installation on Windows platform. It is a small
    > installation with some servers with shares, running jobs and a really
    > small part of reports. I see in this installation, the postgresql
    > database grow and grow and grow. The postgresql system need 35 GB file
    > space.
    >
    > Is there no task to shrink or delete old entries? No autovacuum active
    > on the postgres system to manage the NFR database? I found no
    > information in handbook or documentation for a guideline to manage the
    > postgresql NFR installation.
    >
    > Have a reader on this forum a guideline to manage the NFR installation?
    > Or is the only way to extend the filespace??
    >
    > Thanks for support
  • 0 in reply to 
    Hi,

    thanks for the response. I do nothing in standard mode! Ok, I will read postgresql documentation and build some jobs to vacuuming the database.

    My hope was to find some hints in documentation, knowledge base ... which tables are the important ones.

    Best regards
    Michael

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.