Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: Normando on November 02, 2007, 05:28:45 AM

Title: Need install postgresql 8.x
Post by: Normando on November 02, 2007, 05:28:45 AM

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)

Quote

=============================================================================
 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:

Quote

=============================================================================
 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?

Title: Re: Need install postgresql 8.x
Post by: Normando on November 04, 2007, 09:26:21 AM

http://wiki.contribs.org/Postgres

Title: Re: Need install postgresql 8.x
Post by: Franco on November 07, 2007, 07:49:21 PM

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

Title: Re: Need install postgresql 8.x
Post by: steever on November 08, 2007, 01:05:10 AM

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

Title: Re: Need install postgresql 8.x
Post by: Normando on November 08, 2007, 01:10:13 AM

Quote from: stuntshell on November 07, 2007, 07:49:21 PM

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

You are welcome  :smile:

Title: Re: Need install postgresql 8.x
Post by: Franco on November 08, 2007, 02:16:10 AM

Quote from: steever on November 08, 2007, 01:05:10 AM

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

Quote

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

Title: Re: Need install postgresql 8.x
Post by: steever on November 08, 2007, 02:29:50 AM

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

Title: Re: Need install postgresql 8.x
Post by: Franco on November 08, 2007, 12:01:26 PM

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?