Re: 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(dot)klaver(at)gmail(dot)com