Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5C41F632A6B for ; Sun, 22 Feb 2009 05:43:27 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 88925-09 for ; Sun, 22 Feb 2009 05:43:24 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f176.google.com (mail-gx0-f176.google.com [209.85.217.176]) by mail.postgresql.org (Postfix) with ESMTP id 2A332632887 for ; Sun, 22 Feb 2009 05:43:24 -0400 (AST) Received: by gxk24 with SMTP id 24so5467033gxk.19 for ; Sun, 22 Feb 2009 01:43:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=X3PFvJ3ldALG68+2ZpcV92EKGxShFzAHsSD2VcDI2cM=; b=IMLcyqJOkLlKOQ1s1rGSkAQ69ltlJzDep4V2/SuSwcumXdQv9hj/s9qw4g+S6bVH3O Lt7u4ZRhxrDZQwU+sOYlzjpwCnQO3QLObipXmqVq7/I38JvSIqWfHNairX8C3C3jykNp gHrmIEkrHFsOWmWNhOd56kl3bxlCBmSwHzp5U= 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=Ka4A7XpC/uAbiMNRkwB4Jb3Sw345+DG88+5D9dEaXD/fpSE0DZCwVtdXLjVLr9OjjF fVgmtJ4r1ElWX3ZFFfUxtzWqXOx/GTaJsNLemYzb5369Uainb0rEq+9Q7UugYIn2xw4H 9hCUJcJfuTn5ozctETMThTVchxh+CuwF4QTSU= MIME-Version: 1.0 Received: by 10.150.123.16 with SMTP id v16mr4058100ybc.36.1235295803023; Sun, 22 Feb 2009 01:43:23 -0800 (PST) In-Reply-To: References: Date: Sun, 22 Feb 2009 02:43:22 -0700 Message-ID: Subject: Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6 From: Scott Marlowe To: Tena Sakai Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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: 200902/182 X-Sequence-Number: 31403 On Sun, Feb 22, 2009 at 2:32 AM, Tena Sakai wrote: > Hi, > > I am able to revert back to 8.3.3 system. Maybe > I can use 8.3.3 psql to read the dumpall output. > How can I direct the output to data directory of > 8.3.6 postgres? You don't have to dump and restore for a minor point update. Just stop your 8.3.3 and start 8.3.6 in the same data directory.