Re: Win32 Backup and Restore of large databases.

From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
To: Howard Cole <howardnews(at)selestial(dot)com>
Cc: "'PgSql General'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Win32 Backup and Restore of large databases.
Date: 2005-09-21 13:00:45
Message-ID: 4331597D.3020903@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2005-09-21 13:18:33 Re: Problem with libpq3 & postgresql8
Previous Message Alex R. Mosteo 2005-09-21 12:36:17 Problem with libpq3 & postgresql8