Hello,

I've just ported PostgreSQL 6.5.3 to 2 machines:
IBM RS6000 590 running AIX 4.3.1, gcc 2.8.1, gnu make 3.78.1
IBM RS6000 J30 running AIX 4.2.1, gcc 2.8.1, gnu make 3.78.1

I have to compile the system using:

make --with-template=aix_gcc --without-CXX

Everything seems to work except when I'm compiling the regression test, on
both of the machines, it complained about:

postgres@genesis
[/usr/local/src/pgsql/postgresql-6.5.3/src/test] 162 $ make all runtest
make -C bench all
make[1]: Entering directory
`/usr/local/src/pgsql/postgresql-6.5.3/src/test/bench'
if [ -z "$USER" ]; then USER=$LOGNAME; fi; \
if [ -z "$USER" ]; then USER=`whoami`; fi; \
if [ -z "$USER" ]; then echo 'Cannot deduce $USER.'; exit 1; fi; \
rm -f create.sql; \
C=`pwd`; \
sed -e "s:_CWD_:$C:g" \
-e "s:_OBJWD_:$C:g" \
-e "s:_SLSUFF_::g" \
-e "s/_USER_/$USER/g" < create.source > create.sql
x=1; \
for i in `ls query[0-9][0-9]`; do \
echo "select $x as x" >> bench.sql; \
cat $i >> bench.sql; \
x=`expr $x + 1`; \
done
rm -f bench.out bench.out.perquery
make[1]: Leaving directory
`/usr/local/src/pgsql/postgresql-6.5.3/src/test/bench'
make -C regress all
make[1]: Entering directory
`/usr/local/src/pgsql/postgresql-6.5.3/src/test/regress'
gcc -I../../include -I../../backend -fsigned-chars -Wall
-Wmissing-prototypes -I../../interfaces/libpq -I../../include -c -o
regress.o regress.c
In file included from ../../include/postgres.h:42,
from regress.c:9:
../../include/c.h:173: warning: redefinition of `int8'
/usr/include/sys/inttypes.h:584: warning: `int8' previously declared here
../../include/c.h:174: warning: redefinition of `int16'
/usr/include/sys/inttypes.h:585: warning: `int16' previously declared here
../../include/c.h:175: warning: redefinition of `int32'
/usr/include/sys/inttypes.h:586: warning: `int32' previously declared here
../../backend/port/aix/mkldexport.sh regress.o `pwd` > regress.exp
Making share library regress.so from regress.o, regress.exp, and installed
postgres.imp
ld -H512 -bM:SRE -bI:/usr/local/pgsql/lib/postgres.imp -bE:regress.exp -o
regress.so regress.o -lPW -lcrypt -lld -lnsl -ldl -lm -ltermcap -lcurses
ld: 0711-224 WARNING: Duplicate symbol: fmgr_pl_finfo
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
information.
ld: 0711-317 ERROR: Undefined symbol: _iob
make[1]: *** [regress.so] Error 8
rm regress.exp regress.o
make[1]: Leaving directory
`/usr/local/src/pgsql/postgresql-6.5.3/src/test/regress'
make: *** [all] Error 2

postgres@genesis
[/usr/local/src/pgsql/postgresql-6.5.3/src/test] 163 $ echo $LD_LIBRARY_PATH
/usr/local/pgsql/lib

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Ed Yu, IBM Certified Specialist - AIX System Administrator
Information Technology Manager,
University of South Carolina,
Advanced Solutions Group, Physics Dept.,
Columbia, SC 29208
Office (803)777-8831, FAX (803)777-8833, Email ekyu@asgnet.psc.sc.edu

Search Discussions

  • Laurentiu c at Dec 15, 1999 at 8:37 pm
    hi everyone,

    here is what happens when i try to run initdb after installing postgresql under nt:

    $>initdb --username=Postgres

    We are initializing the database system with username Postgres (uid=1005).
    This user will own all the files and must also own the server process.

    Creating Postgres database system directory d:\usr\local\pgsql\data

    Creating Postgres database system directory d:\usr\local\pgsql\data/base

    Creating template database in d:\usr\local\pgsql\data/base/template1
    ERROR: mdopen: couldn't open d:\usr\local\pgsql\data/pg_variable: No such file or directory
    ERROR: mdopen: couldn't open d:\usr\local\pgsql\data/pg_variable: No such file or directory
    ...............

    and the last ERROR lines are repeated endlessly until i manually stop the process. same thing if i try with another valid username. the data, base, and template1 directories are created and also the first two pg_* files in template1, but apparently it doesn't continue because it cannot create pg_class. here is what i have in lib and bin:

    $>ls /usr/local/pgsql/lib

    total 2458
    247 -rw-r--r-- 1 postgres everyone 505481 Dec 11 23:10 ecpg.dll
    1 -r--r--r-- 1 postgres everyone 696 Dec 11 23:10 global1.bki.source
    0 -r--r--r-- 1 postgres everyone 0 Dec 11 23:10 global1.description
    8 -rw-r--r-- 1 postgres everyone 14522 Dec 11 23:10 libecpg.a
    945 -r--r--r-- 1 postgres everyone 1934912 Dec 11 23:10 libpostgres.a
    34 -rw-r--r-- 1 postgres everyone 67942 Dec 11 23:10 libpq++.a
    39 -rw-r--r-- 1 postgres everyone 77886 Dec 11 23:10 libpq.a
    85 -r--r--r-- 1 postgres everyone 172870 Dec 11 23:10 local1_template1.bki.source
    12 -r--r--r-- 1 postgres everyone 22583 Dec 11 23:10 local1_template1.description
    2 -r--r--r-- 1 postgres everyone 3407 Dec 11 23:10 pg_geqo.sample
    3 -r--r--r-- 1 postgres everyone 5192 Dec 11 23:10 pg_hba.conf.sample
    336 -rw-r--r-- 1 postgres everyone 686244 Dec 11 23:10 plpgsql.dll
    453 -rw-r--r-- 1 postgres everyone 927681 Dec 11 23:10 pq++.dll
    293 -rw-r--r-- 1 postgres everyone 598785 Dec 11 23:10 pq.dll


    $>ls /usr/local/pgsql/bin

    total 3506
    1 -r-xr-xr-x 1 postgres everyone 1065 Dec 11 23:10 cleardbdir
    2 -r-xr-xr-x 1 postgres everyone 2505 Dec 11 23:10 createdb
    3 -r-xr-xr-x 1 postgres everyone 4227 Dec 11 23:10 createlang
    3 -r-xr-xr-x 1 postgres everyone 4658 Dec 11 23:10 createuser
    1 -r-xr-xr-x 1 postgres everyone 1602 Dec 11 23:10 destroydb
    2 -r-xr-xr-x 1 postgres everyone 2951 Dec 11 23:10 destroylang
    2 -r-xr-xr-x 1 postgres everyone 3757 Dec 11 23:10 destroyuser
    338 -r-xr-xr-x 1 postgres everyone 691023 Dec 11 23:10 ecpg.exe
    9 -r-xr-xr-x 1 postgres everyone 17471 Dec 11 23:10 initdb
    2 -r-xr-xr-x 1 postgres everyone 3743 Dec 11 23:10 initlocation

    1 -r-xr-xr-x 1 postgres everyone 259 Dec 11 23:10 ipcclean
    217 -r-xr-xr-x 1 postgres everyone 443730 Dec 11 23:10 pg_dump.exe
    1 -r-xr-xr-x 1 postgres everyone 1803 Dec 11 23:10 pg_dumpall
    155 -r-xr-xr-x 1 postgres everyone 316368 Dec 11 23:10 pg_id.exe
    165 -r-xr-xr-x 1 postgres everyone 336531 Dec 11 23:10 pg_passwd.exe
    2 -r-xr-xr-x 1 postgres everyone 2251 Dec 11 23:10 pg_upgrade
    158 -r-xr-xr-x 1 postgres everyone 321557 Dec 11 23:10 pg_version.exe
    2196 -r-xr-xr-x 1 postgres everyone 4496147 Dec 11 23:10 postgres.exe
    1 lrw-r--r-- 1 postgres everyone 23 Dec 11 23:10 postmaster -> postgres.exe
    246 -r-xr-xr-x 1 postgres everyone 503445 Dec 11 23:10 psql.exe
    1 -r-xr-xr-x 1 postgres everyone 1956 Dec 11 23:10 vacuumdb

    when i installed postgresql, configure, make, and make install seemed to execute without any serious incident, i sent their output to .log files and checked them out with "cat *.log | grep Error" to make sure everything went fine. i also checked the environment with check_cygwin_setup.sh, the /etc/passwd file (local) was created.


    may i ask the pros three questions:

    (1) why can't i run initdb?

    (2) i have winnt 4.0 with service pack 6, cygwin-b20.1, and the postgresql-6.5.3 (egcs-1.1) : is there anythyng wrong with this configuration?

    (3) why initdb --username=jkr, as indicated in the winnt install readme and update post? why not just initdb --username=postgres; and, finally,

    (4) are both the Cygwin32 IPC package by Ludovic LANGE and cygwin32_ipc-1.03.tar.gz necessary? it seems to me that I can start ipc-daemon without the latter package but maybe i'm wrong (or maybe it's already there, from the cygwin installation, and i don't know it).

    thank you very much for any help you can provide.

    laurentiu



    ------------------------
    Sent by Gamespotmail.com
    GameSpot - Where Gamers Go To Know
    http://www.gamespot.com
  • Jens Skakkebaek at Dec 17, 1999 at 6:19 am
    auth 5f3d2a62 subscribe pgsql-ports jus@cs.stanford.edu

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedDec 11, '99 at 7:22p
activeDec 17, '99 at 6:19a
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase