-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > We have 2 databases test and prod. Now they are out of sync ( of > course they will be to some extent ). But there are some functions in some > schemas. we have to sync from prod to test. What I wanted to ask, is there > any tool that you recommend for version control. Because we are having tough > time tracking the changes Create a git repo, and enforce that all DDL changes must be made by using checked-in text files containing the changes. Each file should state at the top of it when it was applied to each box. As an aside, if you are syncing *from* prod to test, your process is badly broken. :) - -- Greg Sabino Mullane greg@xxxxxxxxxxxx PGP Key: 0x14964AC8 201001040747 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAktB46wACgkQvJuQZxSWSsgWNQCfR8BX5tJg3Uc/R8DdPYOUg4cT x/UAoNsu60955j7coU/6vw+r0XZ9F28k =STQi -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general