Re: pg_dump and alter database
От | |
---|---|
Тема | Re: pg_dump and alter database |
Дата | |
Msg-id | 64808.216.238.112.88.1061571394.squirrel@$HOSTNAME обсуждение исходный текст |
Ответ на | Re: pg_dump and alter database (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
> <btober@seaworthysys.com> writes: >> I HAVE used pg_dumpall -g to make a backup of of users and groups, >> but this output does not include the ALTER DATABASE commands. > > No, it looks like pg_dumpall dumps ALTER DATABASE operations for a > particular database when it dumps that database. > >> Does the ALTER DATABASE command get written only when I do an >> unconditional pg_dumpall, i.e., produce a dump of all databases in >> the cluster? If that is the case, then I do think the feature ought >> to be included in pg_dump, > > I think there were a couple of arguments for doing it this way. I can > see a permissions issue for one. pg_dumpall scripts assume they will > be run by superuser, but pg_dump scripts try to avoid that assumption. > Also, a pg_dump script doesn't (and shouldn't, IMHO) assume it knows > the name of the database it's being restored into. > I see what you mean about the database name issue, which has the most impact in my particular case, of course. Would it be possible to do something like ALTER DATABASE CURRENT_DATABASE() SET search_path = schema1, schema2; ? ~Berend Tober
В списке pgsql-general по дате отправления: