[SAC] PostgreSQL on Telascience server

Committees SAC mailing list
1

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

postgresql.log (2.4 KB)

2

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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/sac

3

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.

Christoph,

I believe you are addressing the right group but there just happens to
be no one who knows what has gone wrong.

Have you tried uninstalling and re-installing the packages? I see that
/mnt/data3 is now just a plain directory whereas I presume at one time
it was used to mount an external disk. Perhaps things will go more
smoothly now.

If that doesn't help, but the only thing missing is the rc script, you could
likely setup something a bit custom to start postgresql.

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | President OSGeo, http://osgeo.org

4

Frank Warmerdam wrote:

If that doesn't help, but the only thing missing is the rc script, you
could likely setup something a bit custom to start postgresql.

Frank, Christoph,

We (GDAL) are also interested in running PostgreSQL there.
I'm not sure who installed it on the server, it could be me, but I don't
remember :-).
Anyway, if you will need any assistance, I'm ready to help with this.

Cheers
--
Mateusz Loskot
http://mateusz.loskot.net

5

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.

I configured and started PostgreSQL on the xblade14-2.
As I see, we don't have PostGIS installed there.
What version do we want to install, from RPM or build it manually ?

Cheers
--
Mateusz Loskot
http://mateusz.loskot.net

6

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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/sac

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/sac

7

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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/sac

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/sac

8

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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/sac

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/sac

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/sac

9

It's amazing how many php info pages there are out there :slight_smile:

http://www.google.com/search?q="phpinfo()"++"PHP+Version"+%2
2info.php%22

Jason

-----Original Message-----
From: John Graham
Subject: Re: [SAC] PostgreSQL on Telascience server

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

John