9.2 upgrade glitch with search_path

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: 9.2 upgrade glitch with search_path
Date: 2013-01-13 19:26:33
Message-ID: 4F522627-E3C0-4AF6-A618-1C820CAEABDC@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2013-01-13 19:28:15 Re: pg_upgrade failed for 9.0 to 9.2
Previous Message Vibhor Kumar 2013-01-13 19:17:34 Re: pg_upgrade failed for 9.0 to 9.2