Re: Dump database more than 1 flat file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Dec 17, 2007 2:06 PM, A.Burbello <burbello3000@xxxxxxxxxxxx> wrote:
> I consider this way a good practice to transport the
> files. This is because I have table that has more than
> 30GB.
> But if the OS was windows, couldn't split the files
> because postgres doesn't has this feature!
> Could be a good option if postgres had native.
>
> Weel, I will try this:
> eg: $ pg_dump postgres -U postgres -f split.txt |
> split --bytes=10m

http://gnuwin32.sourceforge.net/packages/coreutils.htm

for now.  I used these back in the day (NT4.0 SP4 or so) and they
worked a charm back then.  Heck, even ln worked ( in a manner of
speaking ) back then.

---------------------------(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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux