Postgres Pro
Downloads
Home   >   mailing lists

9.2 upgrade glitch with search_path - Mailing list pgsql-general

From Scott Ribe
Subject 9.2 upgrade glitch with search_path
Date
Msg-id 4F522627-E3C0-4AF6-A618-1C820CAEABDC@elevated-dev.com
Whole thread Raw
Responses Re: 9.2 upgrade glitch with search_path  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Built & installed 9.2.3. Dumped 9.1 db (using 9.2 pg_dump IIRC). Restored.

Database search path was not restored. Had to execute alter database ... set search_path to...

Dump commands:

pg_dumpall -g -f roles.dump
pg_dump -F c -Z 0 -v pedcard > db.dump

Restore commands:

psql -f roles.dump postgres
pg_restore -j 4 -veC -d postgres db.dump


--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice

pgsql-general by date:

Previous
From: Vibhor Kumar
Date:
Subject: Re: pg_upgrade failed for 9.0 to 9.2
Next
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade failed for 9.0 to 9.2