Re: User table porting

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: User table porting
Дата
Msg-id dcc563d10903101233s61724bb2hb4a4cd3c34786d3@mail.gmail.com
обсуждение исходный текст
Ответ на Re: User table porting  (Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>)
Список pgsql-admin
On Tue, Mar 10, 2009 at 12:29 PM, Jan-Peter Seifert
<Jan-Peter.Seifert@gmx.de> wrote:
>
> Isn't it generally better to use the newer binaries from the target
> server especially with psql?

Generally this is true.

> I remember getting quite a few errors when restoring a pg_dumpall from
> an 8.1 server, because the create user syntax in the dump file was obsolete.
> You might need some more options for piping (-U etc.):

But we're not really doing a pg_dumpall of everything, just he global
objects.  Not sure if there's any issues with a later version versus a
newer version there.  Probably best to use the newer pg_dumpall /
pg_dump than the older one though.

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

Предыдущее
От: Jan-Peter Seifert
Дата:
Сообщение: Re: User table porting
Следующее
От: "Peter M. Van Buren"
Дата:
Сообщение: Can multiple users own and maintain a database?