pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pg_dump 8.3 changes from 8.2 2+ messages / 2 participants [nested] [flat]
* pg_dump 8.3 changes from 8.2 @ 2008-05-11 18:12 Denison Wright <denisonwright@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Denison Wright @ 2008-05-11 18:12 UTC (permalink / raw) To: pgsql-admin <pgsql-admin@postgresql.org> 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' I get the following error now: "pg_dump: too many command-line arguments" Then, I tried the following to see what would happen: >set PGPASSWORD=mydbpassword >set PGDATABASE=mydb >pg_dump --username=mydbuser --format=p --table='myschema.mytable' --verbose --data-only --file=backup.sql Error: dump: No matching tables were found dump: *** aborted because of error Does anyone know if there were changes from 8.2 to 8.3 that would cause the above command to stop working? I couldn't tell from the 8.3 documentation online. If something changed, what is the appropriate parameter sequence to make that work? Thanks, Denison ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_dump 8.3 changes from 8.2 @ 2008-05-12 11:46 Milen A. Radev <milen@radev.net> parent: Denison Wright <denisonwright@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Milen A. Radev @ 2008-05-12 11:46 UTC (permalink / raw) To: pgsql-admin Denison Wright написа: > <pgsql-admin@postgresql.org> > 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-05-12 11:46 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-05-11 18:12 pg_dump 8.3 changes from 8.2 Denison Wright <denisonwright@gmail.com> 2008-05-12 11:46 ` Milen A. Radev <milen@radev.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox