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.