Re: Reg: Postgresql8.3 Using on Ubuntu

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(at)bksystems(dot)co(dot)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
> <https://ftp.postgresql.org/pub/source/v8.3.7/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(at)bksystems(dot)co(dot)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(at)bksystems(dot)co(dot)in>
>> wrote:
>>
>>> Dear sir/mam,
>>> Please share on which Ubuntu version will support the postgresql8.3
>>>
>>> Regards,
>>> Neelaveni
>>>
>>>
>>>
>>
>