From: Scott Marlowe <scott.marlowe@gmail.com>
To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
Cc: Kevin Kempter <kevink@consistentstate.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: User table porting
Date: Tue, 10 Mar 2009 13:33:54 -0600
Message-ID: <dcc563d10903101233s61724bb2hb4a4cd3c34786d3@mail.gmail.com> (raw)
In-Reply-To: <49B6B1A1.40908@gmx.de>
References: <1178C89D-62DF-44AA-A8CB-97FA782E869D@indiana.edu>
<200903101123.01310.kevink@consistentstate.com>
<49B6B1A1.40908@gmx.de>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, Jan-Peter.Seifert@gmx.de, kevink@consistentstate.com
Subject: Re: User table porting
In-Reply-To: <dcc563d10903101233s61724bb2hb4a4cd3c34786d3@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox