voor sommige (niet erg duidelijk mijn redenen) Ik niet postgresql daemon te upgraden in de distributieve een upgrade van één van mijn Debian servers. Postgresql demon heeft een leuke feature niet begonnen met het gebruik van de nieuwe versie (in tegenstelling tot Mysql) terwijl niet overtuigen, de nieuwe is volledig compatibel met de lancering – uiterst nuttig voor grote databases. Het proces voor het bijwerken beperkt tot de volgende 2 voetstappen:
- pg_dropcluster
- pg_upgradecluster
Voordat izdropite pg cluster daemon moet worden gestopt!
pg_dropcluster 9.4 main
Тази команда преминава бързо, след което преминаваме към съществената част – самият ъпгрейд
pg_upgradecluster 9.1 main Disabling connections to the old cluster during upgrade... Restarting old cluster with restricted connections... Creating new cluster 9.4/main ... config /etc/postgresql/9.4/main data /var/lib/postgresql/9.4/main locale en_US.UTF-8 Flags of /var/lib/postgresql/9.4/main set as -------------e-C port 5433 Disabling connections to the new cluster during upgrade... Roles, databases, schemas, ACLs... Fixing hardcoded library paths for stored procedures... Upgrading database postgres... Analyzing database postgres... Fixing hardcoded library paths for stored procedures... Upgrading database template1... Analyzing database template1... Fixing hardcoded library paths for stored procedures... Upgrading database xpqt... Analyzing database xpqt... Re-enabling connections to the old cluster... Re-enabling connections to the new cluster... Copying old configuration files... Copying old start.conf... Copying old pg_ctl.conf... Copying old server.crt... Copying old server.key... Stopping target cluster... Stopping old cluster... Disabling automatic startup of old cluster... Configuring old cluster to use a different port (5433)... Starting target cluster on the original port... Success. Please check that the upgraded cluster works. If it does, you can remove the old cluster with pg_dropcluster 9.1 main
Ако всичко е минло гладко трябва да получите съобщение като горното което ви подканва да разкарате старите данни от pg.
pg_dropcluster 9.1 main
В края на тая тарпана вече можете да стартирате процеса си отново. При мен базите са малки и за съжаление не мога да дам оценка за колко време преминава същественият ъпгрейд.