| From: | CONVERS Yann - DREAL Auvergne-Rhône-Alpes/CIDDAE/SIG <yann(dot)convers(at)developpement-durable(dot)gouv(dot)fr> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: migrate from PG 9.5 to PG 12 or more |
| Date: | 2021-10-20 05:20:06 |
| Message-ID: | e80445cd-2682-7c58-2bac-4dce632b0baa@developpement-durable.gouv.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>hello Pascal,</p>
<p><br>
</p>
<p>I do it in 2020 from postgresql 9.6 to 12 .</p>
<p><br>
</p>
<p>I do with a shell linux script using pd_dump and pg_restore from
a database save.</p>
<p><br>
</p>
<p>I first mount a new postgresql 12 server, prepare with new hard
parameters in postgresql.conf, pg_hba.conf, .pgpass and all of the
scripts and clients i need (pgadmin, phpadmin, shape2pgsql) with
new IP.</p>
<p><br>
</p>
<p>When It's ok, with crontab i execute a script dump and restore
from old server to new in a week-end and on monday morning when i
see the new server with 1To data is ok i reverse IP of 2 serveurs.</p>
<p><br>
</p>
<p>take care to prepare the new server with care, and do test
migration to prevent (without reverse IP) data loss or
missconfiguration. You need to know how much time takes the
process to be cool.</p>
<p><br>
</p>
<p>Have a good day!<br>
</p>
<div class="moz-signature">
<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
<title></title>
<meta name="GENERATOR" content="OpenOffice.org 2.3 (Win32)">
<meta name="AUTHOR" content="dreal-ra">
<meta name="CREATED" content="20110608;16534339">
<meta name="CHANGEDBY" content="Yann CONVERS">
<meta name="CHANGED" content="20120220;8494106">
<meta name="CHANGEDBY" content="Yann CONVERS">
<meta name="CHANGEDBY" content="dreal-aura">
<meta name="CHANGEDBY" content="dreal-aura">
<meta name="CHANGEDBY" content="dreal-aura">
<style type="text/css">
<!--
@page { size: 21cm 29.7cm; margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style>
<pre><b>Yann Convers</b>
Gestionnaire de l'infrastructure, des référentiels et des outils<p>
<font color="#000000"><b>DREAL Auvergne-Rhône-Alpes</b></font></p>
<pre>Service Connaissance, Information, Développement Durable, Autorité Environnementale - Pole Système d Information Géographique
Tél : 04 26 28 67 89
courriel : <a href="mailto:yann(dot)convers(at)developpement-durable(dot)gouv(dot)fr">yann(dot)convers(at)developpement-durable(dot)gouv(dot)fr</a></pre>adresse de la boite d’unité : <a href="mailto:sig(dot)dreal-ara(at)developpement-durable(dot)gouv(dot)fr">boite unité</a>
<p>Pour toute commande interne de prestations, merci d utilisez le formulaire suivant : <a href="http://postgis-aura.projets.appli.i2/projects/demandes-de-prestations/issues/new">http://postgis-aura.projets.appli.i2/projects/demandes-de-prestations/issues/new</a></p>
<b>Adresse postale :</b> DREAL Auvergne-Rhône-Alpes, CIDDAE - SIG
69453 LYON CEDEX 06
<b>Adresse physique :</b> 5
place Jules Ferry (immeuble Lugdunum - métro Brotteaux) -
69006 Lyon
<b>Standard :</b> 04 26 28 60 00
<b>Liens :</b><a href="http://intra.dreal-rhone-alpes.i2/">Site
Intranet</a> <a href="http://www.auvergne-rhone-alpes.developpement-durable.gouv.fr/">Site
Internet</a>
<p style="margin-bottom: 0cm">
</p>
</pre>
</div>
<div class="moz-cite-prefix">Le 19/10/2021 à 17:41, >
pascal.crozet (par Internet, dépôt
<a class="moz-txt-link-abbreviated" href="mailto:pgsql-docs-owner+m63745-354560(at)lists(dot)postgresql(dot)org">pgsql-docs-owner+m63745-354560(at)lists(dot)postgresql(dot)org</a>) a écrit :<br>
</div>
<blockquote
cite="mid:PAXP251MB00981D48C6A39C9607449A71A0BD9(at)PAXP251MB0098(dot)EURP251(dot)PROD(dot)OUTLOOK(dot)COM"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
<div style="font-family: "Lucida Console", Monaco,
monospace; font-size: 10pt; color: rgb(0, 0, 0);
background-color: rgb(255, 255, 255);">
Hi PG experts,</div>
<div style="font-family: "Lucida Console", Monaco,
monospace; font-size: 10pt; color: rgb(0, 0, 0);
background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: "Lucida Console", Monaco,
monospace; font-size: 10pt; color: rgb(0, 0, 0);
background-color: rgb(255, 255, 255);">
During next year, I've the goal to migrate an instance of 4
databases from PostGreSql 9.5 to 12 or maybe more 14.</div>
<div style="font-family: "Lucida Console", Monaco,
monospace; font-size: 10pt; color: rgb(0, 0, 0);
background-color: rgb(255, 255, 255);">
What's the best tools I've to use ? Do a simple pg_dumpall in
text format can archive this goal ?</div>
<div style="font-family: "Lucida Console", Monaco,
monospace; font-size: 10pt; color: rgb(0, 0, 0);
background-color: rgb(255, 255, 255);">
What other files more than pg_hba.conf and postgresql.conf do I
need to checK ?<br>
</div>
<div>
<div style="font-family: "Lucida Console", Monaco,
monospace; font-size: 10pt; color: rgb(0, 0, 0);">
And what issues can I find during this upgrade ?<br>
</div>
<div id="Signature">
<div>
<div style="font-family: Calibri, Arial, Helvetica,
sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<p style="color: rgb(32, 31, 30); text-align: start;
background-color: rgb(255, 255, 255); font-size: 11pt;
font-family: Calibri, sans-serif; margin: 0px;">
<span style="margin: 0px; font-weight: normal;
font-family: Calibri, sans-serif, serif, EmojiFont;
color: windowtext;"> </span></p>
<p style="color: rgb(32, 31, 30); text-align: start;
font-size: 11pt; font-family: Calibri, sans-serif;
background-color: white; margin: 0px;">
<b><span style="margin: 0px; font-size: 12pt; color:
rgb(33, 33, 33);">_________________________________</span></b><span
style="margin: 0px; font-size: 12pt; color: black;"></span></p>
<p style="color: rgb(32, 31, 30); font-size: 15px;
text-align: start; background-color: white;">
<span style="margin: 0px; font-size: 12pt; color: black;
background-color: white;">Cordialement,<span> </span><b>Pascal
CROZET</b></span><span style="margin: 0px;
font-size: 12pt; color: black;"><br>
</span><b><span style="margin: 0px; font-size: 12pt;
color: rgb(117, 123, 128);" lang="en-US">DBA</span></b><b><span
style="margin: 0px; font-size: 10pt; color: rgb(117,
123, 128);" lang="en-US"><span> </span> -<span> </span></span></b><b><span
style="margin: 0px; font-size: 10pt; color: rgb(117,
123, 128);" lang="en-US"><br>
</span></b><span style="margin: 0px; font-size: 12pt;
color: rgb(112, 173, 71);">•</span><span
style="margin: 0px; font-size: 12pt; color: rgb(33,
33, 33);"> </span><span style="margin: 0px; font-size:
12pt; color: black;"><a moz-do-not-send="true"
href="http://www.qualis-consulting.com/"
target="_blank" rel="noopener noreferrer"
style="margin:0px"><span style="margin: 0px;
font-size: 9pt; color: rgb(127, 127, 127);">www.qualis-consulting.com</span></a></span><span
style="margin: 0px; font-size: 12pt; color: rgb(127,
127, 127);"> </span><span style="margin: 0px;
font-size: 12pt; color: rgb(112, 173, 71);">•</span></p>
<p style="color: rgb(32, 31, 30); font-size: 15px;
text-align: start; background-color: white;">
<b><span style="margin: 0px; font-size: 12pt; color:
rgb(33, 33, 33);">_________________________________</span></b></p>
</div>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 8.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2021-10-22 03:59:49 | Re: The huge_pages parameter doesn't work when shared_memory_type is sysv |
| Previous Message | Michael Paquier | 2021-10-20 03:51:31 | Re: [PATCH] doc/queries.sgml: add missing comma |