Re: pg_restore peculiarities

From: Tim Penhey <tim(at)penhey(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_restore peculiarities
Date: 2004-09-18 18:15:19
Message-ID: 414C7B37.6080906@penhey.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

>It looks to me like you have a bunch of stuff in template1, which is
>being duplicated into your test_restored DB and then is interfering
>with the restoration of similarly-named objects.
>
>Create the empty database using template0 as template, instead, and
>then the restore will work.
>
> regards, tom lane
>
>
Which does bring another question forward:

What is all the stuff that has been added to template1 given it is a
clean install of version 8 beta 2 dev 3?

The only thing it asked in the installer was what languages to add to
the template, and I chose plpgsql only.

Thanks,
Tim

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paesold 2004-09-18 21:33:12 Re: pg_restore peculiarities
Previous Message Joshua D. Drake 2004-09-18 17:37:11 Re: Support on Enterprise Linux (newbie)