copy database by copying datafiles ?

Поиск
Список
Период
Сортировка
От Alex Vinogradovs
Тема copy database by copying datafiles ?
Дата
Msg-id 1198533066.58046.5.camel@localhost
обсуждение исходный текст
Ответы Re: copy database by copying datafiles ?  (Thomas Hart <tomhart@coopfed.org>)
Re: copy database by copying datafiles ?  (Richard Broersma Jr <rabroersma@yahoo.com>)
Список pgsql-general
Guys,

I've created a copy of my database to run on a different server
by copying entire data directory while database instance was stopped.
Database generally works on the target machine, but I'm getting
following error when trying to create a plpgsql function :

ERROR: could not open relation 1664/0/1214: No such file or directory
SQL state: 58P01

I've checked, all the datafiles were coppied correctly. I'm not familiar
with storage internals, maybe there are some ties to inode numbers,
and thus such procedures aren't allowed at all ?

P.S. datafiles are 85GB in size, I couldn't really dump and restore...

Thank you!


Best regards,
Alex Vinogradovs

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

Предыдущее
От: brian
Дата:
Сообщение: Re: Postgres from PHP in Leopard
Следующее
От: Thomas Hart
Дата:
Сообщение: Re: copy database by copying datafiles ?