Moving a database

Поиск
Список
Период
Сортировка
От Ewan Leith
Тема Moving a database
Дата
Msg-id 1012BD903945D411915500105A48FF57126EBB@nt.man.fwltech.com
обсуждение исходный текст
Ответы Re: Moving a database
Список pgsql-admin
Hi all,

we recently upgraded from 6.53 to 7.1.2, and at the same time tried to move
the database to a new filesystem.

However, while the upgrade was 100% successful using pg_dumpall, we see that
postgres is still reading some files from the old file system (though only
updating the new files).

An example is pg_shadow which is read on both file systems whenever someone
seems to authenticate, but only updated on the new file system.

Does anyone have any ideas? Is it possible to move the location of Postgres
in this manner?

Thanks,
Ewan

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

Предыдущее
От: "darthxiong@libero.it"
Дата:
Сообщение: table name as parameter in pl/psql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Moving a database