Re: Reg: Postgresql8.3 Using on Ubuntu

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
>>
>>
>