Dear all.
We are running VBR V12.1 with PostgreSQL.
Just noted today that there are around 70GB of logs in the folder C:\Program Files\PostgreSQL\15\data\log
How to reduce that amount?
Is this a setting, or can I safely remove those logs?
Regards
Peter
-
- Expert
- Posts: 111
- Liked: 10 times
- Joined: Nov 21, 2017 7:18 am
- Full Name: Peter Helfer
- Contact:
-
- Product Manager
- Posts: 10104
- Liked: 2696 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: Postgresql log files
Hello Peter
You can delete those logs safely. This are just "application debug logs". Maybe keep the last 2-3 days for now.
With v12.1 we have introduced new postgresql.conf parameter for our Set-VBRPSQLDatabaseServerLimit cmdlet. The new postgresql.conf settings will help to clean up those log files. Unfortunately, upgrading to v12.1 will not update those settings automatically.
You have two options:
Option 1:
You can manually change the postgresql.conf file. Manual update may be required if you already use a customized PostgreSQL configuration:
Option 2 - Set-VBRPSQLDatabaseServerLimit
You can rerun Set-VBRPSQLDatabaseServerLimit to implement the updated logging settings. This command will configure your PostgreSQL server with the from us recommended settings. It will overwrite any by you customized setting in the postgresql.conf file.
Best,
Fabian
You can delete those logs safely. This are just "application debug logs". Maybe keep the last 2-3 days for now.
With v12.1 we have introduced new postgresql.conf parameter for our Set-VBRPSQLDatabaseServerLimit cmdlet. The new postgresql.conf settings will help to clean up those log files. Unfortunately, upgrading to v12.1 will not update those settings automatically.
You have two options:
Option 1:
You can manually change the postgresql.conf file. Manual update may be required if you already use a customized PostgreSQL configuration:
Code: Select all
log_truncate_on_rotation = 'on';
log_filename = 'postgresql-%d-%H%M.log';
log_rotation_size = 0;
change log_rotation_age = '10d'; to
log_rotation_age = '4h';
You can rerun Set-VBRPSQLDatabaseServerLimit to implement the updated logging settings. This command will configure your PostgreSQL server with the from us recommended settings. It will overwrite any by you customized setting in the postgresql.conf file.
Best,
Fabian
Product Management Analyst @ Veeam Software
-
- Expert
- Posts: 111
- Liked: 10 times
- Joined: Nov 21, 2017 7:18 am
- Full Name: Peter Helfer
- Contact:
Re: Postgresql log files
Thank you Fabian for your response.
I was able to safely remove those logs and to set the settings with the powershell command mentioned.
The postgres service was needed to restart.
I will monitor the situation in the next weeks to check if the log rotation works as expected.
I was able to safely remove those logs and to set the settings with the powershell command mentioned.
The postgres service was needed to restart.
I will monitor the situation in the next weeks to check if the log rotation works as expected.
Who is online
Users browsing this forum: Semrush [Bot] and 48 guests