Out of memory psql import!

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

 



Hi,

Im trying to import a  9.4 database to a 9.5.1 system with psql but after few minutes I get OOM error...

Have 15gb ram.

Tried pgtune conf and still get error


shared_buffers = 3840MB 
effective_cache_size = 11520MB 
work_mem = 19660kB
maintenance_work_mem = 960MB 
min_wal_size = 1GB 
max_wal_size = 2GB 
checkpoint_completion_target = 0.7
wal_buffers = 16MB 
default_statistics_target = 100




[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