Postgresql: erinevus redaktsioonide vahel
Allikas: Kuutõrvaja
Mine navigeerimisribaleMine otsikasti
New page: ===Paigaldus=== ===Upgrade=== |
Resümee puudub |
||
| 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: 10. jaanuar 2008, kell 22: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
