| From: | "John Liu" <johnl(at)emrx(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | core dump |
| Date: | 2003-11-19 17:55:46 |
| Message-ID: | NDBBKKKHILOHGHNKGOCEMELAGGAA.johnl@emrx.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
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
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789_
%.*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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2003-11-19 17:59:04 | Re: 7.4 broke psql |
| Previous Message | Peter Eisentraut | 2003-11-19 17:49:29 | Re: SuSE RPMs available for PostgreSQL 7.4 |