Re: How to create directory format backup

From: Andrus <kobruleht2(at)hot(dot)ee>
To: depesz(at)depesz(dot)com
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to create directory format backup
Date: 2023-02-08 20:59:43
Message-ID: 6da54c55-6752-ca53-cdc8-2342b2c75258@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Siddharth Jain 2023-02-08 21:17:23 Re: How to use the BRIN index properly?
Previous Message Miles Elam 2023-02-08 20:27:39 Re: Sequence vs UUID