[SAC] PostgreSQL on Telascience server

[John Graham]

apache restarted
pgsql is available http://mapbender.telascience.org/info.php

John

Christoph Baudson (WhereGroup) wrote:
> Thanks to all for your kind help, you made my day!
>
> I believe there is only one thing left to do: To enable the PostgreSQL 
> extension for PHP I guess Apache has to be restarted. I guess I'm not 
> allowed to do it. Can someone please restart Apache?
>
> Thanks very much
>
> Christoph
>
> John Graham schrieb:
>> Christoph
>>
>> I got pgsql running for you /etc/rc.d/init.d/postgresql start
>> I did no config ... just started it up ...
>> it needed a local postgres user ...
>> and chown home dir files
>> LDAP might have been interfering
>>
>> [johng at xblade10-2 ~]$ ps -aef | grep postg
>> postgres  9184     1  0 01:18 pts/2    00:00:00 /usr/bin/postmaster 
>> -p 5432 -D /var/lib/pgsql/data
>> postgres  9186  9184  0 01:18 pts/2    00:00:00 postgres: logger process
>> postgres  9188  9184  0 01:18 pts/2    00:00:00 postgres: writer process
>> postgres  9189  9184  0 01:18 pts/2    00:00:00 postgres: stats 
>> buffer process
>> postgres  9190  9189  0 01:18 pts/2    00:00:00 postgres: stats 
>> collector process
>>
>> Have Fun
>>
>> John
>>
>>
>> Christoph Baudson (WhereGroup) wrote:
>>> Hello,
>>>
>>> I'm still trying to get PostgreSQL running on the Telascience server 
>>> (http://mapbender.telascience.org/). But I don't seem to get 
>>> anywhere, see my previous post.
>>>
>>> Please let me know if I'm addressing the wrong group here.
>>>
>>> Thanks
>>>
>>> Christoph
>>>
>>> Christoph Baudson (WhereGroup) schrieb:
>>>> Hello,
>>>>
>>>> this is Christoph from Mapbender. Thanks to Howard for setting up 
>>>> our accounts; now I have a question about installing PostgreSQL on 
>>>> the Telascience server.
>>>>
>>>> I ran "sudo yum install postgresql" and the installation completed, 
>>>> but there were two errors (I have attached a log file).
>>>>
>>>> According to "sudo rpm -qa |grep post":
>>>> postfix-pflogsumm-2.2.2-2
>>>> postgresql-8.0.8-1.FC4.1
>>>> postfix-2.2.2-2
>>>> postgresql-libs-8.0.8-1.FC4.1
>>>>
>>>> postgresql seems to be installed. But there is no start script in 
>>>> /etc/init.d/.
>>>>
>>>> Do you know what might be wrong?
>>>>
>>>> Thanks
>>>>
>>>> Christoph
>>>>
>>>> -- 
>>>> Baudson Christoph
>>>> http://www.wheregroup.com
>>>>
>>>>
>>>> ------------------------------------------------------------------------ 
>>>>
>>>>
>>>> [christoph at xblade10-2 /]$ sudo yum install postgresql
>>>>
>>>> We trust you have received the usual lecture from the local System
>>>> Administrator. It usually boils down to these three things:
>>>>
>>>>     #1) Respect the privacy of others.
>>>>     #2) Think before you type.
>>>>     #3) With great power comes great responsibility.
>>>>
>>>> Password:
>>>> Setting up Install Process
>>>> Setting up repositories
>>>> updates-released          100% |=========================|  951 
>>>> B    00:00
>>>> extras                    100% |=========================| 1.1 
>>>> kB    00:00
>>>> base                      100% |=========================| 1.1 
>>>> kB    00:00
>>>> Reading repository metadata in from local files
>>>> Parsing package install arguments
>>>> Resolving Dependencies
>>>> --> Populating transaction set with selected packages. Please wait.
>>>> ---> Package postgresql.i386 0:8.0.8-1.FC4.1 set to be updated
>>>> --> Running transaction check
>>>> --> Processing Dependency: libpq.so.4 for package: postgresql
>>>> --> Restarting Dependency Resolution with new changes.
>>>> --> Populating transaction set with selected packages. Please wait.
>>>> ---> Package postgresql-libs.i386 0:8.0.8-1.FC4.1 set to be updated
>>>> --> Running transaction check
>>>>
>>>> Dependencies Resolved
>>>>
>>>> ============================================================================= 
>>>>
>>>>  Package                 Arch       Version          
>>>> Repository        Size
>>>> ============================================================================= 
>>>>
>>>> Installing:
>>>>  postgresql              i386       8.0.8-1.FC4.1    
>>>> updates-released  2.6 M
>>>> Installing for dependencies:
>>>>  postgresql-libs         i386       8.0.8-1.FC4.1    
>>>> updates-released  184 k
>>>>
>>>> Transaction Summary
>>>> ============================================================================= 
>>>>
>>>> Install      2 Package(s)
>>>> Update       0 Package(s)
>>>> Remove       0 Package(s)
>>>> Total download size: 2.8 M
>>>> Is this ok [y/N]: y
>>>> Downloading Packages:
>>>> (1/2): postgresql-libs-8. 100% |=========================| 184 
>>>> kB    00:00
>>>> (2/2): postgresql-8.0.8-1 100% |=========================| 2.6 
>>>> MB    00:29
>>>> Running Transaction Test
>>>> error: failed to stat /mnt/data3: Permission denied
>>>> Finished Transaction Test
>>>> Transaction Test Succeeded
>>>> Running Transaction
>>>> error: failed to stat /mnt/data3: Permission denied
>>>>   Installing: postgresql-libs              
>>>> ######################### [1/2]
>>>>   Installing: postgresql                   
>>>> ######################### [2/2]
>>>> Installed: postgresql.i386 0:8.0.8-1.FC4.1
>>>> Dependency Installed: postgresql-libs.i386 0:8.0.8-1.FC4.1
>>>> Complete!
>>>>
>>>>
>>>> ------------------------------------------------------------------------ 
>>>>
>>>>
>>>> _______________________________________________
>>>> Sac mailing list
>>>> Sac at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/sac
>>>
>>> _______________________________________________
>>> Sac mailing list
>>> Sac at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/sac
>
> _______________________________________________
> Sac mailing list
> Sac at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/sac