Re: How to create directory format backup - Mailing list pgsql-general

From Andrus
Subject Re: How to create directory format backup
Date
Msg-id 6da54c55-6752-ca53-cdc8-2342b2c75258@hot.ee
Whole thread Raw
In response to Re: How to create directory format backup  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: How to create directory format backup  (Erik Wienhold <ewie@ewie.name>)
Re: How to create directory format backup  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi!

>Looks like your filesystem on client is having limits on file sizes. Use better filesystem, or just dump on linux, it's filesystems usually don't hit these limits.

This file size is only 6.2 GB. If custom format is used, pg_dump creates large file without problems. There are no file size limits. Error message is not about this.

Backup client is running in Windows 11 and this cannot changed.

How to create backup in format from which tables can selectively restored?

Posted also in https://stackoverflow.com/questions/75387616/how-to-make-directory-format-backup

Andrus.

pgsql-general by date:

Previous
From: Miles Elam
Date:
Subject: Re: Sequence vs UUID
Next
From: Siddharth Jain
Date:
Subject: Re: How to use the BRIN index properly?