Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Where do I find an Official  pgInstaller distribution of PostgresSQL for Linux , and PGAdminIII?

Posted on 2011-03-14
4
Medium Priority
?
658 Views
Last Modified: 2012-05-11
Experts,

      Where would I find an official copy of Postgres 9 and PGAdmin III? I thought I had a good copy of PGAdmin III but got an error that the release that I had was not official. I do not want a release that has been repackaged. I had downloaded the rpms from postgres.org!

Thanks, Missymadi
0
Comment
Question by:missymadi
4 Comments
 
LVL 4

Assisted Solution

by:Alex Matzinger
Alex Matzinger earned 464 total points
ID: 35140434
For PGAdmin 3 use:
http://www.enterprisedb.com/products-services-training/pgdownload

and for Postgres 9:
http://www.enterprisedb.com/products-services-training/pgdownload

You can download the binaries from here which will auto install for you.  If you run into errors with it, post the entire message back here and I should be able to help you out with it.



0
 
LVL 22

Accepted Solution

by:
earth man2 earned 468 total points
ID: 35152936
yum and yast are RedHat and SuSE package management

yum install pgadmin3
yum install postgresql

http://www.postgresonline.com/journal/archives/45-An-Almost-Idiots-Guide-to-PostgreSQL-YUM.html
0
 

Author Comment

by:missymadi
ID: 35180898
Could someone explain to me why we would install Postgresql 8.1.23 and not the latest version? I was told by a coworker that postgresql is considered a downstream project and to use Postgresql 8.1.23 from RedHat to ensure the packages all work together on a Linux box?

And which version of PGAdmin would you use for a Postgres 8.1.23 version?

Thanks Missymadi
0
 
LVL 1

Assisted Solution

by:data_n_poker
data_n_poker earned 468 total points
ID: 35194329
Postgres 9 works fine on RedHat Linux.  I use it for mutliple databases on my system, and I am running it on a RedHat 5 machine.  There would be no reason to use Postgres 8.1 over Postgres 9.

If you do decide to use Postgres 8.1.23 though, PGAdmin 3 will work fine for it
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
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.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

783 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