On 5/23/22 13:47, Adrian Klaver wrote:
On 5/23/22 12:26, Rob Sargent wrote:
As to older version, how are you installing Postgres?
Much appreciated,
rjs
Yeah, that’s part of the problem. /I’m/ not installing postgres,
another group has that control. I can get the answer for version 1
On 5/23/22 12:26, Rob Sargent wrote:
As to older version, how are you installing Postgres?
Much appreciated,
rjs
Yeah, that’s part of the problem. /I’m/ not installing postgres, another
group has that control. I can get the answer for version 14 but maybe
not for version 10. Curren
> On May 23, 2022, at 12:59 PM, Adrian Klaver wrote:
>
> On 5/23/22 11:31, Rob Sargent wrote:
>> On 5/23/22 12:15, Tom Lane wrote:
>
>>>
>>> pg_restore -f - db.dump | head
>>>
>>> which should provide some comments telling you the originating
>>> server version and pg_dump version.
>>>
>>>
On 5/23/22 11:31, Rob Sargent wrote:
On 5/23/22 12:15, Tom Lane wrote:
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 out
On 5/23/22 12:15, Tom Lane wrote:
Rob Sargent 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
Rob Sargent 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 serve
On 5/23/22 11:04 AM, Rob Sargent wrote:
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
The
pg_restore -l
command will show the relevant information at top of file so
On 5/23/22 11:51, Adrian Klaver wrote:
On 5/23/22 10:19 AM, Rob Sargent wrote:
On 5/23/22 11:07, Adrian Klaver wrote:
On 5/23/22 10:01 AM, Rob Sargent wrote:
On 5/23/22 11:00, Adrian Klaver wrote:
On 5/23/22 9:54 AM, Rob Sargent wrote:
On 5/23/22 10:50, Adrian Klaver wrote:
This is gre
On 5/23/22 10:19 AM, Rob Sargent wrote:
On 5/23/22 11:07, Adrian Klaver wrote:
On 5/23/22 10:01 AM, Rob Sargent wrote:
On 5/23/22 11:00, Adrian Klaver wrote:
On 5/23/22 9:54 AM, Rob Sargent wrote:
On 5/23/22 10:50, Adrian Klaver wrote:
This is great news. I do have pg14. I thought you
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 l
Adrian Klaver writes:
> On 5/23/22 9:54 AM, Rob Sargent wrote:
>> Roger that, but does the dump of a database name the tablespaces from
>> which the objects were retrieved? And if so, is that accessible?
> Would indicate it does. I don't have cluster set up with tablespaces to
> test, but I wou
On 5/23/22 11:07, Adrian Klaver wrote:
On 5/23/22 10:01 AM, Rob Sargent wrote:
On 5/23/22 11:00, Adrian Klaver wrote:
On 5/23/22 9:54 AM, Rob Sargent wrote:
On 5/23/22 10:50, Adrian Klaver wrote:
Roger that, but does the dump of a database name the tablespaces
from which the objects were re
On 5/23/22 10:01 AM, Rob Sargent wrote:
On 5/23/22 11:00, Adrian Klaver wrote:
On 5/23/22 9:54 AM, Rob Sargent wrote:
On 5/23/22 10:50, Adrian Klaver wrote:
Roger that, but does the dump of a database name the tablespaces from
which the objects were retrieved? And if so, is that accessible?
On 5/23/22 11:00, Adrian Klaver wrote:
On 5/23/22 9:54 AM, Rob Sargent wrote:
On 5/23/22 10:50, Adrian Klaver wrote:
Roger that, but does the dump of a database name the tablespaces from
which the objects were retrieved? And if so, is that accessible?
https://www.postgresql.org/docs/14/a
On 5/23/22 9:54 AM, Rob Sargent wrote:
On 5/23/22 10:50, Adrian Klaver wrote:
Roger that, but does the dump of a database name the tablespaces from
which the objects were retrieved? And if so, is that accessible?
https://www.postgresql.org/docs/14/app-pgrestore.html
"--no-tablespaces
On 5/23/22 10:50, Adrian Klaver wrote:
On 5/23/22 9:45 AM, Rob Sargent wrote:
Using pg 14, is it easy (possible) to list the tablespaces used in a
custom format dump. Are the definitions included?
https://www.postgresql.org/docs/14/app-pgdump.html
"pg_dump only dumps a single database. To b
On 5/23/22 9:45 AM, Rob Sargent wrote:
Using pg 14, is it easy (possible) to list the tablespaces used in a
custom format dump. Are the definitions included?
https://www.postgresql.org/docs/14/app-pgdump.html
"pg_dump only dumps a single database. To back up an entire cluster, or
to back up
Using pg 14, is it easy (possible) to list the tablespaces used in a
custom format dump. Are the definitions included?
Thanks,
18 matches
Mail list logo
