need to know if postgres is installed in 32 or 64 bit

Posted on 2007-10-08
Last Modified: 2012-06-21
i installed the SUNWpostgr packages available off sun's site, but do now know whether these are 32 or bit bit. how can i know?

Question by:ixarissysadmin
    LVL 10

    Expert Comment

    I believe if you do SELECT version() the result will show you what binaries you have.

    Author Comment

    i did:
    createdb test
    psql test
    test=# select version()

    but nothing was returned. i simply get the prompt again. no output

    Author Comment

    worked now by adding a ; but i still do not get 32/64 bit

    postgres=# select version()
    postgres-# ;
     PostgreSQL 8.1.4 on i386-pc-solaris2.10, compiled by /ws/on10-tools/SUNWspro/SOS8/bin/cc -Xa
    (1 row)


    Accepted Solution

    all you need to do is to run the cmd 'file' on the <postgres>/bin/postgres binary!
    LVL 1

    Expert Comment

    Closed, 500 points refunded.
    EE Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: ( This requires some add-o…
    Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
    Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now