[EMAIL PROTECTED] (S. Hawkins) writes: > * We're running Postgres 7.2.3 on a more-or-less stock Red Hat 7.3 > platform.
Both the database and the platform are seriously obsolete :-( > The particular file I'm wrestling with at the moment is ~2.2 Gig > unzipped. If you try to restore using pg_restore, the process > immediately fails with the following: > pg_restore: [archiver] could not open input file: File too large It appears that you're working with a pg_restore binary that doesn't support access to files larger than 2G. This is mostly an issue of what the platform's libc can handle; and on many platforms it depends on build or link options. I no longer recall whether RH 7.3 supported largefile access at all, let alone what build-time pushups were needed to make it happen if it could happen. My recommendation would be to get hold of a current PG version, dump using the current version's pg_dump, then install and reload into the current version. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster