[ADMIN] pg_restore index/trigger restoration issue

2006-04-27 Thread David Levy
Hi, I am having troubles using pg_restore : none of my indexes are restored !It did not see any relevant message in the pg_restore output to explain this behaviour.So I am trying to restore a pg_dump (version8.1 ) sql dump file from a remote 8.0.3 DB into a local 8.1 DB using pg_restore (version

[ADMIN] pg_restore index/trigger restoration issue

2006-04-27 Thread David Levy
Hi, I am having troubles using pg_restore : none of my indexes are restored !It did not see any relevant message in the pg_restore output to explain this behaviour.So I am trying to restore a pg_dump ( version8.1 ) sql dump file from a remote 8.0.3 DB into a local 8.1 DB using pg_restore (version

Re: [ADMIN] pg_restore index/trigger restoration issue

2006-04-27 Thread Jerry Sievers
David Levy [EMAIL PROTECTED] writes: So I am trying to restore a pg_dump (version8.1 ) sql dump file from a remote 8.0.3 DB into a local 8.1 DB using pg_restore (version 8.1). Is there something incompatible The dump file seems to be correct regarding index creation statements I really don't

Re: [ADMIN] pg_restore index/trigger restoration issue

2006-04-27 Thread David Levy
I am using pgAdmin and phpPgAdmin with the same results (no triggers, no indexes).Thanks but the docs were not helpful yet. I've been trying to solve the issue many times in the past few monthes before posting to the list today. :(On 27 Apr 2006 07:45:55 -0400, Jerry Sievers [EMAIL PROTECTED]