Re: Reg: Postgresql8.3 Using on Ubuntu
От | Flo Rance |
---|---|
Тема | Re: Reg: Postgresql8.3 Using on Ubuntu |
Дата | |
Msg-id | CAHogYcVo+4=L2aBNGD9EMQSQoabMJ4RyAzOWYbR6KdFmgc0UxA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Reg: Postgresql8.3 Using on Ubuntu (neelaveni <neelaveni@bksystems.co.in>) |
Ответы |
Re: Reg: Postgresql8.3 Using on Ubuntu
(neelaveni <neelaveni@bksystems.co.in>)
|
Список | pgsql-bugs |
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,
NeelaveniOn 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.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,
NeelaveniOn 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.FloOn 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
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Peter EisentrautДата:
Сообщение: Re: BUG #15631: Generated as identity field in a temporary table withon commit drop corrupts system catalogs
Следующее
От: Tom LaneДата:
Сообщение: Re: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs