PostgreSQL
From RCUB
(→Upgrade major verzije) |
(→Upgrade major verzije) |
||
| Line 196: | Line 196: | ||
Pre upgrade-a uraditi backup, i premestiti DB klaster direktorijum: | Pre upgrade-a uraditi backup, i premestiti DB klaster direktorijum: | ||
| + | su - postgres | ||
pg_dumpall > pg_all.sql | pg_dumpall > pg_all.sql | ||
| − | + | ||
| + | exit | ||
| + | |||
| + | service postgresql-9.3 stop | ||
mv /var/lib/pgsql/9.3 /var/lib/pgsql/9.3-old | mv /var/lib/pgsql/9.3 /var/lib/pgsql/9.3-old | ||
| Line 252: | Line 256: | ||
su - postgres | su - postgres | ||
psql -d postgres -f pg_all.sql | psql -d postgres -f pg_all.sql | ||
| − | |||
| − | |||
Uraditi vacuum: | Uraditi vacuum: | ||
vacuumdb -az | vacuumdb -az | ||
| + | |||
| + | exit | ||
Ukljičiti novu verziju postgresa: | Ukljičiti novu verziju postgresa: | ||
