Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dJKa6-0005OU-QY for pgsql-bugs@arkaria.postgresql.org; Fri, 09 Jun 2017 14:08:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dJKa5-0001kU-Hq for pgsql-bugs@arkaria.postgresql.org; Fri, 09 Jun 2017 14:08:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dJKXC-0000by-4X; Fri, 09 Jun 2017 14:05:06 +0000 Received: from omailpsm02.eng-mo.it ([193.178.235.22]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dJKX9-00025Z-1y; Fri, 09 Jun 2017 14:05:05 +0000 Received: from ITPMX026.italy.itroot.adnet (unknown [161.27.27.32]) by omailpsm02.eng-mo.it (Postfix) with ESMTPS id 3wkkLx1P3Yz40Mw; Fri, 9 Jun 2017 15:55:05 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=eng.it; s=dkeng-mo; t=1497016505; bh=VHQIvmZswKYf1zBUQsjKi9HDRbWVJr0BrdKnUzcxaVQ=; h=From:To:CC:Subject:Date; b=yt4F+GYvxCWqIuSIV4BXzHTF7eMV+0U0Z19WURiodA5reZ3vimZ5gnbE/madHClhO wnySB3OlOBxx3+5/08Xj61Ofu6U8diC118zXFZsJ7FtKfmNQQ4jkCxybqGXOl0jiYu Trstr0cgQNyIN+cUXqQDSNS/2+OMWKVsWicgkBgg= Received: from ITPMX020.italy.itroot.adnet ([169.254.1.213]) by ITPMX026.italy.itroot.adnet ([fe80::20ed:33a:a020:bc50%12]) with mapi id 14.03.0352.000; Fri, 9 Jun 2017 15:55:05 +0200 From: Cocco Gianfranco To: "pgsql-performance@postgresql.org" , "pgsql-bugs@postgresql.org" CC: DBA Subject: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64 Thread-Topic: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64 Thread-Index: AdLhJQaSMQBXPR+sQ8q9bU/bby79GQ== Date: Fri, 9 Jun 2017 13:55:04 +0000 Message-ID: Accept-Language: it-IT, en-US Content-Language: it-IT X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [161.27.34.128] x-kse-serverinfo: ITPMX026.italy.itroot.adnet, 9 x-kse-attachmentfiltering-interceptor-info: protection disabled x-kse-antivirus-interceptor-info: scan successful x-kse-antivirus-info: Clean, bases: 09/06/2017 11:14:00 Content-Type: multipart/related; boundary="_004_D0D985968D95594199094F94C3F7BCA124415034ITPMX020italyit_"; type="multipart/alternative" MIME-Version: 1.0 X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org --_004_D0D985968D95594199094F94C3F7BCA124415034ITPMX020italyit_ Content-Type: multipart/alternative; boundary="_000_D0D985968D95594199094F94C3F7BCA124415034ITPMX020italyit_" --_000_D0D985968D95594199094F94C3F7BCA124415034ITPMX020italyit_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, We have a big problem with managing the number of WAL products, during data= base 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 "reb= uild" 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:image001.jpg@01CE4109.E9653C00] _______________________________ Gianfranco Cocco Gruppo DBA Torino Managed Operations - Data Center Factory gianfranco.cocco@eng.it Engineering.MO S.p.A Corso Mortara, 22 - 10149 Torino Tel. 011 19449548 (SHORT CODE: 676548) www.eng.it ___________________________ --_000_D0D985968D95594199094F94C3F7BCA124415034ITPMX020italyit_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

We have a big problem with managing = the number of WAL products, during database activity, so I would try to wri= te to you.

With pg_rman utility, we can’t save thousands of WAL files every fe= w hours, to be used for a possible recovery.

We are using a production environmen= t 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 &#= 8220;rebuild” postgreSQL server?

The goal is to drastically reduce th= e number of WALs.

 

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

 

 

Thank you.

 

 

3D"Descrizione:

____= ___________________________

 <= /span>

Gianfranco Cocco

Gruppo DBA Torino

Managed Operations - = Data Center Factory

gian= franco.cocco@eng.it

Engineering.MO S.p.A<= o:p>

Corso Mortara, 22 - 1= 0149 Torino

Tel. 011 19449548 (SHORT CODE: 676548)<= o:p>

www.eng.it

 

____________= _______________

 

--_000_D0D985968D95594199094F94C3F7BCA124415034ITPMX020italyit_-- --_004_D0D985968D95594199094F94C3F7BCA124415034ITPMX020italyit_ Content-Type: image/jpeg; name="image001.jpg" Content-Description: image001.jpg Content-Disposition: inline; filename="image001.jpg"; size=4081; creation-date="Fri, 09 Jun 2017 13:55:04 GMT"; modification-date="Fri, 09 Jun 2017 13:55:04 GMT" Content-ID: Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAgAAZABkAAD/7AARRHVja3kAAQAEAAAAZAAA/+4ADkFkb2JlAGTAAAAAAf/b AIQAAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQICAgICAgICAgIC AwMDAwMDAwMDAwEBAQEBAQECAQECAgIBAgIDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMD AwMDAwMDAwMDAwMDAwMDAwMD/8AAEQgAHwCKAwERAAIRAQMRAf/EAKYAAAICAwEBAAAAAAAAAAAA AAAKBwkGCAsFAwEBAAICAwEBAAAAAAAAAAAAAAcIBgkDBAUCChAAAAYCAgAEAgQJDQAAAAAAAgME BQYHAQgACRESEwohFCIVFhcxQSMkZDVXGDg0NqbWN2coWGjYGTmZEQACAQMCBAMFBQkBAAAAAAAB AgMAEQQFBiESEwcxQVFhQiMUCIEiMhUJodFSkjNT0ySUg//aAAwDAQACEQMRAD8Af44pXPw76u9C w7ntmTam6Y20+w7Xyu1K2M2VY9cvJ7K5XjNkxo0j+gape0mJ3fNUR0YTG8otEeUjkJ3zCgwSxDlC LE/bE2Pj4eIurazEr6hIAyI4uIl8iVPDqHx4i6CwFm5qgHfm+cjMy20nRpWTT4yVd0NjK3mAw49M eHA2c3JuvLWocosmwqx0U6h57XM4lsFmzZVe2ixBLIlIHWPyFKp/fhuVUIwt3a1SZd+UUFBGPGR5 CPOPpYzzCN6qp3bnKQOW8PD/AMI63n/pM7e0HdX0/wC4dF3NhYuoaRNqyiSHIiSaJwVmH3kkDKTY nja4vwNOB9LvagVvZWaqq7gdGxLtJVTSQdIMlhTNwbWhZRpKFPY7S2E4KJIdkSk4lM/pk4MJyVZx KkoJRKsKdPgeVj9FuZf6Z/Z7Kg36zfpbfsZuVN07QilbtfqspEV7v8jkkFjhyObkxsAz4rueZo1e NyzxGSS8jnUqkFHFKOKUcUo4pRxSjilHFKOKUcUo4pRxSjilHFKU99yB2/Y12grrofrtJwlXvaUb wC7pYyqhYXVFV8iSYyXFkSxMPGG+f2S1HC830vmGxhN9fAQGrkKguVe3O0fzGca7qK/6MTfDU+Ej j3j6oh+xm4eCsKinuNu/8ugOhac3+9KvxGHjGh90Hydx9qrx8WU0jNrTrla+2l411r3SkcPk1i2W /kMjMjAE0KFuTYANU8yR+VlFHfVkZjDOnPXuKoQchTo05g/DOcYDmcNS1HE0nBk1DNblx4lufU+g HqzGwA8yag/TdOy9Wzo9Pwl5siVrD0HqT6KouSfICnhuw7o4WwHrm1wjmvL3IbGnmjVfTFHJGU9P 5ltqxmcSt3tK1H6LNBAFChK+M87fHBxbGkBhphrOcNIEahWSmwfV3UdcfWNZn1KdQnXYWA90KoRQ T5/dUAnzPGwrdv8Ap0d8ND7H6y3afdDpHtfXJYuTMb7ogzgWCdUk2XHyDIULG/RcRMxEZldVT6Ku +ydb7ag121HIT4zYFevid8YnIrIxJzsl4ESuaHZKAwoLmwPrccajXpB59NUjPMKF9EeefLorqUb8 JreFvnZO2+42087ZW7cdcnQNQgMUqG1xfiskbWPJLE4WSKQcUkVWHEV0r9Bd3a13315jV1wMRLU9 h8rBZsBMV4VOdeT5GnJMdWFUZkBQ1jWqAaFW2LfIEKxAcWIQSzsHEFeHNE0L8p8PL21+bXv12T3J 2G7g5Oy9dBlwv6uFlBeVMvFYkJKoueV1sY5o7kxyqwBZCjvutziqFqOKUcUo4pRxSjilHFKOKUcU o4pRxSjilHFK5Jtt08ku20rEuGwNlTXicWhNZLPZW5G687JjyrfpU7q3pyGX6tfGCLTAUrBBKL8f KUUEIA+AQ4xy2OJlnCxY8PHxrQRIqqOrD4KLD36qdl4YzcqTMyMm88rszHpTeLG59yr+ul7Z3rE6 vobMJZPFN92htBZAzmiSWHHtY7ExH4nX6NaFQ1QWCHPiJC9FJHZQnKcHlSMlMJcqAnJyXktCSYZg W89M3NueZIoOhFpkfEIZkuzkcWa1xw8FFzYXPixFZ7szU9s7YheWczy6nJwLiF7Kl+CrcA8fFjwu bDwUU33sNu3S2sdJQK/rLIn5sDsd2izLHS4lB3WTyQKyYRJ7mjRl1j6D88bSAszAfg8ZnwJUZAWL 6Q8chI48gmaDh1EJB48OBsbHzq33aPtTunvVrsm3dmHDXUIsBstvmp0xk6SyQxGzvwL806WTxI5j 7ppGbfCt9LLs2Ek9t6qTKeVVCp/kUgktdTTXu1kqKPzdYecY+qIaKNMb2QVGnw0WFeEZmCcIVRhp ZGPlsklE+nC0qJyyAEjzuK3q9itx959ldv8AF2n3Uw8DVdawPhQ5eNquCzS4ygCIZHWkjJmiHw+o ObqIEZ/ic7PYt7fJhWVDuNLIvGbbWSyLWTUMhKlMPxWdtxNtMcIq6MzvHJUavlUWamLDkx+ssREe odgeSXU8IMZELGOcGYeaMEixB9RVeP1Ac+Hd3Z7E1TU9JTE1TTdXiMGR85gTuEnSSOaALBO8vJLa ORuVSOaBCbAVbPs17ivrk1O2TtHU+z119uFyU8sbUc2Z4BSEkm7ckE6sDBJEqhI4tCgWFaPDdJUm Bm4LCABxnkznx8PHzK0z1KzN3n9fTnsNqtrE5zicwu0dyKxrq1aTInVfukXYVzNbJMg+7xhkr0vO wVGJlKHOOmNyZuUA9QbkoTp8Z9Q4GOKV4aXv361s0Pslsc92rKYjWmrdxE0BPjpRAntFIZDcK0t5 NaYLW0cR/WDnNnZ2KYFhpeSAAJJSpjlSkZCQg88pSsc1A9wn1y7op7xT1xJrThUzoCn5dfUxrK3K 4Nh09eKpgzB9pJPKYSgRvD8zyf6sazCTBIilwHARags4JGU+RHBUrFHT3JvVtH6h1tveS2FZ8cq3 aawLWrmt5O71S+lkt7vSrtXLRYjnNEqU9UtjsfZTbRazsKfTPEcR6wgAzkrIcqVPs07tdEIJZm5d UPEqnquT6JVK23ZfChkgit3YC4A7/YHLc5Ql7SrRJJicqBZTUMBafy4EAwYsCzgHxUqDNfPca9cu zMgdo9WI9iTBMtW2pcKt6kVCSphjIoVTkAkNkzJSmkCo4TcoXBjUYVfKEBH4qlOAlBz5hY4pXl63 +5M62Nrbbq6madN2Nd5Tb06Y67iLm40BK26IYkb+4EtiIDzKMnntrShJVHh9c4wXlJD8RcUqH497 snp4flTV8xYF6xxgcn5FHT5pIKBmhcQZnBaH1QYeHRqw7HkBJTYEeYAok44JARDwXkOM54pW6k67 zNBa9ubbuiH2U2KdOtJKRN2DvATRXjg5MBNalK6lR4cYg9ErMJ5SuOMutiEWQTgGRgNNFjPgVnxU rG2nv8625DWuo1rRyx5rIYrundT5r1UYGmAOh700W3HJDD427xOy2Yw8lZBFRCietKoAlOBgPblx KsrIyDSxjUqI9oPcydWOqGwkx1wnM5tmYyysJN9jbdldV1Q6TGu6plCd1CzPDJK5GNwalbgujq/O SlwWRG74JUlmJcZGsKMThUqyX/km0T/zPVf/AAofvyfrNZ/Ch+2f+Qfze/Rv1n+jcUpXntJ0GQwe 1JhcerNwX1fEZnMkkkom9X132l1HT8gqiUuz8uWuzDFK1nlOS5U5wdMeqABEQkfV7okF6hBiMBBA DhzVtfXmnxUw9UhgglRVVXfCkkEigAAs6yLZvUlQp4G9zaoV3RoIgynzNLmnnidizImbHGY2JNwq NG119AGLDwtYXqoD7rNgv2OdiP8A6s0d/tx5l3zWB/e0/wD4Zf8ANWI/K6j/AGdR/wC6L/DTgPax H5m79dOsTZG4zdT2+pJzSxji01psLE6hnqMkijLETqzJHZr/AAiTs0sRp1hpZSxOQ3phr1oylYBF gJEWOvTlfzGY3Xl53902/F5Le49gvwHCtqv0K5mmYHcrLl1ifSsbHO2ZVDajp02qxF/mtPPKsEE+ Myy2DETlyoUOnITICq2zfVN7uS1KgTVbvAWerOAQUY4dnNHNKIAx58AiVOTrRyNuRE4z+Ew40ssP 4xY5zc0fqn8p/fW03I3VsbGhbIk1TZBRBchNmalI1h/CiamzsfYqknyFNI9T+pkG19QSGYO92yGx r4ncZJTPkDetrGHZZBWsPSOaJWcmZ17BBq4TZcnF1NSYdleECpMWaQnJTKcgyMajz8iQvwAsg9lr 1q++qzuvrncCfH0fE0TH07YmDklosqPQ5dHbMyGRlBkSXJzDyIgk6CdVHKtI8sYPKsaZm/NO2s6+ 4M7EpTCGLaSa4dWKPBBH+v3d+itb9jkSIEF15KOcp1iQtVpSpPVZSpKEtY3K4+h9d0PalGFQAlgL U9aqbV9OyrVg7dXsV1DYb0stj0YdnLqwrJriT5tTtZSCO14bfFbtlyGUoitR/cX6GyGWullTRiak zk/NTGVhQc7HKEQPXKCDClV5NepFxu/VLsvKrFtbXlqtmoOzqGWJLq5tLabXFM1W4+/c1YjdPGLD mdagYzJLaYnIs9XiNjcCHVzaBu2UhR5wSyTVKt7ZLR382U7J9oLVuykJFrNW1laFbtgTUpfki12S WZXaEeltkp421Nrg4sEAuRnp0l8VkZaVy1OS1iS4NNMUeiA8BClVcm6uMFi6MdDVWXpZVN19TTpv PvEwXpYRuzGurK1xGo5zbGkTXOZWxS1ysg2Nu6yLQ8twWKQoTF5jaIsrKooHqlBMUqUNT9TrcpNr 72qvmdx0vc57V1sEwOBWxHtjKYkEen1aNlma8YpWco1R1krF0QreRU6jZVLIoeco0SdsNSJwm/Eo IlK3L6l4bfUBoGwo+fUG/b3C7A65Nz6/dLSnG/VGWP15wpCbQdhS1pmsBpqOwhP9l2tzlETQx9vX mTFSjbDno4084ReRYCpWL+3Mi+wNI3NqjJ2KlN67iYM3nIIg9OlL77US+dfrHHbQRrq1mM6muv0R h03c5W6VFG5aqkq/5aVkGicWlOf5CsFZAJSqmK70bvIfTtbN4ptkmPEHiO/dcxiRasZ2To/OtM6V KasSuSaxpdKGe5G+NAsREM4psLbxry3Exsz6xIQeQJoVKtivavZjMd//AHAc6Gnq2JhsvqOb/k4m ddVPti+JObss65nE1okMfd7AJkUIZWgSE5Phc+EokYfKSER/mUEeqpVc1RaLOlT2707WXUeyNH2n UtqbAa5zK262aNqNfn1RRe1cVs6uW2z4YY0N9mnkOj5JoR9ROyIDdhQ5qCVPyQyRBSJDD1K2rfW7 dDWZL3C6k6tQ+H7AMNr7aRG3ZFuXrtcuvM6qSIRJHMLbIY6020USg6cQWBMckzIT1AGSVLo85NMp ZVJARKyjwqS1Kkn/ABy/3P8A/S//AKOP7TP6v/0e4pX/2Q== --_004_D0D985968D95594199094F94C3F7BCA124415034ITPMX020italyit_--