Re: Reg: Postgresql8.3 Using on Ubuntu - Mailing list pgsql-bugs

Thank you so much your suggestions help me lot .....

While using
./configure CFLAGS="-01", I got some error. Its seems to 01, but when I use CFLAGS="-O1" its working properly.
I've follow the https://franklingu.github.io/reading/2017/01/27/installing-postgresql-8.3/ (helps to resolve the issue).
That's lot for your help.

Regards,
Neelaveni

If you search just a little bit, you'll find that's a known issue.

You should give arguments when you run configure script, but it seems to depend on you compiler:

./configure CFLAGS="-01"

or 

./configure CFLAGS="-01" CC=clang

P.S. Don't forget to run `make clean` before !

Flo

On Fri, Apr 26, 2019 at 2:44 PM neelaveni <neelaveni@bksystems.co.in> wrote:

Dear Flo,
    Thank you so much for your suggested things.
    I've tried to install postgresql 8.3.7 in ubuntu 16.04 using the source file (postgresql-8.3.7.tar.gz) with the following steps :
                   ./configure
                   make
                   su    
                  make install
                   adduser postgres
                   mkdir /usr/local/pgsql/data
                   chown postgres /usr/local/pgsql/data
                   su - postgres
                   /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
                   /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
                   /usr/local/pgsql/bin/createdb test
                   /usr/local/pgsql/bin/psql test

        Upto su - postgres all are fine.
        But for /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 en_IN.
                The default database encoding has accordingly been set to UTF8.
                The default text search configuration will be set to "english".

                fixing permissions on existing directory /usr/local/pgsql/data ... ok
                creating subdirectories ... ok
                selecting default max_connections ... 100
                selecting default shared_buffers/max_fsm_pages ... 32MB/204800
                creating configuration files ... ok
                creating template1 database in /usr/local/pgsql/data/base/1 ... ok
                initializing pg_authid ... FATAL:  wrong number of index expressions
                STATEMENT:  CREATE TRIGGER pg_sync_pg_database   AFTER INSERT OR UPDATE OR DELETE ON pg_database   FOR EACH STATEMENT EXECUTE PROCEDURE flatfile_update_trigger();
   
                child process exited with exit code 1
                initdb: removing contents of data directory "/usr/local/pgsql/data"

        /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
            starts to run on background.

        But while creating the db, it failed
        /usr/local/pgsql/bin/createdb test
        createdb: could not connect to database postgres: could not connect to server: No such file or directory
         Is the server running locally and accepting
         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
         [1]+  Exit 2                  /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data > logfile 2>&1

        While check with log, logfile
                postgres cannot access the server configuration file "/usr/local/pgsql/data/postgresql.conf": No such file or directory

        Kindly help to resolve this.

Regards,
Neelaveni

On Friday 26 April 2019 05:51 PM, Flo Rance wrote:

All current versions of Ubuntu support postgresql 8.3, but you'll have to build it from source.

https://www.postgresql.org/docs/8.3/installation.html

On Fri, Apr 26, 2019 at 1:17 PM neelaveni <neelaveni@bksystems.co.in> wrote:

Dear sir/mam,
    I accept that, but I require the details of which Ubuntu version support the postgresql8.3
    Kindly share it.

Regards,
Neelaveni

On Friday 26 April 2019 03:16 PM, Flo Rance wrote:

postgresql 8.3 has reached end-of-life in 2013. You must definitely use a more recent version.

https://www.postgresql.org/support/versioning/

Flo

On Fri, Apr 26, 2019 at 11:25 AM neelaveni <neelaveni@bksystems.co.in> wrote:

Dear sir/mam,
     Please share on which Ubuntu version will support the postgresql8.3

Regards,
Neelaveni