Re: PostgreSQL 7.1 Linux Installation

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/