DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=owAEdFnz1Ng641dMZ3fZBUzeP2UkxvuVcuzWfcjp3e3tXdfhGL6qbHGqmA5QienwJO
	/f7RHkIkfBlFsbtH/BlUy1Ku1vuGtBtEHa+mNx6bhWvo4G2bBH6VT4q9z1tS6SdNKKI9
	+RZrDllUX0tgnMyKVog6RCtzIEMQkOMvQsmZY=
MIME-Version: 1.0
In-Reply-To: <49B6B1A1.40908@gmx.de>
References: <1178C89D-62DF-44AA-A8CB-97FA782E869D@indiana.edu>
	<200903101123.01310.kevink@consistentstate.com>
	<49B6B1A1.40908@gmx.de>
Date: Tue, 10 Mar 2009 13:33:54 -0600
Message-ID: <dcc563d10903101233s61724bb2hb4a4cd3c34786d3@mail.gmail.com>
Subject: Re: User table porting
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
Cc: Kevin Kempter <kevink@consistentstate.com>, pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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.