Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_restore: implied data-only restore\n

pg_restore: implied data-only restore\n

From
Andreas Laggner
Date:
  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?

thanks for help        Andreas


--
Dipl. Geoökologe Andreas Laggner

Institut für Agrarrelevante Klimaforschung (AK) des vTI
Arbeitsgruppe Emissionsinventare
Johann Heinrich von Thünen-Institut (vTI),
Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei

Institute of Agricultural Climate Research (AK) of the vTI
Johann Heinrich von Thünen-Institute (vTI),
Federal Research Institute for Rural Areas, Forestry and Fisheries

Bundesallee 50
D-38116 Braunschweig

Tel.: (+49) (0)531 596 2636
Fax : (+49) (0)531 596 2645
E-mail: andreas.laggner@vti.bund.de
Homepage: http://www.vti.bund.de

Re: pg_restore: implied data-only restore\n

From
Adrian Klaver
Date:
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