Karena beberapa (tidak sangat jelas bagi saya) Aku telah mengabaikan untuk melakukan upgrade daemon postgresql di upgrade diuntungkan pada salah satu server Debian. PostgreSQL daemon memiliki Nice properti tidak mulai menggunakan nya versi baru (Tidak seperti Mysql) sampai kita meyakinkan, baru ini penuh kompatibel dengan peluncuran – sangat berguna untuk database besar. Proses hanya pembaruan akan terbatas berikut 2 langkah-langkah:

  • pg_dropcluster
  • pg_upgradecluster

Sebelum setan gugus izdropite harus pg berhenti!

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

Jika semuanya halus minlo Anda harus menerima pesan seperti di atas, yang meminta Anda untuk keluar data lama dari pg.

pg_dropcluster 9.1 main

Di akhir ini sekarang Anda dapat mulai proses Tarpan lagi. ПРИ МЕН БАЗИТЕ СА МАЛКИ И DINING СЪЖАЛЕНИЕ НЕ МОГА ДА ДАМ ОЦЕНКА DINING КОЛКО ВРЕМЕ ПРЕМИНАВА СЪЩЕСТВЕНИЯТ ЪПГРЕЙД.