Re: pg_dump/pg_dumpall help synopses and terminology

On 10.06.25 13:51, Ashutosh Bapat wrote:
> Since we are using "a PostgreSQL database" and "a PostgreSQL cluster"
> with pg_dump and pg_dumpall respectively, it makes sense to use the same
> wording for pg_restore. Th description at [1] already does that, except
> it needs small tweaks like below:
>
> pg_restore - restore a PostgreSQL database or a PostgreSQL cluster from
> an archive created by
> pg_dump or pg_dumpall respectively.
>
> [1] https://www.postgresql.org/docs/18/app-pgrestore.html <https://
> www.postgresql.org/docs/18/app-pgrestore.html>

I think this is too long and too complex for a synopsis.

I also don't think that the "respectively" aspect is correct like that.
You could use pg_restore to restore less than all of the archive, so you
could restore just one database from an archive created by pg_dumpall.

The proposed phrasing "restore PostgreSQL databases" leaves it open how
many databases you want to restore.

I think the most important thing for the pg_restore synopsis is that it
mentions the relationship with pg_dump and pg_dumpall. Once you see
that, and you have heard about pg_dump/pg_dumpall before, you should be
able to get the overall picture. The rest should go into the description.