The following bug has been logged online: Bug reference: 4095 Logged by: Pavel Zaitsev Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Windows 2003 Server SP1 Description: Out of memory when restore db Details:
I made the backup of database named avtopzipbuh: pg_dump -f%DRIVETO%\Backup\%DIRNAME%\%FILENAME% -Upostgres avtozipbuh then, I tried to restore it: psql -davtozipbuh -Upostgres -fF:\Backup\avtozipbuh -oF:\Backup\logrestore.txt but I had an error "psql:F:/Backup/avtozipbuh:214116: ERROR: out of memory DETAIL: Failed on request of size 536870912. CONTEXT: COPY config, line 6800" here is the log: TopMemoryContext: 49152 total in 5 blocks; 9504 free (22 chunks); 39648 used TopTransactionContext: 8192 total in 1 blocks; 7336 free (0 chunks); 856 used CFuncHash: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used Rendezvous variable hash: 8192 total in 1 blocks; 3848 free (0 chunks); 4344 used PLpgSQL function cache: 8192 total in 1 blocks; 5904 free (0 chunks); 2288 used MessageContext: 8192 total in 1 blocks; 6952 free (1 chunks); 1240 used Operator class cache: 8192 total in 1 blocks; 4872 free (0 chunks); 3320 used smgr relation table: 24576 total in 2 blocks; 6792 free (4 chunks); 17784 used TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks); 16 used Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used PortalMemory: 8192 total in 1 blocks; 8040 free (0 chunks); 152 used PortalHeapMemory: 536976464 total in 8 blocks; 30496 free (24 chunks); 536945968 used ExecutorState: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used ExprContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used Relcache by OID: 57344 total in 3 blocks; 30680 free (4 chunks); 26664 used CacheMemoryContext: 4329016 total in 22 blocks; 673640 free (8 chunks); 3655376 used pg_toast_1406616_index: 1024 total in 1 blocks; 288 free (0 chunks); 736 used pg_class_relname_nsp_index: 1024 total in 1 blocks; 288 free (0 chunks); 736 used pg_index_indrelid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used pg_attribute_relid_attnam_index: 1024 total in 1 blocks; 288 free (0 chunks); 736 used pg_type_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used pg_cast_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used pg_shdepend_depender_index: 1024 total in 1 blocks; 216 free (0 chunks); 808 used pg_shdepend_reference_index: 1024 total in 1 blocks; 288 free (0 chunks); 736 used pg_depend_depender_index: 1024 total in 1 blocks; 216 free (0 chunks); 808 used pg_depend_reference_index: 1024 total in 1 blocks; 216 free (0 chunks); 808 used pg_description_o_c_o_index: 1024 total in 1 blocks; 216 free (0 chunks); 808 used pg_type_typname_nsp_index: 1024 total in 1 blocks; 288 free (0 chunks); 736 used pg_statistic_relid_att_index: 1024 total in 1 blocks; 328 free (0 chunks); 696 used pg_proc_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used pg_proc_proname_args_nsp_index: 1024 total in 1 blocks; 216 free (0 chunks); 808 used pg_operator_oprname_l_r_n_index: 1024 total in 1 blocks; 152 free (0 chunks); 872 used pg_namespace_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used pg_namespace_nspname_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used pg_language_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used pg_language_name_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used pg_inherits_relid_seqno_index: 1024 total in 1 blocks; 328 free (0 chunks); 696 used pg_database_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used pg_conversion_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used pg_conversion_name_nsp_index: 1024 total in 1 blocks; 328 free (0 chunks); 696 used pg_conversion_default_index: 1024 total in 1 blocks; 192 free (0 chunks); 832 used pg_opclass_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used pg_opclass_am_name_nsp_index: 1024 total in 1 blocks; 216 free (0 chunks); 808 used pg_cast_source_target_index: 1024 total in 1 blocks; 288 free (0 chunks); 736 used pg_authid_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used pg_authid_rolname_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used pg_auth_members_role_member_index: 1024 total in 1 blocks; 328 free (0 chunks); 696 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 328 free (0 chunks); 696 used pg_amop_opr_opc_index: 1024 total in 1 blocks; 288 free (0 chunks); 736 used pg_aggregate_fnoid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 288 free (0 chunks); 736 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 328 free (0 chunks); 696 used pg_operator_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used pg_amproc_opc_proc_index: 1024 total in 1 blocks; 216 free (0 chunks); 808 used pg_amop_opc_strat_index: 1024 total in 1 blocks; 216 free (0 chunks); 808 used pg_index_indexrelid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used pg_attribute_relid_attnum_index: 1024 total in 1 blocks; 288 free (0 chunks); 736 used pg_class_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used MdSmgr: 24576 total in 2 blocks; 13936 free (1 chunks); 10640 used LOCALLOCK hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used Timezones: 49432 total in 2 blocks; 5968 free (0 chunks); 43464 used ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used 2008-04-05 20:28:16 ERROR: 53200: out of memory 2008-04-05 20:28:16 DETAIL: Failed on request of size 536870912. 2008-04-05 20:28:16 CONTEXT: COPY config, line 6800 2008-04-05 20:28:16 LOCATION: AllocSetRealloc, aset.c:907 2008-04-05 20:28:16 STATEMENT: COPY config (filename, creation, modified, attributes, datasize, binarydata) FROM stdin; =============== some parameters of my postgresql.conf shared_buffers = 256MB work_mem = 128MB maintenance_work_mem = 16MB (tried change to 700Mb, no effect) my system have 4Gb RAM, size of db approx 700mb. I have another db on this system, its size 15Gb and I have no problem with it (dump\restore - ok) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
