核心转储 [英] core dump
问题描述
我有两个问题,它们可能相关也可能不相关 -
1.我复制了整个数据目录[包括
postgresql.conf,base, ...]从postgreSQL 7.3.2(AIX4.3)
到安装postgreSQL 7.3.4(AIX5.1),相同的文件系统
设置。我没有做转储/重装过程
因为复制过程更快。
在postgreSQL中使用这个快捷方式是否可以?任何副作用?
2.复制的数据库包含7.3.4 pgsql和7.3.2数据dir似乎
运行正常。但是,当我运行以下查询时,它会导致核心转储 -
psql -d emrxdbs -At -F''|'' - c" select cdi,doctypeid,
来自document的getdatatype(doctypeid);"
I''ve two questions, they may or may not be related -
1. I copied the entire data directory [including
postgresql.conf, base, ...] from postgreSQL 7.3.2 (AIX4.3)
to the installation postgreSQL 7.3.4 (AIX5.1), the same filesystem
setup. I didn''t do an dump/reload process
since the copy process is faster.
Is it OK to take this shortcut in postgreSQL? any side-effects?
2. The copied database with 7.3.4 pgsql and 7.3.2 data dir seems
running OK. But when I run the following query it causes core dump -
psql -d emrxdbs -At -F ''|'' -c "select cdi, doctypeid,
getdatatype(doctypeid) from document;"
out
但是上面的查询适用于较旧的AIX4.3 postgreSQL7.3.2,以及
如果我运行以下查询它适用于新的AIX5.1 -
psql -d emrxdbs -At -F''|'' - c" select cdi, doctypeid,
来自文档限制10的
getdatatype(doctypeid);" > out
字符串核心表示存在一些内存问题,
但是新的AIX5.1具有比旧的AIX4.3更多的内存 -
....
SELECT relname FROM pg_catalog.pg_listener WHERE substr(relname,1,%d)=''%s''
UNION SELECT ''*'':: name
pgSELECT relname FROM pg_catalog.pg_class WHERE relkind =''r''和
substr(relname,1,%d)=' '%s''和pg_catalog.pg_t
able_is_visible(oid)UNION SELECT''FULL'':: name UNION SELECT''ANALYZE'':: name
格式
Tborder
Wexpanded
VERnull
fieldsep
tuples_only
title
ATtableattr
LLpager
EXrecordsep
IBMout of memory
ISELECT c1.relname FROM pg_catalog.pg_class c1,pg_catalog.pg_class c2,
pg_catalog.pg_index i WHERE c1.oid = i。
indrelid和i.indexrelid = c2。 oid和c2.relname =''%s''和
pg_catalog.pg_table_is_visible(c2.oid)
BINARY
....
IBM \\\
IBM \ s
我写的
我%s限制%d;
内存不足
ION_ERROR_STOP
IBIGNOREEOF
IBQUIET
IB \ q
IUse" \ q"离开%s。
IECHO
IBMall
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWX YZ0123456789_
%。* s%s%s
IBM
IBMSINGLELINE
@(#)61
1.14 src / bos / usr / ccs / lib / libc /__threads_init.c,ibccthrd,bos510 7/11/00
12:04:14
将client_encoding设置为''%s''
xrealloc
xmalloc
%s:虚拟内存耗尽
....
有什么想法吗?
谢谢。
johnl
------------ ---------------(播出结束)---------------------------
提示9:如果您的
加入列的数据类型不匹配,计划员将忽略您选择索引扫描的愿望
but the above query works on the older AIX4.3 postgreSQL7.3.2, and
if I run the following query it works on new AIX5.1 -
psql -d emrxdbs -At -F ''|'' -c "select cdi, doctypeid,
getdatatype(doctypeid) from document limit 10;" >out
strings core indicates some memory issues,
but the new AIX5.1 has far more memory than the old AIX4.3 -
....
SELECT relname FROM pg_catalog.pg_listener WHERE substr(relname,1,%d)=''%s''
UNION SELECT ''*''::name
pgSELECT relname FROM pg_catalog.pg_class WHERE relkind=''r'' and
substr(relname,1,%d)=''%s'' and pg_catalog.pg_t
able_is_visible(oid) UNION SELECT ''FULL''::name UNION SELECT ''ANALYZE''::name
format
Tborder
Wexpanded
VERnull
fieldsep
tuples_only
title
ATtableattr
LLpager
EXrecordsep
IBMout of memory
ISELECT c1.relname FROM pg_catalog.pg_class c1, pg_catalog.pg_class c2,
pg_catalog.pg_index i WHERE c1.oid=i.
indrelid and i.indexrelid=c2.oid and c2.relname=''%s'' and
pg_catalog.pg_table_is_visible(c2.oid)
BINARY
....
IBM\out
IBM\s
I\write
I%s LIMIT %d;
out of memory
ION_ERROR_STOP
IBIGNOREEOF
IBQUIET
IB\q
IUse "\q" to leave %s.
IECHO
IBMall
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWX YZ0123456789_
%.*s%s%s
IBM
IBMSINGLELINE
@(#)61
1.14 src/bos/usr/ccs/lib/libc/__threads_init.c, libcthrd, bos510 7/11/00
12:04:14
set client_encoding to ''%s''
xrealloc
xmalloc
%s: out of virtual memory
....
Any thoughts?
thanks.
johnl
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column''s datatypes do not match
推荐答案
2003年11月19日星期三11:55:46 -0600
" John Liu" <乔*** @ emrx.com>写道:
On Wed, 19 Nov 2003 11:55:46 -0600
"John Liu" <jo***@emrx.com> wrote:
我有两个问题,它们可能相关也可能不相关 -
1.我复制了整个数据目录[包括
postgresql.conf ,base,...]来自postgreSQL 7.3.2(AIX4.3)
到安装postgreSQL 7.3.4(AIX5.1),相同的文件系统
设置。我没有进行转储/重装过程
因为复制过程更快。
在postgreSQL中使用这个快捷方式是否可以?任何副作用?
I''ve two questions, they may or may not be related -
1. I copied the entire data directory [including
postgresql.conf, base, ...] from postgreSQL 7.3.2 (AIX4.3)
to the installation postgreSQL 7.3.4 (AIX5.1), the same filesystem
setup. I didn''t do an dump/reload process
since the copy process is faster.
Is it OK to take this shortcut in postgreSQL? any side-effects?
如果你在PG运行的时候这样做了,你就会有一大堆毫无意义的数据。这样做的唯一两种方法是关闭PG并复制或使用LVM并使用
拍摄快照。
-
Jeff Trout< je ** @ jefftrout.com>
http:// www.jefftrout.com/
http://www.stuarthamm.net /
---------------------------(播出结束) - --------------------------
提示3:如果通过Usenet发布/阅读,请发送适当的
subscribe-nomail命令 ma*******@postgresql.org ,以便你的
消息可以干净利落地到达邮件列表
If you did this while PG was running you have a big pile of meaningless
data. The only two ways to do this are to shut down PG and copy or use
an LVM and take a snapshot.
--
Jeff Trout <je**@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly
PG在两个AIX上关闭,
否则可能无法在复制后启动
。
谢谢。
johnl
PG was shutdown on both AIXs,
otherwise it may not be able
to start up after the copy.
thanks.
johnl
-----原始消息----- 发送时间:2003年11月19日星期三下午12:03
致:John Liu >抄送: pg***********@postgresql.org
2003年11月19日星期三11:55:46 -0600
John Liu <乔*** @ emrx.com>写道:
-----Original Message-----
From: Jeff [mailto:th******@torgo.978.org]
Sent: Wednesday, November 19, 2003 12:03 PM
To: John Liu
Cc: pg***********@postgresql.org
Subject: Re: [GENERAL] core dump
On Wed, 19 Nov 2003 11:55:46 -0600
"John Liu" <jo***@emrx.com> wrote:
我有两个问题,它们可能相关也可能不相关 -
1.我复制了整个数据目录[包括
postgresql.conf ,base,...]来自postgreSQL 7.3.2(AIX4.3)
到安装postgreSQL 7.3.4(AIX5.1),相同的文件系统
设置。我没有进行转储/重装过程
因为复制过程更快。
在postgreSQL中使用这个快捷方式是否可以?任何副作用?
I''ve two questions, they may or may not be related -
1. I copied the entire data directory [including
postgresql.conf, base, ...] from postgreSQL 7.3.2 (AIX4.3)
to the installation postgreSQL 7.3.4 (AIX5.1), the same filesystem
setup. I didn''t do an dump/reload process
since the copy process is faster.
Is it OK to take this shortcut in postgreSQL? any side-effects?
如果你在PG运行时这样做,那么你就会有大量无意义的数据。这样做的唯一两种方法是关闭PG并复制或使用LVM并拍摄快照。
-
Jeff Trout< je ** @ jefftrout .com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
>
---------------------------(广播结束)------------- --------------
提示6:您是否搜索了我们的列表档案?
http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
这篇关于核心转储的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!