Forum OpenACS Development: Response to PostgreSQL 7.2.1 ?bug?

Collapse
Posted by Neophytos Demetriou on
# select 2^7;
 ?column? 
----------
      128
(1 row)
Same result in template1 and other databases. Here's how I configure and start PG, respectively:

Installing PostgreSQL 7.2.1

cd /usr/local/src
        tar -xzvf postgresql-7.2.1.tar.gz
        cd postgresql-7.2.1
        ./configure --enable-multibyte=UNICODE --with-tcl --with-perl --enable-syslog
        gmake
        gmake install
        gmake install-all-headers
        mkdir /usr/local/pgsql/data
        useradd postgres
        passwd postgres
        chown postgres /usr/local/pgsql/data
        su - postgres
        export LANG=C
        /usr/local/pgsql/bin/initdb  --encoding unicode  -D /usr/local/pgsql/data
        /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &        /usr/local/pgsql/bin/createdb test
        /usr/local/pgsql/bin/psql test
        /usr/local/pgsql/bin/dropdb test
        exit

Starting PG

/etc/rc.local
su -l postgres -c 'export LANG=C; /usr/local/pgsql/bin/postmaster -N 200 -B 1000 -o "-S 2000" -S -D /usr/local/pgsql/data '
I'm using RH-7.2. Only thing I can think of is that I messed something while trying to compile the new linux kernel with the grsecurity patches. I'm downloading RH-7.3, try to upgrade and see what comes out of it.