Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Compilation help

Compilation help

Compilation help


How can I compile PostgreSQL-7.2.2 with 64-bit file offset support enabled under linux.


RE: Compilation help

Hi SkyHigh,

If you are asking what is need to run the 64 bit version of postgres, I think you would need hardward running the Alpha 64 bit cpu and software like tru64 UNIX OS.  You would also need a gcc or cc 64 bit compiler.  I think all of this is available from Sun.

Intel and other hardware manufacture are building a system to support 64 bit processing on the x86, but I don't think it fully cooked yet.  After the hardware is available, all the OS and programs would need to recompiled to take advantage of the new hardware.

I hope I understood your question correctly.

Leland F. Jackson, CPA
Software - Master (TM)
Nothing Runs Like the Fox

RE: Compilation help

Thanks, but how can I back up my database backup of which exceeds 2 gigs and we do have largefile support on that backup directory but pg_dump fails.

RE: Compilation help

HI SkyHigh,

I haven't hit that problem before.  I wonder if this is a problem of the OS as opposed to postgres.  If someone else dosen't come in to help, you can go to the postgres web site and join some of their mailing lists.  Then you could email the list about this and see if someone can give you a hand.  The postgres web site is at:


Leland F. Jackson, CPA
Software - Master (TM)
Nothing Runs Like the Fox

RE: Compilation help

SkyHigh - exactly what syntax are you using when you try to call pg_dump?

PostgreSQL supports table > 2GB even on 32-bit platforms, so the problem is only with how pg_dump connects to the filesystem.


Big Brother: "War is Peace" -- Big Business: "Trust is Suspicion"

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close