RPM not installing

lordshipmayhem · 07-24-2007, 01:17 PM

I'm trying to install the Postgresql server package "postgresql-server-8.1.9-0.1mdv2007.0".

Every time after I try to load the package, the Software Management application returns that as one of the packages that hasn't been installed, but is still available to install.

There are supposed to be release notes with this package, but clicking on that gives me a blank field, which may or may not be a symptom of my problem.

I'm running Powerpack 2007 on 32-bit using a Pentium 3 (ancient but hey, it works).

All of the other available packages for Postgresql are installed.

Any suggestions or answers will be gratefully received. Thanks!

jailbait · 07-24-2007, 01:47 PM

"I'm trying to install the Postgresql server package "postgresql-server-8.1.9-0.1mdv2007.0"."
Every time after I try to load the package, the Software Management application returns that as one of the packages that hasn't been installed, but is still available to install."

There may be problems in your rpm data base. I suggest that you drop down into the rpm command and check out your data base:

rpm -qi | sort | less

If things look strange you could try (Use caution. Have a backup, etc):

rpm --rebuilddb

see:
man rpm

---------------
Steve Stites

reddazz · 07-24-2007, 01:56 PM

Try doing,

Code:

#urpmi postgresql-server

lordshipmayhem · 07-25-2007, 08:50 AM

Attempt at rebuilding the RPM database didn't end up doing anything noticeable.

Attempt using the BASH shell returned the following:

ftp://ftp.ps.pl/mirrors/Mandrakelinu...007.0.i586.rpm
installing postgresql-server-8.1.9-0.1mdv2007.0.i586.rpm from /var/cache/urpmi/rpms
Preparing... #############################################

*******************
* Starting backup *
*******************
Cannot find postgresql service
Usage: service -[Rfshv] SERVICE ARGUMENTS
-f|--full-restart: Do a fullrestart of the service.
-R|--full-restart-all: Do a fullrestart of all services currently running.
-s|--status-all: Print a status of all services.
-d|--debug: Launch with debug.
-h|--help: This help.
Backuping configuration into /var/lib/pgsql/backups/config.8.1.9-0.1mdv2007.0.tar
Backup of configuration already exists, aborting
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
error: %pre(postgresql-server-8.1.9-0.1mdv2007.0.i586) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping postgresql-server-8.1.9-0.1mdv2007.0
----------------------------------------------------------------------
More information on package postgresql-server-8.1.9-0.1mdv2007.0.i586
----------------------------------------------------------------------

****
I'm now looking at the list of packages to see if I'm missing anything.

ernie · 07-25-2007, 11:23 AM

Quote:

Originally Posted by lordshipmayhem

Backuping configuration into /var/lib/pgsql/backups/config.8.1.9-0.1mdv2007.0.tar
Backup of configuration already exists, aborting

These two lines are significant. Since the install script was unable to store a configuration backup (file already exists) it aborted so the remaining steps failed (my best guess).

Open a terminal window as root (or su to root).

execute the following command:

Code:

konqueror

In the Konqueror window open the Settings menu, select Load View Profile > File Management

Navigate to /var/lib/pgsql/backups and delete config.8.1.9-0.1mdv2007.0.tar

Now try the urpmi command:

Code:

urpmi postgresql-server

HTH,

lordshipmayhem · 07-25-2007, 11:52 AM

Well, that was an improvement. Now I have another file found.

ftp://ftp.ps.pl/mirrors/Mandrakelinu...007.0.i586.rpm
installing postgresql-server-8.1.9-0.1mdv2007.0.i586.rpm from /var/cache/urpmi/rpms
Preparing... #############################################

*******************
* Starting backup *
*******************
Cannot find postgresql service
Usage: service -[Rfshv] SERVICE ARGUMENTS
-f|--full-restart: Do a fullrestart of the service.
-R|--full-restart-all: Do a fullrestart of all services currently running.
-s|--status-all: Print a status of all services.
-d|--debug: Launch with debug.
-h|--help: This help.
Backuping configuration into /var/lib/pgsql/backups/config.8.1.9-0.1mdv2007.0.tar
Overriding pg_hba.conf to allow local connection
Cannot find postgresql service
Usage: service -[Rfshv] SERVICE ARGUMENTS
-f|--full-restart: Do a fullrestart of the service.
-R|--full-restart-all: Do a fullrestart of all services currently running.
-s|--status-all: Print a status of all services.
-d|--debug: Launch with debug.
-h|--help: This help.
Dumping database into /var/lib/pgsql/backups/db.8.1.9-0.1mdv2007.0.gz
Database dump already exists, aborting
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
error: %pre(postgresql-server-8.1.9-0.1mdv2007.0.i586) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping postgresql-server-8.1.9-0.1mdv2007.0
----------------------------------------------------------------------
More information on package postgresql-server-8.1.9-0.1mdv2007.0.i586
----------------------------------------------------------------------

Going in and getting rid of all three files labelled "8.1.9-0.1mdv2007.0.i586" results in the following:
ftp://ftp.ps.pl/mirrors/Mandrakelinu...007.0.i586.rpm
installing postgresql-server-8.1.9-0.1mdv2007.0.i586.rpm from /var/cache/urpmi/rpms
Preparing... #############################################

*******************
* Starting backup *
*******************
Cannot find postgresql service
Usage: service -[Rfshv] SERVICE ARGUMENTS
-f|--full-restart: Do a fullrestart of the service.
-R|--full-restart-all: Do a fullrestart of all services currently running.
-s|--status-all: Print a status of all services.
-d|--debug: Launch with debug.
-h|--help: This help.
Backuping configuration into /var/lib/pgsql/backups/config.8.1.9-0.1mdv2007.0.tar
Overriding pg_hba.conf to allow local connection
Cannot find postgresql service
Usage: service -[Rfshv] SERVICE ARGUMENTS
-f|--full-restart: Do a fullrestart of the service.
-R|--full-restart-all: Do a fullrestart of all services currently running.
-s|--status-all: Print a status of all services.
-d|--debug: Launch with debug.
-h|--help: This help.
Dumping database into /var/lib/pgsql/backups/db.8.1.9-0.1mdv2007.0.gz
pg_dumpall: could not connect to database "template1": could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
error: %pre(postgresql-server-8.1.9-0.1mdv2007.0.i586) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping postgresql-server-8.1.9-0.1mdv2007.0
----------------------------------------------------------------------
More information on package postgresql-server-8.1.9-0.1mdv2007.0.i586
----------------------------------------------------------------------

So it's an improvement, but it still seems to be crapping out W/R/T finding postgresql service.

Thanks so far - I feel like I'm almost there, I just have to resolve this last piece of the puzzle and I'll be up and running.

ernie · 07-25-2007, 09:45 PM

Do you have postgresql installed on the system (is this an update/upgrade)? If so, remove the back up file(s) again, then try making sure the service is running with:

Code:

service postgresql start

Finally install the package. I'm thinking that if postgresql is installed, but not running, that may be the reason for the message:

Quote:

Cannot find postgresql service

HTH,

lordshipmayhem · 07-27-2007, 01:49 PM

Postgresql is installed, but when I try to start the service it comes back with: "Cannot find postgresql service"

At present I have installed:
- postgresql-8.1.9-0.1mdv2007.0
- postgresql-contrib-8.1.9-0.1mdv2007.0
- postgresql-docs-8.1.9-0.1mdv2007.0
- postgresql-pl-8.1.9-0.1mdv2007.0
- postgresql-plperl-8.1.9-0.1mdv2007.0
- postgresql-plpgsql-8.1.9-0.1mdv2007.0
- postgresql-plpython-8.1.9-0.1mdv2007.0
- postgresql-pltcl-8.1.9-0.1mdv2007.0
- postgresql-test-8.1.9-0.1mdv2007.0

I'm presently using Mandriva Powerpack 2007 on a Pentium III. Hey, it may be ancient, but it works. ^_^

reddazz · 07-27-2007, 02:50 PM

You do not have the server package installed. This package is named as postgresql-server and you should install it using he instructions we posted earlier.

lordshipmayhem · 07-27-2007, 02:57 PM

I'd love to install the server.

The problem is every time I attempt to install it, because postgresql
service is not running (I keep getting "Cannot find postgresql service" when I try to start it within the BASH shell - and yes, I've su'd to ROOT before trying to start it), the package keeps doing a crash-and-burn.

I have had a suggestion from the GTALUG mailing list to try to do a noscript install of the server, but before I try that rather hazardous sounding technique, I'd like some more commentary on that.

reddazz · 07-27-2007, 03:02 PM

One thing I do suggest, is to configure the various main, contrib, plf and updates repos for your version of Mandriva using the instructions at easyurpmi. That may help urpmi fetch the latest packages from the Mandriva mirrors. If you have already got these setup, then update your sources by doing

Code:

urpmi.update -a

I personally would uninstall all postgresql stuff on the system, remove any config files and directories (obviously backup any important data). After that I'd do a clean install of the postgresql packages using urpmi.