Topic: Need install postgresql 8.x

[Normando]

Because I need version 8 (7.4 not work for the app I want to install).
I have found a topic with a mini-howto, but the method describe there give me this results:

With enable all repos (dag included)

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 postgresql              i386       8.1.9-1.el4s1.1  centosplus        2.7 M
Installing for dependencies:
 php-common              i386       5.1.6-3.el4s1.8  centosplus        136 k
 php-pdo                 i386       5.1.6-3.el4s1.8  centosplus        220 k
 postgresqlclient7       i386       7.4.17-1.el4s1.1  centosplus        235 k
Updating for dependencies:
 perl                    i386       4:5.8.8-4.el4s1  centosplus         11 M
 perl-DBD-Pg             i386       1.49-1.el4s1     centosplus        111 k
 php-pgsql               i386       5.1.6-3.el4s1.8  centosplus         62 k
 postgresql-libs         i386       8.1.9-1.el4s1.1  centosplus        183 k

Transaction Summary
=============================================================================
Install      4 Package(s)
Update       4 Package(s)
Remove       0 Package(s)
Total download size: 15 M

With enable only centoplus:

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 postgresql-jdbc         i386       8.1.4-1.centos.1  centosplus        1.1 M
 postgresql-server       i386       8.1.9-1.el4s1.1  centosplus        3.8 M
Installing for dependencies:
 php-common              i386       5.1.6-3.el4s1.8  centosplus        136 k
 php-pdo                 i386       5.1.6-3.el4s1.8  centosplus        220 k
 postgresql              i386       8.1.9-1.el4s1.1  centosplus        2.7 M
 postgresqlclient7       i386       7.4.17-1.el4s1.1  centosplus        235 k
Updating for dependencies:
 perl                    i386       4:5.8.8-4.el4s1  centosplus         11 M
 perl-DBD-Pg             i386       1.49-1.el4s1     centosplus        111 k
 php-pgsql               i386       5.1.6-3.el4s1.8  centosplus         62 k
 postgresql-libs         i386       8.1.9-1.el4s1.1  centosplus        183 k

Transaction Summary
=============================================================================
Install      6 Package(s)
Update       4 Package(s)
Remove       0 Package(s)
Total download size: 20 M

I don't want to upgrade perl or the php extensions. Is there a way to install ONLY postgresql 8.x without affecting any base package?

[Normando]

http://wiki.contribs.org/Postgres

[Franco]

And I thank you!
I added to my install php-pgsql so I can use the http://phppgadmin.sourceforge.net frontend.

[steever]

HI Stuntshell.

How do I log into phpgadmin?  What settings need to be changed and what username do I use.

First I tried postgres with the password I set up, but they said it was not allowed due to security.  So I went into the conf folder and changed extra security to false.

Then, when I tried logging in as postgres, I was told that the login failed.

How did you manage it?

I am trying to set up focus-sis or centre student management systems.  I would appreciate your help.

Steve

[Normando]

And I thank you!
I added to my install php-pgsql so I can use the http://phppgadmin.sourceforge.net frontend.

You are welcome 

[Franco]

So I went into the conf folder and changed extra security to false.

Go back and change to keep security a top
Then create a new user so you can login

su -c 'createuser -P test' postgres
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) y
Password:
CREATE ROLE

[steever]

Thanks, Stuntshell.

I changed extra security back to true, and created a couple of new users, but they can't log in.  Do you have any ideas?

Thanks in advance.

Steve

[Franco]

Sorry I'm no expert 
Did you make a new user with superuser privileges and tried login with that?
Also, have you restarted the server after modifying the .conf file?