Re: search_path when restoring to new db

From: Richard Huxton <dev(at)archonet(dot)com>
To: Brandon Aiken <BAiken(at)winemantech(dot)com>
Cc: SunWuKung <Balazs(dot)Klein(at)t-online(dot)hu>, pgsql-general(at)postgresql(dot)org
Subject: Re: search_path when restoring to new db
Date: 2006-12-12 15:08:24
Message-ID: 457EC5E8.8070705@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Brandon Aiken wrote:
> PostgreSQL is simply very granular about what it lets you dump.

True enough, but I'd think you could make a good argument that dumping a
database should dump any ALTER commands that are attached to it.

Users are shared between databases, so I can see it doesn't necessarily
make sense to dump them. However, an ALTER DATABASE is meaningless
without the database concerned.
--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-12-12 15:16:52 Re: Restore database from files (not dump files)?
Previous Message DANTE Alexandra 2006-12-12 15:06:55 PostgreSQL 8.2 : IPO link warning with ICC 9.1.045