downgrade pendulum to released version

[meeuw]

Description

"Unbump" pendulum to released version (3.0.0b1 is a beta version)

requiring 3.0.0b1 gives problems for packing pgcli for Fedora.

Checklist

• [x] I've added this contribution to the changelog.rst.
• [x] I've added my name to the AUTHORS file (or it's already there).
• [x] I installed pre-commit hooks (pip install pre-commit && pre-commit install), and ran black on my code.
• [x] Please squash merge this pull request (uncheck if you'd like us to merge as multiple commits)

[meeuw]

Related to #1426

[codecov-commenter]

Codecov Report

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

Comparison is base (8c72820) 79.63% compared to head (c7ce8d5) 79.63%.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #1434 +/- ## ======================================= Coverage 79.63% 79.63% ======================================= Files 25 25 Lines 3035 3035 ======================================= Hits 2417 2417 Misses 618 618 ``` [see 1 file with indirect coverage changes](https://app.codecov.io/gh/dbcli/pgcli/pull/1434/indirect-changes?src=pr&el=tree-more&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=dbcli)

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

[meeuw]

We might advice Python 3.12 users to install pgcli using pip --pre, to allow usage of beta versions?

[j-bennet]

Thank you @meeuw .