|
Home > Archive > PostgreSQL Discussion > September 2005 > Win32 Backup and Restore of large databases.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Win32 Backup and Restore of large databases.
|
|
| Howard Cole 2005-09-21, 7:23 am |
| 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
| |
| Tony Caduto 2005-09-21, 9:24 am |
| 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
| |
| Lincoln Yeoh 2005-09-21, 1:26 pm |
| At 12:24 PM 9/21/2005 +0100, 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?
Max file size depends on file system used.
http://www.microsoft.com/resources/...kc_fil_tdrn.asp
Careful if you are using a network file system (e.g. cifs/smbfs or nfs).
The max would then depend on the protocol, the relevant file systems
involved and other limitations.
Of course you can split the backup file into multiple files on win32.
In fact, some Win32 systems made it a bit too easy to do. Typically your
backup file will be split to multiple files with names like FILEnnnn.CHK
(nnnn being zero padded numbers). You may find the original files split too.
;)
Link.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
| |
| Howard Cole 2005-09-22, 7:23 am |
| Lincoln Yeoh wrote:
> At 12:24 PM 9/21/2005 +0100, Howard Cole wrote:
>
>
> Of course you can split the backup file into multiple files on win32.
I would be very grateful if you could tell me what compression utilities
you used. Perhaps with an example of the command lines used to dump and
restore the
database.
Thanks
Howard Cole.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
|
|
|
|
|