Re: error initializing the db

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jennyfer Sanchez <jjsanchez(at)mail(dot)usf(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: error initializing the db
Date: 2016-09-02 19:51:00
Message-ID: 6358.1472845860@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jennyfer Sanchez <jjsanchez(at)mail(dot)usf(dot)edu> writes:
> I was able to install postgresql but I got an error after putting the
> command /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data/ to initialize
> the database. The error that I am getting is

> 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();

That looks suspiciously like this thread:

https://www.postgresql.org/message-id/flat/20150120161817(dot)GO1663%40alvh(dot)no-ip(dot)org#20150120161817(dot)GO1663(at)alvh(dot)no-ip(dot)org

which would suggest that you're trying to build some fairly old PG version
with some fairly new C compiler. Whether that's actually the case, well,
you didn't give enough info to tell.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2016-09-02 21:28:18 Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2
Previous Message Adrian Klaver 2016-09-02 18:48:00 Re: error initializing the db