FAQ
Here's what happens when completely redone without any thread nonsense,
and lower optimization:

/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory /usr/local/pgsql/data ... ok
creating directory /usr/local/pgsql/data/global ... ok
creating directory /usr/local/pgsql/data/pg_xlog ... ok
creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
creating directory /usr/local/pgsql/data/pg_clog ... ok
creating directory /usr/local/pgsql/data/pg_subtrans ... ok
creating directory /usr/local/pgsql/data/base ... ok
creating directory /usr/local/pgsql/data/base/1 ... ok
creating directory /usr/local/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1000
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... ok
initializing pg_shadow ... ok
enabling unlimited row size for system tables ... ok
initializing pg_depend ... FATAL: unrecognized node type: 650
child process exited with exit code 1
initdb: removing contents of data directory "/usr/local/pgsql/data"
-----Original Message-----
From: Mohan, Ross
Sent: Saturday, June 04, 2005 12:15 AM
To: 'Simon Riggs'
Cc: 'psql-ports@postgresql.org'
Subject: Problem with INITDB and "unrecognized node type: 650"

Simon,

Sorry to ping you directly, but your recent conversation with Tom Lane
on a very similar issue in RelOptInfo leads me to believe you'll be
able to suss this out immediately.



Background:

1) Building PG8.0.2 on AIX5.3/64bit.
2) Configure/Make/Build all complete OK.
3) I attempt to initdb and:

##################################################################################################
postgres@ [/home/app/postgresql-8.0.2] /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory /usr/local/pgsql/data ... ok
creating directory /usr/local/pgsql/data/global ... ok
creating directory /usr/local/pgsql/data/pg_xlog ... ok
creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
creating directory /usr/local/pgsql/data/pg_clog ... ok
creating directory /usr/local/pgsql/data/pg_subtrans ... ok
creating directory /usr/local/pgsql/data/base ... ok
creating directory /usr/local/pgsql/data/base/1 ... ok
creating directory /usr/local/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1000
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... ok
initializing pg_shadow ... ok
enabling unlimited row size for system tables ... ok
initializing pg_depend ... ok
creating system views ... WARNING: could not dump unrecognized node type: 650
WARNING: could not dump unrecognized node type: 650
WARNING: could not dump unrecognized node type: 650
WARNING: could not dump unrecognized node type: 650
WARNING: could not dump unrecognized node type: 650
WARNING: could not dump unrecognized node type: 650
WARNING: could not dump unrecognized node type: 650
WARNING: could not dump unrecognized node type: 650
FATAL: badly formatted node string "} {} {} {} {} {} {} {})} :rtekin"...
child process exited with exit code 1
##################################################################################################



This is generated by initdb.c, of course, calling fputs, and PG_CMD_OPEN...It eventually >
gets kicked out of outfuncs.c.

I get stuck there: why is this happening? Does anything jump out to you?

Any thoughts or comments (including, "Why don't you just commit suicide?") most welcome.


Thanks.

- Ross Mohan

p.s.

compiler flags:
CFLAGS=' -q64 -O4 -qnoipa -qphsinfo -qthreaded -I/usr/local/include/readline -I/usr/local/include -L/home/app/zlib-1.2.2 -lz '


Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedJun 4, '05 at 11:49p
activeJun 4, '05 at 11:49p
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Mohan, Ross: 1 post

People

Translate

site design / logo © 2022 Grokbase