X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4D1F99FB2B8 for ; Tue, 5 Sep 2006 07:55:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 03735-06 for ; Tue, 5 Sep 2006 07:55:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id BED809FB2B2 for ; Tue, 5 Sep 2006 07:55:04 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1GKYoh-0008SG-Ee for pgsql-sql@postgresql.org; Tue, 05 Sep 2006 07:10:07 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id B61173FAF; Tue, 5 Sep 2006 06:54:53 -0400 (EDT) Date: Tue, 5 Sep 2006 06:54:53 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: pg_dump Message-ID: <20060905105453.GA28642@phlogiston.dyndns.org> References: <20060903070710.GA6473@KanotixBox> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.209 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/19 X-Sequence-Number: 26230 On Tue, Sep 05, 2006 at 02:22:29PM +0700, M. Santosa wrote: > and if i execute the psql with list database option, the result is error > > -bash-3.00$ psql -l > ERROR: relation "pg_catalog.pg_user" does not exist This looks to me like you have more than one postmaster installed, and you've got a mismatch in versions. Be my first guess, anyway. A -- Andrew Sullivan | ajs@crankycanuck.ca Users never remark, "Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath." --Damien Katz