Re: PostgreSQL 7.1 Linux Installation

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/
>