Module: Cloner::Postgres

Extended by:
ActiveSupport::Concern
Included in:
Internal
Defined in:
lib/cloner/postgres.rb

Instance Method Summary collapse

Instance Method Details

#clone_pg ⇒ Object 



136
137
138
139
140
 
# File 'lib/cloner/postgres.rb', line 136

def clone_pg
  pg_dump_remote()
  pg_dump_copy()
  pg_dump_restore()
end

#pg_bin_path(util) ⇒ Object 



35
36
37
 
# File 'lib/cloner/postgres.rb', line 35

def pg_bin_path(util)
  util
end

#pg_dump_copy ⇒ Object 



130
131
132
133
134
 
# File 'lib/cloner/postgres.rb', line 130

def pg_dump_copy
  FileUtils.mkdir_p(pg_path)
  `mkdir -p #{e pg_path}`
  rsync(remote_dump_path, pg_path)
end

#pg_dump_extra ⇒ Object 



20
21
22
 
# File 'lib/cloner/postgres.rb', line 20

def pg_dump_extra
  ""
end

#pg_dump_param ⇒ Object 



24
25
26
27
28
29
 
# File 'lib/cloner/postgres.rb', line 24

def pg_dump_param
  if pg_dump_extra != ""
    puts "WARN pg_dump_extra is deprecated, use def pg_dump_param; super + ' extra'"
  end
  "-Fc #{pg_dump_extra}"
end

#pg_dump_remote ⇒ Object 



76
77
78
79
80
81
82
83
84
85
86
87
88
89
 
# File 'lib/cloner/postgres.rb', line 76

def pg_dump_remote
  puts "backup remote DB via ssh"
  do_ssh do |ssh|
    ssh.exec!("rm -R #{e remote_dump_path}")
    ret = ssh_exec!(ssh, "mkdir -p #{e remote_dump_path}")
    check_ssh_err(ret)
    host = remote_db_config['host'].present? ? " -h #{e remote_db_config['host']}" : ""
    port = remote_db_config['port'].present? ? " -p #{e remote_db_config['port']}" : ""
    dump = pg_remote_auth + "#{pg_remote_bin_path 'pg_dump'} #{pg_dump_param} -U #{e remote_db_config['username']}#{host}#{port} #{e remote_db_config['database']} > #{e(remote_dump_path + '/'+db_file_name+'.bak')}"
    puts dump if verbose?
    ret = ssh_exec!(ssh, dump)
    check_ssh_err(ret)
  end
end

#pg_dump_restore ⇒ Object 



91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
 
# File 'lib/cloner/postgres.rb', line 91

def pg_dump_restore
  puts "restoring DB"
  
  if local_docker_compose? && local_docker_compose_service
    # Docker compose restore - pipe the backup file to docker compose exec
    host = local_db_config['host'].present? ? " -h #{e local_db_config['host']}" : ""
    port = local_db_config['port'].present? ? " -p #{e local_db_config['port']}" : ""
    
    env_str = local_db_config['password'].present? ? "--env PGPASSWORD=#{e local_db_config['password']}" : ""
    compose_path = local_docker_compose_path
    compose_file = local_docker_compose_file
    service = local_docker_compose_service
    
    restore = "cat #{e(pg_path + '/'+db_file_name+'.bak')} | (cd #{e compose_path} && docker compose -f #{e compose_file} exec -T #{env_str} #{e service} pg_restore #{pg_restore_param} -U #{e local_db_config['username']}#{host}#{port} -d #{e ar_to})"
    puts restore if verbose?
    system(restore)
    ret = $?.to_i
  else
    # Standard restore
    host = local_db_config['host'].present? ? " -h #{e local_db_config['host']}" : ""
    port = local_db_config['port'].present? ? " -p #{e local_db_config['port']}" : ""
    restore = pg_local_auth + "#{pg_local_bin_path 'pg_restore'} #{pg_restore_param} -U #{e local_db_config['username']}#{host}#{port} -d #{e ar_to} #{e(pg_path + '/'+db_file_name+'.bak')}"
    puts restore if verbose?
    pipe = IO.popen(restore)
    while (line = pipe.gets)
      print line if verbose?
    end
    ret = $?.to_i
  end
  
  if ret != 0
    puts "Error: local command exited with #{ret}"
  end
end

#pg_local_auth ⇒ Object 



4
5
6
7
8
9
10
 
# File 'lib/cloner/postgres.rb', line 4

def pg_local_auth
  if local_db_config['password'].blank?
    ""
  else
    "PGPASSWORD='#{local_db_config['password']}' "
  end
end

#pg_local_bin_path(util) ⇒ Object 



39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
 
# File 'lib/cloner/postgres.rb', line 39

def pg_local_bin_path(util)
  if local_docker_compose? && local_docker_compose_service
    # For pg_restore, we pipe data in, so we don't wrap it in docker compose
    return util if util == "pg_restore"
    
    # Build docker compose exec command
    env_vars = {}
    env_vars['PGPASSWORD'] = local_db_config['password'] if local_db_config['password'].present?
    
    compose_cmd = local_docker_compose_exec(
      local_docker_compose_service, 
      "env PGPASSWORD='#{local_db_config['password']}' #{util}",
      env: env_vars,
      no_tty: true
    )
    return compose_cmd
  end
  pg_bin_path(util)
end

#pg_path ⇒ Object 



126
127
128
 
# File 'lib/cloner/postgres.rb', line 126

def pg_path
  Rails.root.join("tmp", "dump").to_s
end

#pg_remote_auth ⇒ Object 



12
13
14
15
16
17
18
 
# File 'lib/cloner/postgres.rb', line 12

def pg_remote_auth
  if remote_db_config['password'].blank?
    ""
  else
    "PGPASSWORD='#{remote_db_config['password']}' "
  end
end

#pg_remote_bin_path(util) ⇒ Object 



59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
 
# File 'lib/cloner/postgres.rb', line 59

def pg_remote_bin_path(util)
  if remote_docker_compose? && remote_docker_compose_service
    # Build docker compose exec command for remote
    env_vars = {}
    env_vars['PGPASSWORD'] = remote_db_config['password'] if remote_db_config['password'].present?
    
    compose_cmd = remote_docker_compose_exec(
      remote_docker_compose_service,
      "env PGPASSWORD='#{remote_db_config['password']}' #{util}",
      env: env_vars,
      no_tty: true
    )
    return compose_cmd
  end
  pg_bin_path(util)
end

#pg_restore_param ⇒ Object 



31
32
33
 
# File 'lib/cloner/postgres.rb', line 31

def pg_restore_param
  "--no-owner -Fc -c"
end