pgrepup
pgrepup copied to clipboard
rtshome
Pgrepup is a tool for upgrading through PostgreSQL major versions using logical replication and pglogical extension
I'm not python programmer and i think that my fix is very strange. But it works. ``` $ pgrepup setup Pgrepup 0.3.10 Traceback (most recent call last): File "/usr/local/bin/pgrepup", line...
Is it possible to skip pgl_ddl_deploy usage in this case?
If db name contains "-", we get an error To fix this, edit `vim pgrepup/lib/python2.7/site-packages/pgrepup/helpers/replication.py` find `c.execute('GRANT CREATE ON DATABASE ' + db + ' TO ' + user)` and...
Parameters doesn't get mapped if string is splitted with +
``` pgsql-proxy: ++ pgrepup -c /etc/pgrepup/pgrepup_pgsql1.conf stop pgsql-proxy: Pgrepup 0.3.10 pgsql-proxy: Traceback (most recent call last): pgsql-proxy: File "/usr/local/bin/pgrepup", line 25, in pgsql-proxy: pgsql-proxy: main() pgsql-proxy: File "/usr/local/lib/python2.7/dist-packages/pgrepup/cli.py", line 64,...
Hi again. I have successfully started replication from pg 9.5.6 to pg 9.6.2 but: In `pgrepup config` step, i've chosen only one DB to replicate. `cat .pgrepup` ``` [Security] encrypted_credentials...
I had no primary key on some tables. So `pgrepup fix` fixed it by adding another column with `__pgrepup_id__` or some similar name. Thats really a not very good idea...