Thread: 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>:
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.1 > > Do 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