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
- database: mydb
- user: mydbuser
- password: mydbpassword
- table: mytable
When I run the following commands:
>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:
>pg_dump --username=mydbuser --format=p --table='myschema.mytable' --verbose
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
If something changed, what is the appropriate parameter sequence to make
pgsql-admin by date
|Next:||From: James Farrugia||Date: 2008-05-12 07:25:34|
|Subject: Re: Orphan TOAST object|
|Previous:||From: Tom Lane||Date: 2008-05-11 17:26:03|
|Subject: Re: Orphan TOAST object |