Re: [GENERAL] pg_restore should restore the schema comments and the database properties

2011-12-20 Thread Adrian Klaver
On Tuesday, December 20, 2011 7:02:13 am Alban Hertroys wrote: > On 20 December 2011 15:35, Adrian Klaver wrote: > > To elaborate on my previous answer, search_path is in postgresql.conf > > because it is tied to the database cluster not a particular database. > > Not necessarily, it can also be

Re: [GENERAL] pg_restore should restore the schema comments and the database properties

2011-12-20 Thread Alban Hertroys
On 20 December 2011 15:35, Adrian Klaver wrote: > To elaborate on my previous answer, search_path is in postgresql.conf because > it > is tied to the database cluster not a particular database. Not necessarily, it can also be tied to a schema or a role or (I assume) a specific database in the cl

Re: [GENERAL] pg_restore should restore the schema comments and the database properties

2011-12-20 Thread Adrian Klaver
On Tuesday, December 20, 2011 2:48:31 am Daniel Migowski wrote: > Hi, > > I know this discussion has already been made, but for us it is a real > problem that database properties are not restored with pg_restore. For me, > the comment on a database, as well as the properties like pg_search_path >

Re: [GENERAL] pg_restore should restore the schema comments and the database properties

2011-12-20 Thread Adrian Klaver
On Tuesday, December 20, 2011 2:48:31 am Daniel Migowski wrote: > Hi, > > I know this discussion has already been made, but for us it is a real > problem that database properties are not restored with pg_restore. For me, > the comment on a database, as well as the properties like pg_search_path >

[GENERAL] pg_restore should restore the schema comments and the database properties

2011-12-20 Thread Daniel Migowski
Hi, I know this discussion has already been made, but for us it is a real problem that database properties are not restored with pg_restore. For me, the comment on a database, as well as the properties like pg_search_path are part of the data of the database. They are even contained in the dump