core dump

[John Liu]

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(doc typeid) from document;"

out

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(doc typeid) 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_l istener WHERE substr(relname, 1,%d)='%s'
UNION SELECT '*'::name
pgSELECT relname FROM pg_catalog.pg_c lass 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_c lass c1, pg_catalog.pg_c lass c2,
pg_catalog.pg_i ndex i WHERE c1.oid=i.
indrelid and i.indexrelid=c2 .oid and c2.relname='%s' and
pg_catalog.pg_t able_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
abcdefghijklmno pqrstuvwxyzABCD EFGHIJKLMNOPQRS TUVWXYZ01234567 89_
%.*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

[Jeff]

On Wed, 19 Nov 2003 11:55:46 -0600
"John Liu" <jo***@emrx.com > wrote:

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?

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*******@postg resql.org so that your
message can get through to the mailing list cleanly

[John Liu]

PG was shutdown on both AIXs,
otherwise it may not be able
to start up after the copy.

thanks.
johnl

-----Original Message-----
From: Jeff [mailto:th****** @torgo.978.org]
Sent: Wednesday, November 19, 2003 12:03 PM
To: John Liu
Cc: pg***********@p ostgresql.org
Subject: Re: [GENERAL] core dump
On Wed, 19 Nov 2003 11:55:46 -0600
"John Liu" <jo***@emrx.com > wrote:

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?

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 6: Have you searched our list archives?

http://archives.postgresql.org