Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 99241B5DC1E for ; Wed, 14 Sep 2011 03:35:30 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 28594-02-2 for ; Wed, 14 Sep 2011 06:35:24 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from mail1.sun.ac.za (mail1.sun.ac.za [146.232.64.12]) by mail.postgresql.org (Postfix) with ESMTP id DD335B5DC09 for ; Wed, 14 Sep 2011 03:35:23 -0300 (ADT) Received: from artikel.sun.ac.za ([146.232.82.145]) by mail1.sun.ac.za with esmtp (Exim 4.69) (envelope-from ) id 1R3j44-0001Z5-0K for pgsql-admin@postgresql.org; Wed, 14 Sep 2011 08:35:20 +0200 Received: from js by artikel.sun.ac.za with local (Exim 4.76) (envelope-from ) id 1R3j43-0001hO-Ru for pgsql-admin@postgresql.org; Wed, 14 Sep 2011 08:35:19 +0200 Date: Wed, 14 Sep 2011 08:35:19 +0200 From: Johann Spies To: "pgsql-admin@postgresql.org" Subject: Re: Problem restoring a dump Message-ID: <20110914063519.GB733@sun.ac.za> Mail-Followup-To: Johann Spies , "pgsql-admin@postgresql.org" References: <20110913091831.GA26669@sun.ac.za> <7728C00C-EFC8-401E-A0A5-76A253269C89@2ndquadrant.it> <196cf71cbca8f7fb8505fb2da9469fbe@2ndquadrant.it> <20110913124740.GA30709@sun.ac.za> <4E7009CB.9050807@ringerc.id.au> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4E7009CB.9050807@ringerc.id.au> User-Agent: Mutt/1.5.21 (2010-09-15) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.404 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201109/94 X-Sequence-Number: 38331 On Wed, Sep 14, 2011 at 03:56:27AM +0200, Craig Ringer wrote: > > You can't change the encoding of a database in-place. Thanks Craig and all the other that responded. Enjoy your day. Regards Johann -- Johann Spies Telefoon: 021-808 4699 Databestuurder / Data manager Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and Technology Universiteit Stellenbosch. "But without faith it is impossible to please him: for he that cometh to God must believe that he is, and that he is a rewarder of them that diligently seek him." Hebrews 11:6