Re: list tablespaces named in custom format dump

[Rob Sargent <robjsargent@xxxxxxxxx>]

On 5/23/22 12:15, Tom Lane wrote:

> Rob Sargent <robjsargent@xxxxxxxxx> writes:
> > Thanks Adrian.  There's enough wiggle room in there for me to at least 
> > try the restore. Linus file command tells me
> >       
> >     db.dump: PostgreSQL custom database dump - v1.13-0
> >       
> > That dump was from a version 10 server.  Any guess at how that "v1.13-0" 
> > relates to the server version?
> >       
> It doesn't, it's just a more-or-less-magic identifier for the dump
> file's format version, with no connection to any user-visible
> release number.  What you should try is
>
> pg_restore -f - db.dump | head
>
> which should provide some comments telling you the originating
> server version and pg_dump version.
>
> 			regards, tom lane
>     
    
    OK, back to reality:
      version 10 dump.  
      
      The output of from head command is very different that Adrian
      shows but I'm still left giving pg_restore(14) a shot.  Getting
      older server will be challenging.
      
      Much appreciated,
      rjs