pgdiff
pgdiff copied to clipboard
joncrlsn
Compares the PostgreSQL schema between two databases and generates SQL statements that can be run manually against the second database to make their schemas match.
I was thinking about using `pgdiff` as part of my deployment and migration pipeline. The pipeline is already written in go and I was curious if there would be any...
I have 2 DB, reference DB have 10 tables, target one have 9. Original columns order of **books_lost** table: ``` CREATE TABLE books_lost ( id integer NOT NULL, title text...
Hi, im writing correct host password dbname etc in pipeline like this: ./pgdiff -U postgres -W password-H localhost -P 5432 -D db1-O 'sslmode=disable' -u postgres -w password-h localhost -p 5432...
Hi, previously I've been running pgdiff on Postgresql 8 but now we already migrate to Postgresql 13 and soon will be Postgresql 14. However when I try to perform pgdiff,...
In Postgres you can have the same Function with multiple different input Parameters. Example myFunction(id) and myFunction(id,date) In this case those functions always shown as different as you just care...
An error occurred while executing pgdiff on macOS 11.4: ``` ./pgdiff zsh: bad CPU type in executable: ./pgdiff ```
It would be useful to also find differences between defined ENUM types. I was running `pgdiff` between two databases to find differences with `ALL` and this is something that was...
I'm hitting this error as well. Just pulled down the Macos binary, pgdiff-osx-1.0b1.tar And updated the shell script, and launched. + ./pgdiff -H localhost -P 5432 -D campus_hbm -h localhost...
Hello My Friend, I'm trying to test the pgdiff solution on a linux machine, but I'm receiving the following error: 2016/08/19 12:11:24 Error running querypq: SSL is not enabled on...
Currently pgdiff outputs wrong migration for exclusion indexes, as it does not detect it's a special case. This is a generalization of unique constraint, a bit more info here --...
