Alberto <nspmma@xxxxxxxxxx> writes: > I have tried to backup my postgres database with > pg_dump -Fc $db > ~/backups/$db.backup.c > and restore it with: > createdb -U postgres -D aestel_admin -T template0 restoreTMP > pg_restore -d restoreTMP -U postgres $db.backup.c > I do not get any error messages but none of my indexes are created. Works for me ... can you create a self-contained test case? What PG version are you using, anyway (and are you sure the pg_dump and pg_restore programs are of the same version)? regards, tom lane
