Moving the database from a filesystem to another

Поиск
Список
Период
Сортировка
От Együd Csaba
Тема Moving the database from a filesystem to another
Дата
Msg-id 000201c3c0c8$f8182530$230a0a0a@compaq
обсуждение исходный текст
Ответы Re: Moving the database from a filesystem to another
Re: Moving the database from a filesystem to another
Список pgsql-general
Hi All,
one of my customers has a Postgres 7.2.3 DB on an RH7.1 box. Running df it
seems that the DB is not on the appropriate filesystem.

/dev/md1               5040352   2562316   2221992  54% /
/dev/md0                100020      8989     85867  10% /boot
/dev/md2              28831612      9800  27357244   1% /data

I suppose md2 was planned for storing the database, but it is on md1
($PGDATA = /var/lib/pgsql/data). Am I right?

md1 is about fulling up in some months, so I think it should be a good idea
to move the store to md2. How can I do this?
Is it enough to copy/move the directory /var/lib/pgsql/data to eg.
/data/pgsql/data and set $PGDATA to that directory?

Thank you,
-- Együd Csaba


В списке pgsql-general по дате отправления:

Предыдущее
От: Manuel Duran Aguete
Дата:
Сообщение: experiences with postgres in ia64 and linux
Следующее
От: "John Sidney-Woollett"
Дата:
Сообщение: Re: [NOVICE] PostgreSQL Training