Re: Win32 Backup and Restore of large databases. - Mailing list pgsql-general

From Tony Caduto
Subject Re: Win32 Backup and Restore of large databases.
Date
Msg-id 4331597D.3020903@amsoftwaredesign.com
Whole thread Raw
In response to Win32 Backup and Restore of large databases.  (Howard Cole <howardnews@selestial.com>)
List pgsql-general
Howard Cole wrote:

> On a Win32 machine, can I backup a database if the backup file exceeds
> 2GB? In linux, I can split the backup file into multiple files. Can
> this be done on Win32?
>
> Regards
>
> Howard Cole
> www.selestial.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

I am not sure, but I thought the max file size on NT and up systems was
4gb, not 2gb.  Also newer versions of Linux should not have the 2gb
limitation.(that was a limit imposed on the 2.x kernel)
This of course does not mean that the Postgresql code was ever updated
to allow larger files.
--

Tony Caduto
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql 8.x


pgsql-general by date:

Previous
From: Howard Cole
Date:
Subject: Win32 Backup and Restore of large databases.
Next
From: "Alex R. Mosteo"
Date:
Subject: Problem with libpq3 & postgresql8