testdrive: use a useful Postgres default image

[maddyblue]

mzcompose's default Postgres image uses postgres 10 due to some mzbuild stuff that seems unused now. Remove the mzbuild stuff for Postgres and just make it always use a recent version.

Motivation

• This PR fixes a previously unreported bug.

Checklist

• [ ] This PR has adequate test coverage / QA involvement has been duly considered.

• [ ] This PR evolves an existing $T ⇔ Proto$T mapping (possibly in a backwards-incompatible way) and therefore is tagged with a T-protobuf label.

• [ ] This PR includes the following user-facing behavior changes:

  • n/a

[maddyblue]

SET WITH OIDS has apparently gone away, and I'm not sure what it was trying to do or how I should fix it:

As oid system columns cannot be added anymore, this never has an effect.

https://www.postgresql.org/docs/14/sql-altertable.html

[maddyblue]

Hard coding an older postgres for pg-cdc which seems to have needed it until someone else can look at the specifics.

[maddyblue]

That fixed a few errors. Not sure about the conflict_schema stuff. Might look more later.

[philip-stoev]

If we are no longer using mzbuild with Postgres we should also remove misc/images/psql to avoid any confusion.

[CLAassistant]

Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.
_{You have signed the CLA already but the status is still pending? Let us recheck it.}

[CLAassistant]

Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.
_{You have signed the CLA already but the status is still pending? Let us recheck it.}