lib/prodder/pg.rb in prodder-1.7.6 vs lib/prodder/pg.rb in prodder-1.7.7
- old
+ new
@@ -123,11 +123,10 @@
#From pg_dump
ACL_GRANT = /^GRANT /
ACL_REVOKE = /^REVOKE /
DEFAULT_PRIVILEGES = /^ALTER DEFAULT PRIVILEGES /
SET_OBJECT_OWNERSHIP = /.* OWNER TO /
- SEARCH_PATH = /SET search_path = .*/
def dump_db_access_control(db_name, user_list, options)
perm_out_sql = ""
arguments = [
'--schema-only',
@@ -151,11 +150,10 @@
run ['pg_dump', *arguments] do |out, err, success|
out.each_line do |line|
if line.match(ACL_GRANT) ||
line.match(ACL_REVOKE) ||
line.match(DEFAULT_PRIVILEGES) ||
- line.match(SET_OBJECT_OWNERSHIP)||
- line.match(SEARCH_PATH)
+ line.match(SET_OBJECT_OWNERSHIP)
unless irrelevant_login_roles.include?(line.match(/ (\S*);$/)[1])
perm_out_sql << line
user_list << (line.match(/ (\S*);$/)[1]).gsub(/"/, '')
end