Fwd: pg_dump VS alter database ... set search_path ...

From: "Nikolay Samokhvalov" <samokhvalov(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Fwd: pg_dump VS alter database ... set search_path ...
Date: 2006-10-09 10:24:28
Message-ID: e431ff4c0610090324m4cf22823r437f0de829b4a2a8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

What is the reason to not include database settings (like search_path)
to database dump created with "pg_dump -C"?
For me, I've created tmp patch for pg_dump to make my system work
(patch for CVS version is included).

---------- Forwarded message ----------
From: Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>
Date: Oct 9, 2006 12:45 PM
Subject: pg_dump VS alter database ... set search_path ...
To: PostgreSQL-general <pgsql-general(at)postgresql(dot)org>

Hi,

What is the best practice for following case:
In my database I have a set (~10) of schemas; my database periodically
is being backed up and restored at another machine. I have set up
search_path via "ALTER DATABASE ... SET search_path TO ..." to make
all needed schemas visible to any user who has appropriate rights. The
problem is that I cannot use pg_dumpall and pg_dump DOES NOT dump this
ALTER command, even being executed with "-C" option.

Using additional restoration script with list of schemas seems not the
best solution, because a set of schemas can be changed and I have not
only one database.

Search in mail archives gives me understanding that this issue is
among not resolved ones (there are pros and cons for including such
ALTER in pg_dump-ing).

Is there any common practice for this [probably very frequent] issue?

--
Best regards,
Nikolay

--
Best regards,
Nikolay

Attachment Content-Type Size
pg_dump_settings82b1.patch application/octet-stream 1.6 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Markus Schiltknecht 2006-10-09 10:27:37 Intentionally produce Errors
Previous Message Christian Kasprowicz 2006-10-09 10:19:04 Storing Procedures / Transactions

Browse pgsql-hackers by date

  From Date Subject
Next Message Tzahi Fadida 2006-10-09 11:19:46 OT: Is there a LinkedIn group for Postgresql?
Previous Message Dave Page 2006-10-09 09:10:13 Re: Casting to money