Postgres Pro
Downloads
Home   >   mailing lists

64 or 32 postgres - Mailing list pgsql-admin

From Subbiah, Stalin
Subject 64 or 32 postgres
Date
Msg-id 6B26A56846293C4488B54CF3E44033546CFF05@mxca2.corp.netopia.com
Whole thread Raw
Responses Re: 64 or 32 postgres  (Matthew Wronkowski <mattw@csh.rit.edu>)
Re: 64 or 32 postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view

How to figure out whether the installed postgres version is 32 bit or 64bit ? We installed postgres801 from src on susu box with EMT64 bit hardware. I assume since the hardware was 64 bit, postgres should have compiled in 64 bit too, but then we ran into this error

FATAL: database files are incompatible with server
DETAIL: The database cluster was initialized without HAVE_INT64_TIMESTAMP but the server was compiled with HAVE_INT64_TIMESTAMP.

HINT: It looks like you need to recompile or initdb.

Any ideas ?

Thanks,
Stalin

pgsql-admin by date:

Previous
From: "Lee Wu"
Date:
Subject: Re: explain analyze of PG server level
Next
From: Matthew Wronkowski
Date:
Subject: Re: 64 or 32 postgres