X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 3AF469FB35E for ; Wed, 30 Aug 2006 19:06:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 27314-09 for ; Wed, 30 Aug 2006 22:06:16 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.235]) by postgresql.org (Postfix) with ESMTP id 7E4879FB35F for ; Wed, 30 Aug 2006 19:06:13 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so377515wxc for ; Wed, 30 Aug 2006 15:06:12 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:mime-version:content-transfer-encoding:message-id:content-type:to:from:subject:date:x-mailer; b=rCAqtzLM4G+v1xPIGqNaw2/OPtTCbyFKQY2EAwnG2rLYKrH51Hiw/jxitWvuhlFuzqDo+x7htX1hHBkiuN0Evt1amxrLWv6XB0uS/djkMkVd/6JanmUVAHQkMfMGHhq/ckqfL7/9znQ1df1fiZWzM3MqMuDcnL5fxf8Q1Tq9hzc= Received: by 10.70.65.5 with SMTP id n5mr277935wxa; Wed, 30 Aug 2006 15:06:11 -0700 (PDT) Received: from ?192.168.254.27? ( [69.22.232.120]) by mx.gmail.com with ESMTP id i16sm73308wxd.2006.08.30.15.06.11; Wed, 30 Aug 2006 15:06:11 -0700 (PDT) Mime-Version: 1.0 (Apple Message framework v752.2) Content-Transfer-Encoding: 7bit Message-Id: <4F5A86C9-AF3C-492F-8C38-33BB406FE961@gmail.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: pgsql-admin@postgresql.org From: Julian Tree Subject: Postgresql 8.1.4 on FreeBSD6.1 core dump when pg_dump Date: Wed, 30 Aug 2006 18:06:05 -0400 X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.757 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, RCVD_IN_BL_SPAMCOP_NET, SPF_PASS X-Spam-Level: * X-Archive-Number: 200608/335 X-Sequence-Number: 22878 Brand new system. Just imported the database. Getting core dump when doing the following - select on certain table, -pg_dump. - VACUUM ANALYZE VERBOSE (byt vacumm is fine) - database is unstable, when connecting from php, it will unexpectedly quite.. Following is the error log, any insight appricated, I would at least like to pg_dump my data out of that trap. Would also greatly appricate if someone can tellme what's wrong? Should I not use postgresql 8.1.4, or should I not use it on FreeBSD? Aug 30 17:55:53 brian upsd[555]: frequency: 60.00, maxvac: 118.0, minvac: 117.3, voltage: 118.0 Aug 30 17:55:53 brian upsd[555]: load: 54.6, recharge: 100.0, temp: 0.0, vdc: 13.69, output voltage: 118.0 Aug 30 17:56:05 brian kernel: pid 1632 (postgres), uid 70: exited on signal 11 (core dumped) Aug 30 17:56:05 brian postgres[1634]: [7-1] FATAL: the database system is starting up