Inability to init db Postgresql-9.1.1 on Ubuntu
Hi,
I have to make some experiments for which I explicitly need version 9.1.1
of PostgreSQL.
I have installed it from source using the official documentation but I am
not able to initialize the cluster after that.
When I run initdb, I receive the following error:
STATEMENT: REVOKE ALL on pg_authid FROM public;
I found out on your forums that normally this is a compiler error.
So I used:
CC="gcc-4.7" CFLAGS="-g -O0" ./configure -enable-debug -enable-depend
-prefix=$HOME/paqo -enable-cassert
But still I receive the same error. I changed the compiler and then I hit
a strange error which is telling me that I have a missing "}" at my
system_view.sql file which is not correct.
I am trying the installation on 64 bit Ubuntu Desktop 16.04.4
Please advise. I am struggling on this since a couple of days and becomes a
little bit urgent already.
Thank you in advance!
Have a nice weekend,
Ekaterina
On 2018-Jun-29, Ekaterina Dimitrova wrote:
I have to make some experiments for which I explicitly need version 9.1.1
of PostgreSQL.I have installed it from source using the official documentation but I am
not able to initialize the cluster after that.When I run initdb, I receive the following error:
STATEMENT: REVOKE ALL on pg_authid FROM public;
You could try installing 9.1.<latest>, initdb with that, then revert
the package back to 9.1.1.
--
�lvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Hi Alvaro,
Thank you for your response. I need to be able to work on and compile the
source code of 9.1.1
Do you have any other idea?
Thank you one more time.
Kate
2018-06-29 15:15 GMT-04:00 Alvaro Herrera <alvherre@2ndquadrant.com>:
Show quoted text
On 2018-Jun-29, Ekaterina Dimitrova wrote:
I have to make some experiments for which I explicitly need version 9.1.1
of PostgreSQL.I have installed it from source using the official documentation but I am
not able to initialize the cluster after that.When I run initdb, I receive the following error:
STATEMENT: REVOKE ALL on pg_authid FROM public;You could try installing 9.1.<latest>, initdb with that, then revert
the package back to 9.1.1.--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
On Fri, Jun 29, 2018 at 03:47:19PM -0400, Ekaterina Dimitrova wrote:
Thank you for your response. I need to be able to work on and compile the
source code of 9.1.1Do you have any other idea?
And why not using a newer version? 9.1 has been EOL'd by community in
2016 with 9.1.24 being the latest one:
https://www.postgresql.org/docs/devel/static/release-9-1-24.html
If you still wish to stick with this version, you could at least try the
latest version in the released set..
--
Michael