pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andy Shellam <andy.shellam@mailnetwork.co.uk>
To: Moritz Bayer <moritz.bayer@googlemail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Deinstallation
Date: Thu, 23 Feb 2006 23:23:42 +0000
Message-ID: <43FE43FE.8030305@mailnetwork.co.uk> (raw)
In-Reply-To: <c244500b0602230852k3d6ee9bby@mail.gmail.com>
References: <c244500b0602230818h455721dfi@mail.gmail.com>
	<43FDE2B2.2040203@andycc.net>
	<c244500b0602230852k3d6ee9bby@mail.gmail.com>

Moritz,

The only problem you'll have with regard to configuration issues, is 
your local applications might try connecting using the 7.4 client 
libraries as opposed to the 8.1, however if you didn't add a --prefix 
option to your configure, it should overwrite the old libraries with the 
new references (not sure if this is definitely true or not.)

All your Postgres configuration files will be inside your data directory 
(created with initdb).  When upgrading from a major version (i.e. 7 to 
8) you need to dump the contents of your database from the 7.4 server 
FIRST using pg_dump BEFORE YOU KILL YOUR OLD SERVER - then when you're 
up with 8.1, use pg_restore.  I found this out the hard way!!

It is always best to avoid version conflicts.  If I were you, I would do 
the following:

1. With your 7.4 server running, dump your databases using pg_dump or 
pg_dumpall
2. Kill your 7.4 server and take a backup of your data directory (e.g. 
mv /path/to/pg_data /path/to/pg_data.OLD
3. Remove your PGSQL 8.1.3 install (cd into the source directory and do 
'make uninstall')
4. Install Yum (download RPM for your linux distro from 
http://rpmseek.com/rpm-pl/yum.html?hl=com&cs=yum:PN:0:0:0:0)
5. Use 'yum remove postgresql' to get rid of 7.4
6. Re-install your PGSQL 8.1.3 install (cd into the source directory and 
do 'make install')
7. initdb a new data directory (DON'T use your old one) and configure 
your 8.1 server
8. Start up your 8.1 server
9. Restore your dump using pg_restore
10. Configure user access in pg_hba.conf

The reason I've said to remove the PG 8.1.3 install first is that when 
removing 7.4, it might inadvertently remove the 8.1.3 libraries as well 
(if they've taken over the 7.4 ones.)

Note I've confirmed on Redhat Fedora the package is called "postgresql" 
- which is v7.4.

Regards

Andy

Moritz Bayer wrote:
> Hi Andy,
>  
> I guess I can call you my teacher pretty soon :-)
> Yes, the installation worked fine, the configuration isn't done yet. 
> I've the feeling, that there are some conflicts with the old version,
> although I followed the installation-procedere defined in the 
> INSTALL-file of the source-package and also from the book "Beginning 
> Database with PostgreSQL" from Neil Matthew.
>  
> So I want to get rid of the old version and start the configuration again.
> Now the System has neither apt-get nor yum installed. Do you have the 
> rpm or source to get both/either of one?
>  
> Thank you again,
> Moritz
>




view thread (3+ messages)

Message-ID: <43FE43FE.8030305@mailnetwork.co.uk>
Permalink:  ../43FE43FE.8030305@mailnetwork.co.uk/
Also on:    postgresql.org/message-id/43FE43FE.8030305@mailnetwork.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: andy.shellam@mailnetwork.co.uk, moritz.bayer@googlemail.com
  Subject: Re: Deinstallation
  In-Reply-To: <43FE43FE.8030305@mailnetwork.co.uk>
  References: <c244500b0602230818h455721dfi@mail.gmail.com> <43FDE2B2.2040203@andycc.net> <c244500b0602230852k3d6ee9bby@mail.gmail.com> <43FE43FE.8030305@mailnetwork.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox