Re: URGENT: pg_restore problem

From: Andreas Schlegel <schlegel(at)software(dot)b(dot)uunet(dot)de>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: URGENT: pg_restore problem
Date: 2002-09-18 08:37:14
Message-ID: 3D883B3A.7090000@software.b.uunet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

... 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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2002-09-18 10:49:58 DB totaly in memory
Previous Message Wim 2002-09-18 08:36:53 Re: [GENERAL] Still big problems with pg_dump!