Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 9C4062E006D for ; Mon, 12 May 2008 08:47:26 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 92349-06 for ; Mon, 12 May 2008 08:47:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by developer.postgresql.org (Postfix) with ESMTP id 923842E003B for ; Mon, 12 May 2008 08:47:08 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1JvWUf-0004MN-Dh for pgsql-admin@postgresql.org; Mon, 12 May 2008 11:47:01 +0000 Received: from pirus.securax.be ([213.16.46.130]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 12 May 2008 11:47:01 +0000 Received: from milen by pirus.securax.be with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 12 May 2008 11:47:01 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: pg_dump 8.3 changes from 8.2 Date: Mon, 12 May 2008 14:46:41 +0300 Lines: 32 Message-ID: References: <8b3ae1cc0805111112h53156be3nbb5d6ce1cb8bc433@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: pirus.securax.be User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) In-Reply-To: <8b3ae1cc0805111112h53156be3nbb5d6ce1cb8bc433@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/89 X-Sequence-Number: 29173 Denison Wright написа: > > Hi, > > I had a command that I used with Postgresql 8.2 that stopped working once I > upgraded to 8.3. > I am running Postgresql 8.3 on Windows Vista with the following basic > configuration: > > - database: mydb > - user: mydbuser > - password: mydbpassword > - schema:myschema > - table: mytable > > When I run the following commands: > >> set PGPASSWORD=mydbpassword >> pg_dump mydb -U mydbuser -a -f backup.sql -F plain -t 'myschema.mytable' Put the DB name at the end of the command line, e.g. pg_dump -U mydbuser -a -f backup.sql -F plain -t 'myschema.mytable' mydb > > I get the following error now: "pg_dump: too many command-line arguments" [...] -- Milen A. Radev