Hi all. I have a database with very large tables - about 2+ GB per table. When I'm using pg_dump tool, it get all memory available, then linux crash (or kernel kills the most of processes including pg_dump) For this reason I made small php script which dump data using 'fetch next in cursor' (PHP is lame for this but is perfect for me). I tried to patch pg_dump, but I cant understand most of the code (never works with pg blobs from C). I'm attaching the files I use in order to share them with all you. Nikolay. P.s. Shell scripts are for calling the php scripts. dump1.sh - create list with shell commands needs to be executed in order to get backup. dump.sh - backup single table ----------------------------------------------------------- The Reboots are for hardware upgrades, Found more here: http://www.nmmm.nu Nikolay Mihaylov [EMAIL PROTECTED]
pgdump-nmmm.tar
Description: Unix tar archive
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
