PostgreSQL 7.1 Linux Installation

On Thu, Feb 22, 2001 at 04:07:06PM -0300, Paulo Parola wrote:

Hi

...

[root@atlas PostgreSQL]# rpm -e postgresql-server-7.0.2-17.i386.rpm
error: package postgresql-server-7.0.2-17.i386.rpm is not installed
[root@atlas PostgreSQL]# rpm -e postgresql-7.0.2-17.i386.rpm
error: package postgresql-7.0.2-17.i386.rpm is not installed

when you remove a package you leave out the version
number like
# rpm -evv postgresql-server

Paulo Parola wrote:
I had a previously installed version of PostgreSQL server
(postgresql-server-7.0.2-17.i386.rpm). I had though a problem with the
RPM install procedure, when the following messages were issued:

postgresql-server
##################################################
/sbin/ldconfig: Input file /usr/lib/libgck.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimp.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimpui.so not found.

Is that problematic? In fact I started the postmaster and have tested
accessing the database both with 'psql' remotely through SSH as well
as with phpPgAdmin via Web and it is apparently functioning very well.

It's a quirk of the server postinstall script. But it doesn't cause any
problems.

[root@atlas PostgreSQL]# rpm -Uvh postgresql-7.1beta4-1.i386.rpm
error: failed dependencies:
postgresql = 7.0.2 is needed by postgresql-server-7.0.2-17
libpq.so.2.1 is needed by php-pgsql-4.0.1pl2-9
libpq.so.2.1 is needed by postgresql-server-7.0.2-17
[root@atlas PostgreSQL]# rpm -Uvh
postgresql-server-7.1beta4-1.i386.rpm
error: failed dependencies:
postgresql = 7.1beta4 is needed by
postgresql-server-7.1beta4-1
libpq.so.2 is needed by postgresql-server-7.1beta4-1

The upgrade has to be done on one line: rpm -Uvh
postgresql-7.1beta4-1.i386.rpm postgresql-server-7.1beta4-1.i386.rpm.
Please note that those RPM's were built on RedHat 6.2, not 7.0.

[root@atlas PostgreSQL]# rpm -e postgresql-server-7.0.2-17.i386.rpm
error: package postgresql-server-7.0.2-17.i386.rpm is not installed
[root@atlas PostgreSQL]# rpm -e postgresql-7.0.2-17.i386.rpm
error: package postgresql-7.0.2-17.i386.rpm is not installed

The installed package name is just 'postgresql-7.0.2-17' or
'postgresql-server-7.0.2-17'. No .i386.rpm.

The dependencies on libpq.so.2.1 are more troublesome, unfortunately.
While you can use --nodeps to force bypassing the dependencies, that is
not recommended for the 'typical' RPM install. 7.1beta4 provides
libpq.so.2.2, not libpq.so.2.1, and the dependency system as it stands
won't automatically say 'oh, it's a newer _minor_ version -- no
problem.'
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

According to rpmfind.net the files libgck.so, libgimp.so, and
libgimpui.so are GIMP libraries so you shouldn't require them.
But I would install gimp and gimp-devel just in case.

When upgrading Postgres the RPM system prevents you from killing
the dependencies of the previous version accidently. To upgrade
your server should run this to ignore dependencies:

# rpm -Uvh --nodeps postgresql-7.1beta4-1.i386.rpm
# rpm -Uvh --nodeps postgresql-server-7.1beta4-1.i386.rpm

Brent

--- Paulo Parola <pgsql@brazilinfo.com> wrote:

Hi

I need some help with PostgreSQL installation over RedHat 7.0.

I had a previously installed version of PostgreSQL server
(postgresql-server-7.0.2-17.i386.rpm). I had though a problem
with the RPM install procedure, when the following messages
were issued:

postgresql-server
##################################################
/sbin/ldconfig: Input file /usr/lib/libgck.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimp.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimpui.so not found.

Is that problematic? In fact I started the postmaster and have
tested accessing the database both with 'psql' remotely
through SSH as well as with phpPgAdmin via Web and it is
apparently functioning very well.

I have just downloaded the PostgreSQL v7.1 RPM
(postgresql-server-7.1beta4-1.i386.rpm). I first de-installed
version postgresql-server-7.0.2-17 since I believe I should
first have installed postgresql-7.0.2-17.i386.rpm instead.

I then tried to install version 7.0.2 (both files this time)
and perform an upgrade to 7.1 but got the following
dependencies problems:

[root@atlas PostgreSQL]# rpm -ivh postgresql-7.0.2-17.i386.rpm
postgresql
##################################################
/sbin/ldconfig: Input file /usr/lib/libgck.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimp.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimpui.so not found.

[root@atlas PostgreSQL]# rpm -ivh
postgresql-server-7.0.2-17.i386.rpm
postgresql-server
##################################################
/sbin/ldconfig: Input file /usr/lib/libgck.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimp.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimpui.so not found.

[root@atlas PostgreSQL]# rpm -Uvh
postgresql-7.1beta4-1.i386.rpm
error: failed dependencies:
postgresql = 7.0.2 is needed by
postgresql-server-7.0.2-17
libpq.so.2.1 is needed by php-pgsql-4.0.1pl2-9
libpq.so.2.1 is needed by postgresql-server-7.0.2-17

[root@atlas PostgreSQL]# rpm -Uvh
postgresql-server-7.1beta4-1.i386.rpm
error: failed dependencies:
postgresql = 7.1beta4 is needed by
postgresql-server-7.1beta4-1
libpq.so.2 is needed by postgresql-server-7.1beta4-1

[root@atlas PostgreSQL]# rpm -ivh postgresql-7.0.2-17.i386.rpm
package postgresql-7.0.2-17 is already installed
[root@atlas PostgreSQL]# rpm -ivh
postgresql-server-7.0.2-17.i386.rpm
package postgresql-server-7.0.2-17 is already installed
[root@atlas PostgreSQL]#

Also strange is that when I issue the command to de-install
the 7.0.2 RPMs the system issues messages stating that the
packages are not installed, although they are:

[root@atlas PostgreSQL]# rpm -e
postgresql-server-7.0.2-17.i386.rpm
error: package postgresql-server-7.0.2-17.i386.rpm is not
installed
[root@atlas PostgreSQL]# rpm -e postgresql-7.0.2-17.i386.rpm
error: package postgresql-7.0.2-17.i386.rpm is not installed

[root@atlas PostgreSQL]# rpm -ivh postgresql-7.0.2-17.i386.rpm
package postgresql-7.0.2-17 is already installed
[root@atlas PostgreSQL]# rpm -ivh
postgresql-server-7.0.2-17.i386.rpm
package postgresql-server-7.0.2-17 is already installed

Any help would be greatly appreciated.

TIA,
Paulo

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/

OK!

I managed already to clean all traces of the old version, and installed
version 7.1 on my system. I configured through Linuxconf to make it start
automatically during boot time (it actually only executes the apropriate
shell script to start the server, '/etc/rc.d/init.d/postgresql').

After rebooting my server and trying to access PostgreSQL I noticed that it
was not running:

psql: connectDBStart() -- connect() failed: Connection refused
Is the postmaster running locally
and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?

So I tryed to start it manually ('/etc/rc.d/init.d/postgresql start') and
detected the problem: I have databases that I did not drop from the old
version and apparently the database formats of the new version are somewhat
different.

[root@atlas init.d]# ./postgresql start
Checking postgresql installation:
An old version of the database format was found.
You need to upgrade the data format before using PostgreSQL.
See (Your System's documentation
directory)/postgresql-7.1beta3/README.rpm-dist for more information.
[root@atlas init.d]#

I am having trouble finding the documentation associated with this problem.
Anyone have an idea of the steps I should follow to upgrade my databases to
the new format?

TIA,
Paulo

----- Original Message -----
From: Brent R. Matzelle <bmatzelle@yahoo.com>
To: <pgsql-general@postgresql.org>
Sent: Thursday, February 22, 2001 4:53 PM
Subject: Re: [GENERAL] PostgreSQL 7.1 Linux Installation

According to rpmfind.net the files libgck.so, libgimp.so, and
libgimpui.so are GIMP libraries so you shouldn't require them.
But I would install gimp and gimp-devel just in case.

When upgrading Postgres the RPM system prevents you from killing
the dependencies of the previous version accidently. To upgrade
your server should run this to ignore dependencies:

# rpm -Uvh --nodeps postgresql-7.1beta4-1.i386.rpm
# rpm -Uvh --nodeps postgresql-server-7.1beta4-1.i386.rpm

Brent

--- Paulo Parola <pgsql@brazilinfo.com> wrote:

Hi

I need some help with PostgreSQL installation over RedHat 7.0.

I had a previously installed version of PostgreSQL server
(postgresql-server-7.0.2-17.i386.rpm). I had though a problem
with the RPM install procedure, when the following messages
were issued:

postgresql-server
##################################################
/sbin/ldconfig: Input file /usr/lib/libgck.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimp.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimpui.so not found.

Is that problematic? In fact I started the postmaster and have
tested accessing the database both with 'psql' remotely
through SSH as well as with phpPgAdmin via Web and it is
apparently functioning very well.

I have just downloaded the PostgreSQL v7.1 RPM
(postgresql-server-7.1beta4-1.i386.rpm). I first de-installed
version postgresql-server-7.0.2-17 since I believe I should
first have installed postgresql-7.0.2-17.i386.rpm instead.

I then tried to install version 7.0.2 (both files this time)
and perform an upgrade to 7.1 but got the following
dependencies problems:

[root@atlas PostgreSQL]# rpm -ivh postgresql-7.0.2-17.i386.rpm
postgresql
##################################################
/sbin/ldconfig: Input file /usr/lib/libgck.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimp.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimpui.so not found.

[root@atlas PostgreSQL]# rpm -ivh
postgresql-server-7.0.2-17.i386.rpm
postgresql-server
##################################################
/sbin/ldconfig: Input file /usr/lib/libgck.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimp.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimpui.so not found.

[root@atlas PostgreSQL]# rpm -Uvh
postgresql-7.1beta4-1.i386.rpm
error: failed dependencies:
postgresql = 7.0.2 is needed by
postgresql-server-7.0.2-17
libpq.so.2.1 is needed by php-pgsql-4.0.1pl2-9
libpq.so.2.1 is needed by postgresql-server-7.0.2-17

[root@atlas PostgreSQL]# rpm -Uvh
postgresql-server-7.1beta4-1.i386.rpm
error: failed dependencies:
postgresql = 7.1beta4 is needed by
postgresql-server-7.1beta4-1
libpq.so.2 is needed by postgresql-server-7.1beta4-1

[root@atlas PostgreSQL]# rpm -ivh postgresql-7.0.2-17.i386.rpm
package postgresql-7.0.2-17 is already installed
[root@atlas PostgreSQL]# rpm -ivh
postgresql-server-7.0.2-17.i386.rpm
package postgresql-server-7.0.2-17 is already installed
[root@atlas PostgreSQL]#

Also strange is that when I issue the command to de-install
the 7.0.2 RPMs the system issues messages stating that the
packages are not installed, although they are:

[root@atlas PostgreSQL]# rpm -e
postgresql-server-7.0.2-17.i386.rpm
error: package postgresql-server-7.0.2-17.i386.rpm is not
installed
[root@atlas PostgreSQL]# rpm -e postgresql-7.0.2-17.i386.rpm
error: package postgresql-7.0.2-17.i386.rpm is not installed

[root@atlas PostgreSQL]# rpm -ivh postgresql-7.0.2-17.i386.rpm
package postgresql-7.0.2-17 is already installed
[root@atlas PostgreSQL]# rpm -ivh
postgresql-server-7.0.2-17.i386.rpm
package postgresql-server-7.0.2-17 is already installed

Any help would be greatly appreciated.

TIA,
Paulo

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices!

http://auctions.yahoo.com/

You can either dump and restore the old database with pg_dump or
use pg_upgrade to upgrade the database. See the pg_dump and
pg_upgrade manual pages for instructions on how to do this.

Brent

--- Paulo Parola <pgsql@brazilinfo.com> wrote:

OK!

I managed already to clean all traces of the old version, and
installed
version 7.1 on my system. I configured through Linuxconf to
make it start
automatically during boot time (it actually only executes the
apropriate
shell script to start the server,
'/etc/rc.d/init.d/postgresql').

After rebooting my server and trying to access PostgreSQL I
noticed that it
was not running:

psql: connectDBStart() -- connect() failed: Connection refused
Is the postmaster running locally
and accepting connections on Unix socket
'/tmp/.s.PGSQL.5432'?

So I tryed to start it manually ('/etc/rc.d/init.d/postgresql
start') and
detected the problem: I have databases that I did not drop
from the old
version and apparently the database formats of the new version
are somewhat
different.

[root@atlas init.d]# ./postgresql start
Checking postgresql installation:
An old version of the database format was found.
You need to upgrade the data format before using PostgreSQL.
See (Your System's documentation
directory)/postgresql-7.1beta3/README.rpm-dist for more
information.
[root@atlas init.d]#

I am having trouble finding the documentation associated with
this problem.
Anyone have an idea of the steps I should follow to upgrade my
databases to
the new format?

TIA,
Paulo

----- Original Message -----
From: Brent R. Matzelle <bmatzelle@yahoo.com>
To: <pgsql-general@postgresql.org>
Sent: Thursday, February 22, 2001 4:53 PM
Subject: Re: [GENERAL] PostgreSQL 7.1 Linux Installation

According to rpmfind.net the files libgck.so, libgimp.so,

and

libgimpui.so are GIMP libraries so you shouldn't require

them.

But I would install gimp and gimp-devel just in case.

When upgrading Postgres the RPM system prevents you from

killing

the dependencies of the previous version accidently. To

upgrade

your server should run this to ignore dependencies:

# rpm -Uvh --nodeps postgresql-7.1beta4-1.i386.rpm
# rpm -Uvh --nodeps postgresql-server-7.1beta4-1.i386.rpm

Brent

--- Paulo Parola <pgsql@brazilinfo.com> wrote:

Hi

I need some help with PostgreSQL installation over RedHat

7.0.

I had a previously installed version of PostgreSQL server
(postgresql-server-7.0.2-17.i386.rpm). I had though a

problem

with the RPM install procedure, when the following

messages

were issued:

postgresql-server
##################################################
/sbin/ldconfig: Input file /usr/lib/libgck.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimp.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimpui.so not

found.

Is that problematic? In fact I started the postmaster and

have

tested accessing the database both with 'psql' remotely
through SSH as well as with phpPgAdmin via Web and it is
apparently functioning very well.

I have just downloaded the PostgreSQL v7.1 RPM
(postgresql-server-7.1beta4-1.i386.rpm). I first

de-installed

version postgresql-server-7.0.2-17 since I believe I

should

first have installed postgresql-7.0.2-17.i386.rpm instead.

I then tried to install version 7.0.2 (both files this

time)

and perform an upgrade to 7.1 but got the following
dependencies problems:

[root@atlas PostgreSQL]# rpm -ivh

postgresql-7.0.2-17.i386.rpm

postgresql
##################################################
/sbin/ldconfig: Input file /usr/lib/libgck.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimp.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimpui.so not

found.

[root@atlas PostgreSQL]# rpm -ivh
postgresql-server-7.0.2-17.i386.rpm
postgresql-server
##################################################
/sbin/ldconfig: Input file /usr/lib/libgck.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimp.so not found.
/sbin/ldconfig: Input file /usr/lib/libgimpui.so not

found.

[root@atlas PostgreSQL]# rpm -Uvh
postgresql-7.1beta4-1.i386.rpm
error: failed dependencies:
postgresql = 7.0.2 is needed by
postgresql-server-7.0.2-17
libpq.so.2.1 is needed by php-pgsql-4.0.1pl2-9
libpq.so.2.1 is needed by

postgresql-server-7.0.2-17

[root@atlas PostgreSQL]# rpm -Uvh
postgresql-server-7.1beta4-1.i386.rpm
error: failed dependencies:
postgresql = 7.1beta4 is needed by
postgresql-server-7.1beta4-1
libpq.so.2 is needed by

postgresql-server-7.1beta4-1

[root@atlas PostgreSQL]# rpm -ivh

postgresql-7.0.2-17.i386.rpm

package postgresql-7.0.2-17 is already installed
[root@atlas PostgreSQL]# rpm -ivh
postgresql-server-7.0.2-17.i386.rpm
package postgresql-server-7.0.2-17 is already installed
[root@atlas PostgreSQL]#

Also strange is that when I issue the command to

de-install

the 7.0.2 RPMs the system issues messages stating that the
packages are not installed, although they are:

[root@atlas PostgreSQL]# rpm -e
postgresql-server-7.0.2-17.i386.rpm
error: package postgresql-server-7.0.2-17.i386.rpm is not
installed
[root@atlas PostgreSQL]# rpm -e

postgresql-7.0.2-17.i386.rpm

error: package postgresql-7.0.2-17.i386.rpm is not

installed

[root@atlas PostgreSQL]# rpm -ivh

postgresql-7.0.2-17.i386.rpm

package postgresql-7.0.2-17 is already installed
[root@atlas PostgreSQL]# rpm -ivh
postgresql-server-7.0.2-17.i386.rpm
package postgresql-server-7.0.2-17 is already installed

Any help would be greatly appreciated.

TIA,
Paulo

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices!

http://auctions.yahoo.com/

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/

On Thu, Feb 22, 2001 at 04:07:06PM -0300, Paulo Parola wrote:

[root@atlas PostgreSQL]# rpm -Uvh postgresql-7.1beta4-1.i386.rpm
error: failed dependencies:
postgresql = 7.0.2 is needed by postgresql-server-7.0.2-17
libpq.so.2.1 is needed by php-pgsql-4.0.1pl2-9
libpq.so.2.1 is needed by postgresql-server-7.0.2-17

[root@atlas PostgreSQL]# rpm -Uvh postgresql-server-7.1beta4-1.i386.rpm
error: failed dependencies:
postgresql = 7.1beta4 is needed by postgresql-server-7.1beta4-1
libpq.so.2 is needed by postgresql-server-7.1beta4-1

You have to specify both RPMs at once during the update:

rpm -Uvh postgresql-server-7.1beta4-1.i386.rpm postgresql-7.1beta4-1.i386.rpm

should do the trick, unless the beta-rpm does not provide a libpq.so.2.1 (at
least with a build from CVS libpq.so.2.1 is installed, so I guess rpm is
clever enough to provide this one as well). libpq.so.2 is just a symlink to
libpq.so.2.1

Regards
Mirko
--
mirko@picard.inka.de
http://sites.inka.de/picard/

Dear Mirko,

Thanks for the reply. I have now PostgreSQL7.1 installed, but need to
re-install package "php-pgsql-4.0.1pl2-9.i386.rpm". The installation
procedure reports me the following:

error: failed dependencies:
libpq.so.2.1 is needed by php-pgsql-4.0.1pl2-9

And I have found the following files to exist on our system:

[root@atlas PostgreSQL]# find /usr -name "libpq.so.*"
/usr/lib/libpq.so.2
/usr/lib/libpq.so.2.0
/usr/lib/libpq.so.2.1

Should I make some sort of symlink or perhaps force installation of
php-pgsql package? Can anybody give me some clue of how to procceed?

TIA,
Paulo Parola
pparola@brazilinfo.com

----- Original Message -----
From: Mirko Zeibig <mirko@picard.inka.de>
To: <pgsql-general@postgresql.org>
Sent: Thursday, February 22, 2001 7:20 PM
Subject: Re: [GENERAL] PostgreSQL 7.1 Linux Installation

On Thu, Feb 22, 2001 at 04:07:06PM -0300, Paulo Parola wrote:

[root@atlas PostgreSQL]# rpm -Uvh postgresql-7.1beta4-1.i386.rpm
error: failed dependencies:
postgresql = 7.0.2 is needed by postgresql-server-7.0.2-17
libpq.so.2.1 is needed by php-pgsql-4.0.1pl2-9
libpq.so.2.1 is needed by postgresql-server-7.0.2-17

[root@atlas PostgreSQL]# rpm -Uvh postgresql-server-7.1beta4-1.i386.rpm
error: failed dependencies:
postgresql = 7.1beta4 is needed by postgresql-server-7.1beta4-1
libpq.so.2 is needed by postgresql-server-7.1beta4-1

You have to specify both RPMs at once during the update:

rpm -Uvh postgresql-server-7.1beta4-1.i386.rpm

postgresql-7.1beta4-1.i386.rpm

should do the trick, unless the beta-rpm does not provide a libpq.so.2.1

(at

least with a build from CVS libpq.so.2.1 is installed, so I guess rpm is
clever enough to provide this one as well). libpq.so.2 is just a symlink

to