restoring a single database from a pg_dumpall dump file

Matthias Apitz <guru@unixarea.de> writes:

We're using pg_dumpall (from 14.1) to dump older clusters and
restore them into a new 14.1 cluster. The dump contains some databases
together with roles etc.

Is there some easy way to restore only one database out of this dump
file?

No; pg_dumpall's output is just a flat SQL script.

You might consider using "pg_dumpall -g" to get just the roles
(and tablespaces if any), and then dumping desired databases
individually with pg_dump.

If all you have is a previously-made dumpall script, you'd
have to slice it up with an editor.

regards, tom lane