Re: search_path when restoring to new db - Mailing list pgsql-general

From Richard Huxton
Subject Re: search_path when restoring to new db
Date
Msg-id 457EC5E8.8070705@archonet.com
Whole thread Raw
In response to Re: search_path when restoring to new db  ("Brandon Aiken" <BAiken@winemantech.com>)
Responses Re: search_path when restoring to new db  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-general by date:

Previous
From: DANTE Alexandra
Date:
Subject: PostgreSQL 8.2 : IPO link warning with ICC 9.1.045
Next
From: Tom Lane
Date:
Subject: Re: Restore database from files (not dump files)?