Not yet!doing a pg_dump right now...also, the OOM occurs in a copy event of a 2gb table.droped work_mem to 2gb and trying again with psql while doing a pg_dumpI just did "psql database < stuff.sql"2016-03-21 17:13 GMT-03:00 Dmitrii Golub <dmitrii.golub@gmail.com>:2016-03-21 23:02 GMT+03:00 Edgar Delgado <edgdelgado@gmail.com>: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 errorshared_buffers = 3840MB effective_cache_size = 11520MB work_mem = 19660kBmaintenance_work_mem = 960MB min_wal_size = 1GB max_wal_size = 2GB checkpoint_completion_target = 0.7wal_buffers = 16MB default_statistics_target = 100Please, tell us how are you doing this exactly.Did you try pg_dump, pg_restore?--Dmitrii Golub
2016-03-21 23:02 GMT+03:00 Edgar Delgado <edgdelgado@gmail.com>: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 errorshared_buffers = 3840MB effective_cache_size = 11520MB work_mem = 19660kBmaintenance_work_mem = 960MB min_wal_size = 1GB max_wal_size = 2GB checkpoint_completion_target = 0.7wal_buffers = 16MB default_statistics_target = 100Please, tell us how are you doing this exactly.Did you try pg_dump, pg_restore?--Dmitrii Golub
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 errorshared_buffers = 3840MB effective_cache_size = 11520MB work_mem = 19660kBmaintenance_work_mem = 960MB min_wal_size = 1GB max_wal_size = 2GB checkpoint_completion_target = 0.7wal_buffers = 16MB default_statistics_target = 100
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных
