Erinevus lehekülje "Postgresql" redaktsioonide vahel
Allikas: Kuutõrvaja
(New page: ===Paigaldus=== ===Upgrade===) |
|||
| 2. rida: | 2. rida: | ||
===Upgrade=== | ===Upgrade=== | ||
| + | |||
| + | Postgres upgrade puhul oleks soovitatav | ||
| + | dumpida kogu baas ja hiljem restoreda | ||
| + | |||
| + | pg_dumpall -U ruut -a > pgdump | ||
| + | /etc/init.d/postgresql stop | ||
| + | emerge postgresql | ||
| + | nano pg_hda | ||
| + | su postgres | ||
| + | initdb -D /home/pgsql | ||
| + | postgres -D /home/pgsql | ||
| + | psql -d postgres -f pgdump | ||
| + | |||
| + | ===Lingid=== | ||
| + | |||
| + | http://gentoo-wiki.com/HOWTO_Configure_Postgresql | ||
| + | |||
| + | http://www.postgresql.org/docs/8.1/interactive/install-upgrading.html | ||
Redaktsioon: 11. jaanuar 2008, kell 00:58
Paigaldus
Upgrade
Postgres upgrade puhul oleks soovitatav dumpida kogu baas ja hiljem restoreda
pg_dumpall -U ruut -a > pgdump /etc/init.d/postgresql stop emerge postgresql nano pg_hda su postgres initdb -D /home/pgsql postgres -D /home/pgsql psql -d postgres -f pgdump
Lingid
http://gentoo-wiki.com/HOWTO_Configure_Postgresql
http://www.postgresql.org/docs/8.1/interactive/install-upgrading.html
