Amazing! Rebuilt without -O and it worked like a charm! Thanks, at the moment I need to stick to 9.0.9 on this machine to be able to reuse the same database files.
Da: Adrian Klaver <adrian.klaver@aklaver.com> A: Gabriele Bulfon <gbulfon@sonicle.com> pgsql-general@lists.postgresql.org Data: 29 maggio 2020 15.45.32 CEST Oggetto: Re: problem with self built postgres 9.0.9
On 5/29/20 6:32 AM, Gabriele Bulfon wrote: > Hi, I had to build postgres 9.0.9 from sources to run it under our new > XStreamOS/illumos release.
First 9.0 is ~ 5 years past EOL and it ended at 9.0.23.
Second this is as close as I could come to a solution:
Given that you say you are building against a new OS release I would look at what changed in the development stack.
> It used to build and run without problems in previous releases. > On this, just by running initdb I get these errors: > > sonicle@xstorage1:/sonicle$ initdb -D /sonicle/pgdata > The files belonging to this database system will be owned by user "sonicle". > This user must also own the server process. > > The database cluster will be initialized with locale en_US.UTF-8. > The default database encoding has accordingly been set to UTF8. > The default text search configuration will be set to "english". > > creating directory /sonicle/pgdata ... ok > creating subdirectories ... ok > selecting default max_connections ... 100 > selecting default shared_buffers ... 32MB > creating configuration files ... ok > creating template1 database in /sonicle/pgdata/base/1 ... ok > initializing pg_authid ... FATAL: column is not in index > child process exited with exit code 1 > initdb: removing data directory "/sonicle/pgdata" > Even running postgres over an already previously populated pgdata, any > attempt to connect to the database results in "FATAL: column is not in > index". > Any idea where the problem may be? > Thanks! > Gabriele > > *Sonicle S.r.l. *: http://www.sonicle.com <http://www.sonicle.com/> > *Music: *http://www.gabrielebulfon.com <http://www.gabrielebulfon.com/> > *Quantum Mechanics : *http://www.cdbaby.com/cd/gabrielebulfon