Significance of USE_FLOAT8_BYVAL ?

From: runner <runner(at)winning(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Significance of USE_FLOAT8_BYVAL ?
Date: 2011-02-25 18:25:45
Message-ID: 8CDA3308D1FB93D-1F8C-9F45@web-mmc-m02.sysops.aol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Using the 9.0.3 binaries from the PostgreSQL download site, Solaris 10 on Sparc architecture.

I had a co-worker set up a development server using the 32 bit PostgreSQL binaries for Solaris 10 Sparc. After some initial testing we realized we can't take full advantage of the 16 GB of system memory. So I downloaded the 64 bit binaries. We can't use the existing database we created because when we start the 64 bit server it errors out with:

2011-02-25 10:51:10 MST::@:[10060]: DETAIL: The database cluster was initialized without USE_FLOAT8_BYVAL but the server was compiled with USE_FLOAT8_BYVAL.
2011-02-25 10:51:10 MST::@:[10060]: HINT: It looks like you need to recompile or initdb.

I don't have a problem with blowing the database cluster away and starting over but I'd like to have a better understanding of what USE_FLOAT8_BYVAL does and how it affects our install. I spent a considerable amount of time googling this and was not able to locate any useful information that explains what this param does and how it will affect us.

Thank you,
Rick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-02-25 18:48:34 Re: Significance of USE_FLOAT8_BYVAL ?
Previous Message Vick Khera 2011-02-25 18:25:08 Re: Covert database from ASCII to UTF-8