pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
upgrading
4+ messages / 4 participants
[nested] [flat]

* upgrading
@ 2000-08-29 20:06 Robert Kernell <kernell@sundog.larc.nasa.gov>
  0 siblings, 0 replies; 4+ messages in thread

From: Robert Kernell @ 2000-08-29 20:06 UTC (permalink / raw)
  To: pgsql-admin

Hi. I am new to a job and am overseeing a postgres system. I will probably have 
to upgrade sometime. Where can I find step-by-step instructions on how to do 
this?

Thanx!

Bob Kernell
Research Scientist
AS&M
email: kernell@sundog.larc.nasa.gov




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Upgrading
@ 2004-03-04 19:15 Indibil <indibil@webmail.co.za>
  2004-03-08 19:45 ` Re: Upgrading scott.marlowe <scott.marlowe@ihs.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Indibil @ 2004-03-04 19:15 UTC (permalink / raw)
  To: pgsql-admin

Hi:

I have a PostgreSQL 7.2.2 running in a Linux Mandrake 8.2 Server.
I want to upgrade to PostgreSQL 7.3
I would like to accomplish this by installing  fit rpm packages, because my
linux skills are limited.
However, there aren't any packages of PostgreSQL 7.3 for Mandrake 8.2
I must be careful because the database is in a production environment.
What would be the best way to upgrade?

Thanks in advance,
Indibil




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Upgrading
  2004-03-04 19:15 Upgrading Indibil <indibil@webmail.co.za>
@ 2004-03-08 19:45 ` scott.marlowe <scott.marlowe@ihs.com>
  2004-03-09 07:18   ` Re: Upgrading Michiel Lange <michiel@minas.demon.nl>
  0 siblings, 1 reply; 4+ messages in thread

From: scott.marlowe @ 2004-03-08 19:45 UTC (permalink / raw)
  To: Indibil <indibil@webmail.co.za>; +Cc: pgsql-admin

On Thu, 4 Mar 2004, Indibil wrote:

> Hi:
> 
> I have a PostgreSQL 7.2.2 running in a Linux Mandrake 8.2 Server.
> I want to upgrade to PostgreSQL 7.3
> I would like to accomplish this by installing  fit rpm packages, because my
> linux skills are limited.
> However, there aren't any packages of PostgreSQL 7.3 for Mandrake 8.2
> I must be careful because the database is in a production environment.
> What would be the best way to upgrade?

Unless there is a known problem for you with 7.4, I'd recommend upgrading 
to that.  7.4.2 is due out soon (today or something like it) and it is 
a much easier upgrade than 7.2 to 7.3 was.  

You might want to upgrade to 7.2.5 first though, as there were some issues 
with early 7.2s upgrading to 7.4 I remember running into.

I don';t use RPMs for postgresql, so I'm not much help there.




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Upgrading
  2004-03-04 19:15 Upgrading Indibil <indibil@webmail.co.za>
  2004-03-08 19:45 ` Re: Upgrading scott.marlowe <scott.marlowe@ihs.com>
@ 2004-03-09 07:18   ` Michiel Lange <michiel@minas.demon.nl>
  0 siblings, 0 replies; 4+ messages in thread

From: Michiel Lange @ 2004-03-09 07:18 UTC (permalink / raw)
  To: pgsql-admin

I have ever used Slackware, so no rpm's for me... gives me some control 
on what to include and what not... but it learned me how to do compile 
stuff ;-)

Here is what I would do:
locate all Postgresql binaries. I suppose it's in /usr/bin
dump _all_ your data (maybe stopping the postmaster and making a 
filesystem backup is the most certain way to do this)
download postgres sources and 7.2.5 rpm
shutdown the postmaster
upgrade to 7.2.5 by rpm
start postmaster
dump _all_ your data if succesfull
look for any other configuration files and store them separately (there 
may be something in /etc and /etc/rc.d ...)
unpack 7.4 sources
./configure --help to see all the flags you can set
./configure <all your needed flags>
if succesfull: make
if succesfull: stop postmaster
uninstall postgres 7.2.5 with rpm
make install the sources
initdb
start postmaster
restore your data
check all config files and see if they're still the same, check 
/etc/rc.d startup stuff too (I honestly must say I have no idea how this 
is really implemented)
enjoy!

Mind: you can also do the following starting from the ./configure part, 
all that was to be done previously still applies:
stop postmaster
uninstall postgres 7.2.5 with rpm
./configure --with-all-your-flags && make && make install && initdb -D 
<bladidbla>
(make will only run if configure was succesfull, make install will only 
run when make was succesfull and so on)
If this is a first-timer, try this out on a non-critical system where 
everything may fail! If it's not a first-timer you might still want to 
do that, since one easily forgets a flag or two or makes a slight mistake.
Storing all your commands in a shell-script makes it easier to do 
exactly the same stuff on another machine...

Hope it helps...

Michiel


scott.marlowe wrote:

>On Thu, 4 Mar 2004, Indibil wrote:
>
>  
>
>>Hi:
>>
>>I have a PostgreSQL 7.2.2 running in a Linux Mandrake 8.2 Server.
>>I want to upgrade to PostgreSQL 7.3
>>I would like to accomplish this by installing  fit rpm packages, because my
>>linux skills are limited.
>>However, there aren't any packages of PostgreSQL 7.3 for Mandrake 8.2
>>I must be careful because the database is in a production environment.
>>What would be the best way to upgrade?
>>    
>>
>
>Unless there is a known problem for you with 7.4, I'd recommend upgrading 
>to that.  7.4.2 is due out soon (today or something like it) and it is 
>a much easier upgrade than 7.2 to 7.3 was.  
>
>You might want to upgrade to 7.2.5 first though, as there were some issues 
>with early 7.2s upgrading to 7.4 I remember running into.
>
>I don';t use RPMs for postgresql, so I'm not much help there.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>  
>




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-03-09 07:18 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-08-29 20:06 upgrading Robert Kernell <kernell@sundog.larc.nasa.gov>
2004-03-04 19:15 Upgrading Indibil <indibil@webmail.co.za>
2004-03-08 19:45 ` Re: Upgrading scott.marlowe <scott.marlowe@ihs.com>
2004-03-09 07:18   ` Re: Upgrading Michiel Lange <michiel@minas.demon.nl>

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