Fix for compatibility with pyuvdata v3.0

[bhazelton]

Description

Fix for some imports that will be changing in pyuvdata v3.0

Also switch from psycopg2 to psycopg3 (package is actually called psycopg) for numpy 2.0 compatibility.

Drop testing against python 3.8 & 3.9, add testing against 3.11 & 3.12

Motivation and Context

Types of changes

• [ ] Bug fix (non-breaking change which fixes an issue)
• [ ] Schema change (any change to the SQL tables)
• [ ] New feature without schema change (non-breaking change which adds functionality)
• [ ] Change associated with a change in redis structure
• [ ] Breaking change (fix or feature that would cause existing functionality to change)
• [ ] Version change
• [ ] Build or continuous integration change
• [x] Other

Checklist:

Other:

• [x] My code follows the code style of this project.
• [x] I understand the updates required onsite (detailed in the readme) and I will make those changes when this is merged.
• [ ] Unit tests pass on site (This is a critical check, CI can differ from site).
• [ ] I have updated the CHANGELOG.

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 98.28%. Comparing base (056628a) to head (7466b0a).

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #669 +/- ## ========================================== + Coverage 98.26% 98.28% +0.02% ========================================== Files 34 34 Lines 5304 5308 +4 ========================================== + Hits 5212 5217 +5 + Misses 92 91 -1 ``` | [Flag](https://app.codecov.io/gh/HERA-Team/hera_mc/pull/669/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=HERA-Team) | Coverage Δ | | |---|---|---| | [](https://app.codecov.io/gh/HERA-Team/hera_mc/pull/669/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=HERA-Team) | `98.28% <100.00%> (?)` | | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=HERA-Team#carryforward-flags-in-the-pull-request-comment) to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.