public inbox for [email protected]  

help / color / mirror / Atom feed

From: Cocco Gianfranco <[email protected]>
To: [email protected] <[email protected]>
To: [email protected] <[email protected]>
Cc: DBA <[email protected]>
Subject: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
Date: Fri, 9 Jun 2017 13:55:04 +0000
Message-ID: <D0D985968D95594199094F94C3F7BCA124415034@ITPMX020.italy.itroot.adnet> (raw)
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-bugs>

Hi,
We have a big problem with managing the number of WAL products, during database activity, so I would try to write to you.
With pg_rman utility, we can't save thousands of WAL files every few hours, to be used for a possible recovery.
We are using a production environment 9.2 PostgreSQL server which processes a database of about 260 GB
Is there a way to fix "wal_segsize" to about 1 Gb in 9.2. version, and "rebuild" postgreSQL server?
The goal is to drastically reduce the number of WALs.

Upgrading to 9.5, is the only way to fix this issue?


Thank you.


[Descrizione: cid:[email protected]]
_______________________________

Gianfranco Cocco
Gruppo DBA Torino
Managed Operations - Data Center Factory
[email protected]<mailto:[email protected]>
Engineering.MO S.p.A
Corso Mortara, 22 - 10149 Torino
Tel. 011 19449548 (SHORT CODE: 676548)
www.eng.it<http://www.eng.it;

___________________________



Attachments:

  [image/jpeg] image001.jpg (4.0K, 3-image001.jpg)
  download | view image

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
  In-Reply-To: <D0D985968D95594199094F94C3F7BCA124415034@ITPMX020.italy.itroot.adnet>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox