| From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: list tablespaces named in custom format dump |
| Date: | 2022-05-23 17:48:38 |
| Message-ID: | 3e425950-e969-bd6a-20f7-7541358b5afd@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 5/23/22 11:29, Tom Lane wrote:
>
> AFAICS, the output produced by -l doesn't mention objects' tablespaces.
> You could see them by extracting the plain text archive and grepping
> for object comments that include a tablespace name:
>
> pg_restore -s -f - archive_file | grep Tablespace:
>
> It looks to me like that will only appear for tables with non-default
> tablespaces.
>
> regards, tom lane
That worked, thank you. I see it has only the "name" so I presume
location can be redefined in the receiving cluster.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2022-05-23 17:51:25 | Re: list tablespaces named in custom format dump |
| Previous Message | Adrian Klaver | 2022-05-23 17:41:56 | Re: Can I start Update row in After Insert trigger function? |