Re: pg_restore peculiarities - Mailing list pgsql-general

From Tim Penhey
Subject Re: pg_restore peculiarities
Date
Msg-id 414C7B37.6080906@penhey.net
Whole thread Raw
In response to Re: pg_restore peculiarities  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Support on Enterprise Linux (newbie)
Next
From: "Michael Paesold"
Date:
Subject: Re: pg_restore peculiarities