Hi,
Just want to know how I can restore all my index with a pg_restore ??
At first I dump like that :
pg_dump -t mytable -Fc -Z9 mydb > my_dump
To restore the complete table I have tried :
pg_restore -d mydb -t mytable -Fc -i my_dump
Without any result ... I have the table created, the data restored ...
but no index !?
with -v
Connecting to database for restore
Connecting to mydb as postgres
Creating TABLE mytable
Restoring data for mytable
What about my index ?
I also try :
pg_restore -d mydb -t mytable -Fc -i myindex1 -i myindex2 my_dump
Nothing more ...
Any idea ?
Regards,
--
Hervé Piedvache
Elma Ingenierie Informatique
6, rue du Faubourg Saint-Honoré
F-75008 - Paris - France
http://www.elma.fr
Tel: +33-1-44949901
Fax: +33-1-44949902
Email: herve@elma.fr