pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedupgrading
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