Re: File system level backup

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: File system level backup
Дата
Msg-id 50194FC10200002500049333@gw.wicourts.gov
обсуждение исходный текст
Ответ на File system level backup  ("Manoj Agarwal" <ma@ockham.be>)
Ответы Re: File system level backup  ("Manoj Agarwal" <ma@ockham.be>)
Список pgsql-general
"Manoj Agarwal" <ma@ockham.be> wrote:

> I need to transfer the database from one machine to other.  Both
> machines contain a database with the same name, for example:
> testdb, but with different data/values, but the structure is
> exactly same.

> Take file system level backup from  from first machine for
> Postgres database 'testdb' and restore it in another instance that
> has SAME version of Postgres.  i.e. backup the database 'testdb'
> from Postgres 7.4.19 and restore it on another virtual machine
> with same Postgres version 7.4.19.

You cannot use file system level copy for individual databases in a
cluster.

-Kevin

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

Предыдущее
От: Condor
Дата:
Сообщение: Need help with SQL query and finding NULL array_agg
Следующее
От: Michael Nolan
Дата:
Сообщение: Re: Streaming replication and high query cancellation values