- Import and query the Pagila sample database:
psql postgres -c "CREATE DATABASE pagila;" psql pagila < pagila-schema.sql psql pagila < pagila-data.sql psql pagila -c "SELECT title, description FROM film WHERE fulltext @@ to_tsquery('saga&india');"
- Connect to database using LibreOffice Base.
- Connect to database using Psycopg2.
The manual upgrade process mentioned is different compared to other distros because we don't have different packages for different Postgres versions.
Shall I write some instructions for the Help Center?
I suggest two minor things in the package.yml file: replace python3-devel with pkgconfig(python3) and move patterns: before builddeps:. If you want to add the homepage: too, then it is this: https://www.postgresql.org/
LGTM. In terms of a migration guide, it would be ideal if one could be submitted, but we would still need to give folks an adequate heads up, likely via a section in a "The Roundup" blog post. So I'm gonna hold off landing this until that point (and until a help center doc is submitted).