[#MBS-5316] Remove PGOPTIONS/search_path from ./admin/psql - MusicBrainz JIRA

MusicBrainz Server

Created: 18/Sep/12 05:25 PM Updated: 01/Oct/12 03:23 PM Resolved: 01/Oct/12 03:23 PM

Component/s:

None

Affects Version/s:

None

Fix Version/s:

Schema change, 2012-10-15

Description

« Hide

This is not compatible with pgbouncer, so anything relying on admin/psql breaks entirely. The correct way to do this, is to:

ALTER USER some_user SET SEARCH PATH = musicbrainz, public;

And then the search_path will always be correct.

Sort Order:

[ Permalink | « Hide ]

[ Permalink | « Hide ]

The merge window for 2012-10-01 is now closed, so this will have to wait until 2012-10-15.

[ Permalink | « Hide ]

Merged to beta, but this requires deployment to be tested so I'm closing as fixed.