2023 views

NFR 2.5 - Database grow - hands on for maintence

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 & tipps
Michael
Tags (3)
0 Likes
2 Replies
Anonymous_User Absent Member.
Absent Member.

Re: NFR 2.5 - Database grow - hands on for maintence

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 & tipps
> Michael
>
>

Michael,

What are you doing to maintain this database? Have you set up vacuum
schedules and scheduled backups, per PostgreSQL's "Routine Vacuuming"
and backup guidelines? (See
http://www.postgresql.org/docs/9.2/static/routine-vacuuming.html and
http://www.postgresql.org/docs/9.4/static/backup.html; be sure to change
the URL to the version of PostgreSQL you're using.)

--

-- NFMS Support Team
0 Likes

Re: NFR 2.5 - Database grow - hands on for maintence

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
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.