Re: Restore/dump from "/usr/local/pgsql/data" directory

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Restore/dump from "/usr/local/pgsql/data" directory
Дата
Msg-id 201009232134.o8NLYTT03295@momjian.us
обсуждение исходный текст
Ответ на Restore/dump from "/usr/local/pgsql/data" directory  (kongsgar@stud.ntnu.no)
Ответы Re: Restore/dump from "/usr/local/pgsql/data" directory  (kongsgar@stud.ntnu.no)
Список pgsql-general
kongsgar@stud.ntnu.no wrote:
> Hi,
> I have a copy of "/usr/local/pgsql/data" from old server. Is it
> possible to do a dump of the sql databases in this directory, so that
> I can easily migrate them to my current system?

Yes, run pg_dumpall, save it, and load it into the new system.  You
really haven't given us much information on what problem you are having.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

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

Предыдущее
От: kongsgar@stud.ntnu.no
Дата:
Сообщение: Restore/dump from "/usr/local/pgsql/data" directory
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: Restore/dump from "/usr/local/pgsql/data" directory