Thread: URGENT: pg_restore problem

Hi,

I tried to restore a pg database with pg_restore -d but the operation
was running on error:
ERROR:  Relation "..." does not exist
The database was dumped with pg_dump -Ft

As I know I can restore the database successful with psql>\i
But I don't know the parameter for dumping to create an ascii(?) dump.

Any ideas?

Greetings,
Andreas


I know I should analyse the database to find the problem but there is no
time. We need it on a notebook for a demo ;-)

... dumped with pg_dump -Fp

-- Andreas


Andreas Schlegel wrote:

> Hi,
>
> I tried to restore a pg database with pg_restore -d but the operation
> was running on error:
> ERROR:  Relation "..." does not exist
> The database was dumped with pg_dump -Ft
>
> As I know I can restore the database successful with psql>\i
> But I don't know the parameter for dumping to create an ascii(?) dump.
>
> Any ideas?
>
> Greetings,
> Andreas
>
>
> I know I should analyse the database to find the problem but there is
> no time. We need it on a notebook for a demo ;-)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>