From: David Levy <dvid.levy@gmail.com>
To: pgsql-admin@postgresql.org
Subject: pg_restore index/trigger restoration issue
Date: Thu, 27 Apr 2006 13:36:53 +0200
Message-ID: <52543fce0604270436y107660e3tc536996368a37c8f@mail.gmail.com> (raw)
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 8.1).
Is there something incompatible ?
The dump file seems to be correct regarding index creation statements... I
really don't understand what is happening.
As the title mentions, I have the same issue with triggers : none of my
triggers are restored neither ! Is there any option in pg_dump or pg_restore
to handle this ?
Regards
Thanks in advance
David LEVY
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: dvid.levy@gmail.com
Subject: Re: pg_restore index/trigger restoration issue
In-Reply-To: <52543fce0604270436y107660e3tc536996368a37c8f@mail.gmail.com>
References: <52543fce0604270436y107660e3tc536996368a37c8f@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox