[SAC] PostgreSQL on Telascience server

[John Graham]

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