Thread: PgAdmin : table backup problem
pg_dump: server version: 8.2.1; pg_dump version: 8.2.0
pg_dump: proceeding despite version mismatch
pg_dump: No matching tables were found
pg_dump: *** aborted because of error
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined conversions
pg_dump: reading user-defined tables
pg_dump: reading table inheritance information
pg_dump: reading rewrite rules
pg_dump: reading type casts
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: finding the columns and types of table "collezioni"
pg_dump: finding default expressions of table "collezioni"
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading indexes for table "collezioni"
pg_dump: reading constraints
pg_dump: reading foreign key constraints for table "collezioni"
pg_dump: reading triggers
pg_dump: reading triggers for table "collezioni"
pg_dump: reading dependency data
pg_dump: saving encoding = LATIN1
pg_dump: saving standard_conforming_strings = off
pg_dump: dumping contents of table collezioni
Marco Cassiano
Manifatture del Nord srl unipersonale
Gruppo MaxMara
via Mazzacurati 6
42100 Reggio Emilia RE
ITALY
Tel. +39 0522 358215
Fax +39 0522 268715
email : mcassiano@manord.com
www.pennyblack.com
The contents of the present communication is strictly confidential and reserved solely to the referred addressees. In the event was received by person different from the addressee, it is forbidden the diffusion, distribution and copy. In the event you have received it mistakenly we ask you to inform us and to destroy and/or to delete it by your computer, without using the data herein contained.
The present message (eventual annexes inclusive) shall not be considered any contractual proposal and/or acceptance of offer coming from the addressee, nor waiver neither recognizance of rights, debts and/or credits, and it shall not be binding, when it is not executed a subsequent agreement by person who could lawfully represent us. No pre-contractual liability shall derive to us, when the present communication is not followed by any binding agreement between the parties.
---------------------------------------------------------------------------------------------
"Cassiano, Marco" <mcassiano@manord.com> writes: > If I understand well, PgAdmin fails in composing the correct pg_dump command. > The switch combination -t collezioni -n anamat doesn't work. The > manual says that the -n switch is ignored when -t is used > The right (at least, working) syntax seems to be the following : > /usr/local/pgsql/bin/pg_dump -U user -F c -v -f /tmp/collezioni.backup -t anamat.collezioni mdn This is something that was changed in 8.2. You seem to be using a PgAdmin that expects the pre-8.2 convention. If this is the latest version of PgAdmin then you need to complain to the PgAdmin developers (not here --- they have their own mailing lists). regards, tom lane
"Cassiano, Marco" <mcassiano@manord.com> writes:If I understand well, PgAdmin fails in composing the correct pg_dump command. The switch combination -t collezioni -n anamat doesn't work. The manual says that the -n switch is ignored when -t is used The right (at least, working) syntax seems to be the following : /usr/local/pgsql/bin/pg_dump -U user -F c -v -f /tmp/collezioni.backup -t anamat.collezioni mdnThis is something that was changed in 8.2. You seem to be using a PgAdmin that expects the pre-8.2 convention. If this is the latest version of PgAdmin then you need to complain to the PgAdmin developers (not here --- they have their own mailing lists).
FYI (the OP's original e-mail was copied in to pgadmin-support) this is fixed in the upcoming PgAdmin 1.6.3.