Re: Version upgrade: is restoring the postgres database needed?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Version upgrade: is restoring the postgres database needed?
Дата
Msg-id 3a9f4ef2-f373-bd34-f0dc-58abc7301984@cox.net
обсуждение исходный текст
Ответ на Version upgrade: is restoring the postgres database needed?  (Ron Johnson <ron.l.johnson@cox.net>)
Ответы Re: Version upgrade: is restoring the postgres database needed?
Список pgsql-general
Дерево обсуждения 
On 03/01/2018 11:46 AM, Adrian Klaver wrote:
[snip]
>> Hmmm.  I just looked at the script, and it says:
>>
>> $ pg_dumpall --schema-only > globals.sql
>>
>> That's not good.
>
> Well it would dump the globals, but also the schema definitions for all 
> the objects in the cluster. Though at this point we are only half way 
> through the process. What is you restore procedure?

$ psql < globals.sql
$ pg_restore --clean --create --if-exists --exit-on-error --jobs=2 
${SRC}/${DB}.pgdump


-- 
Angular momentum makes the world go 'round.

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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Version upgrade: is restoring the postgres database needed?
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: How to avoid trailing zero (after decimal point) for numeric type column