Your name : Krok Your email address : [EMAIL PROTECTED]
System Configuration --------------------- Architecture : Dual PIII-500 Operating System : FreeBSD 4.7-RELEASE-p7 PostgreSQL version : PostgreSQL-7.3.2 Compiler used : gcc 2.95.4 Please enter a FULL description of your problem: ------------------------------------------------ When restoring large database (there are several tables with >1'000'000 rows and somthing about 50 tables with 1'000-10'000 rows) using cat <dump_file> | psql -U psql, backend crashes and there are messages in logs : Mar 25 15:14:08 frost postgres[338]: [14] LOG: server process (pid 64665) was terminated by signal 11 Mar 25 15:14:08 frost postgres[338]: [15] LOG: terminating any other active server processes Mar 25 15:14:08 frost postgres[338]: [16] LOG: all server processes terminated; reinitializing shared memory and semaphores Mar 25 15:14:08 frost postgres[64921]: [17] LOG: database system was interrupted at 2003-03-25 15:13:01 MSK Mar 25 15:14:08 frost postgres[64921]: [18] LOG: checkpoint record is at 11/451E6D80 Mar 25 15:14:08 frost postgres[64921]: [19] LOG: redo record is at 11/450304A0; undo record is at 0/0; shutdown FALSE Mar 25 15:14:08 frost postgres[64921]: [20] LOG: next transaction id: 94286227; next oid: 2959327 Mar 25 15:14:08 frost postgres[64921]: [21] LOG: database system was not properly shut down; automatic recovery in progress Mar 25 15:14:08 frost postgres[64921]: [22] LOG: redo starts at 11/450304A0 Mar 25 15:14:10 frost postgres[64921]: [23] LOG: ReadRecord: record with zero length at 11/4585EB20 Mar 25 15:14:10 frost postgres[64921]: [24] LOG: redo done at 11/4585EAFC Mar 25 15:14:15 frost postgres[64921]: [25] LOG: recycled transaction log file 0000001100000044 Mar 25 15:14:15 frost postgres[64921]: [26] LOG: database system is ready My configuration is : ------ max_connections = 256 superuser_reserved_connections = 2 shared_buffers = 4096 # 2*max_connections, min 16, typically 8KB each max_fsm_relations = 100 # min 10, fsm is free space map, ~40 bytes max_fsm_pages = 10000 # min 1000, fsm is free space map, ~6 bytes max_locks_per_transaction = 64 # min 10 wal_buffers = 128 # min 4, typically 8KB each sort_mem = 8192 # min 64, size in KB vacuum_mem = 65536 # min 1024, size in KB checkpoint_segments = 1 # in logfile segments, min 1, 16MB each checkpoint_timeout = 3600 # range 30-3600, in seconds commit_delay = 1000 # range 0-100000, in microseconds commit_siblings = 5 # range 1-1000 wal_debug = 0 effective_cache_size = 16384 show_parser_stats = false show_planner_stats = false show_executor_stats = false show_statement_stats = false stats_start_collector = true stats_reset_on_server_start = true stats_command_string = true stats_row_level = true stats_block_level = true ------ Dual PIII-500, 782MB, SCSI Thanks. With best regards, Krok. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
