Thread: 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
> libpq.so.2.1
>
> Regards
> Mirko
> --
> mirko@picard.inka.de
> http://sites.inka.de/picard/
>