Andrus writes:
> 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.
Are you certain that the pg_dump you're using is v15, and not something
pre-v14? We got rid of the 4GB limi
> On 08/02/2023 22:37 CET Andrus wrote:
>
> > > How to create backup in format from which tables can selectively
> > > restored?
> > >
> > Dump as custom-format archive (-F custom) and use that with pg_restore
> > and options --table or --list/--use-list to select what should be
> > restored.
> >
Hi!
How to create backup in format from which tables can selectively restored?
Dump as custom-format archive (-F custom) and use that with pg_restore and
options --table or --list/--use-list to select what should be restored.
How to select tables interactively like pgAdmin allows to select w
> On 08/02/2023 21:59 CET Andrus wrote:
>
> How to create backup in format from which tables can selectively restored?
Dump as custom-format archive (-F custom) and use that with pg_restore and
options --table or --list/--use-list to select what should be restored.
--
Erik
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 siz
On Wed, Feb 08, 2023 at 05:00:10PM +0200, Andrus wrote:
> Hi!
>
> Creating backup in directory format using
>
> pg_dump -f "sba" -Fdirectory --jobs=32 --verbose sba
>
> throws error
>
> pg_dump: error: could not stat file "sba/282168.data.gz": value too
> large
>
> How to fix it ?
>
>
Hi!
Creating backup in directory format using
pg_dump -f "sba" -Fdirectory --jobs=32 --verbose sba
throws error
pg_dump: error: could not stat file "sba/282168.data.gz": value too
large
How to fix it ?
Server is Postgres 12 running in Debian Linux 10 under WSL
Client is pg_dump fro
