Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 49D55633F01 for ; Tue, 10 Mar 2009 15:30:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 21726-02-6 for ; Tue, 10 Mar 2009 15:30:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mail.postgresql.org (Postfix) with SMTP id A4CA4633EA4 for ; Tue, 10 Mar 2009 15:30:08 -0300 (ADT) Received: (qmail invoked by alias); 10 Mar 2009 18:30:06 -0000 Received: from dslc-082-082-180-252.pools.arcor-ip.net (EHLO [192.168.123.148]) [82.82.180.252] by mail.gmx.net (mp061) with SMTP; 10 Mar 2009 19:30:06 +0100 X-Authenticated: #955937 X-Provags-ID: V01U2FsdGVkX1+hJQt45Y+hsVjlKk+oKxVHmJTEsYyCWCiZHTpTDF 7E47BqM330z9U0 Message-ID: <49B6B1A1.40908@gmx.de> Date: Tue, 10 Mar 2009 19:29:53 +0100 From: Jan-Peter Seifert User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: Kevin Kempter CC: pgsql-admin@postgresql.org Subject: Re: User table porting References: <1178C89D-62DF-44AA-A8CB-97FA782E869D@indiana.edu> <200903101123.01310.kevink@consistentstate.com> In-Reply-To: <200903101123.01310.kevink@consistentstate.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-FuHaFi: 0.66 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/135 X-Sequence-Number: 31635 Hello, Kevin Kempter wrote: > On Tuesday 10 March 2009 11:13:54 Carol Walter wrote: >> I want to recreate users with their passwords from one database >> cluster on another database cluster. What would be the best way for >> me to do this? > from the "old" server run this (where is the new server): > pg_dumpall -g | psql -h Isn't it generally better to use the newer binaries from the target server especially with psql? 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.): http://www.postgresql.org/docs/8.3/interactive/app-pg-dumpall.html Peter