pg_restore: implied data-only restore\n

On Friday, February 04, 2011 4:35:22 am Andreas Laggner wrote:

Hi list,

i did a dump (one table)
pg_dump -t tempo.lucas_p1000 -Fc -o -h 134.110.37.20 -p 5432 -U andi -W
gis > /disk2/samba/exportdb/postgres/lucas_p1000_test.out

and when a want to restore the table
pg_restore -d gis -t tempo.lucas_p1000 -Fc -v -h 134.110.37.20 -p 5432
-U andi -W /disk2/samba/exportdb/postgres/lucas_p1000_test.out

pg_restore shows this error:
pg_restore: implied data-only restore\n

what is wrong?

Did it restore the data?

According to the source pg_backup_archiver.c:

"Work out if we have an implied data-only restore. This can happen if
the dump was data only or if the user has used a toc list to exclude
all of the schema data. All we do is look for schema entries - if none
are found then we set the dataOnly flag."

Are you sure you are picking up the right lucas_p100_test.out file? Maybe there
is a data only version lying around. One way to test is have pg_restore restore
to a file instead of database:

pg_restore -f tempo.sql -t tempo.lucas_p1000
/disk2/samba/exportdb/postgres/lucas_p1000_test.out

thanks for help Andreas

--
Adrian Klaver
adrian.klaver@gmail.com