[SAC] PostgreSQL on Telascience server

[Christoph Baudson (WhereGroup)]

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