Re: Reg: Postgresql8.3 Using on Ubuntu

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
On Friday 26 April 2019 07:13 PM, Flo Rance wrote:
> 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
> <mailto: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 <mailto: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
>>> <mailto:neelaveni(at)bksystems(dot)co(dot)in>> wrote:
>>>
>>> Dear sir/mam,
>>> Please share on which Ubuntu version will support
>>> the postgresql8.3
>>>
>>> Regards,
>>> Neelaveni
>>>
>>>
>>
>