pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrade in same major version
7+ messages / 4 participants
[nested] [flat]
* Upgrade in same major version
@ 2008-10-14 16:41 Carol Walter <walterc@indiana.edu>
2008-10-14 17:18 ` Re: Upgrade in same major version Evan Rempel <erempel@uvic.ca>
2008-10-14 17:21 ` Re: Upgrade in same major version Evan Rempel <erempel@uvic.ca>
2008-10-14 17:22 ` Re: Upgrade in same major version Evan Rempel <erempel@uvic.ca>
0 siblings, 3 replies; 7+ messages in thread
From: Carol Walter @ 2008-10-14 16:41 UTC (permalink / raw)
To: pgsql-admin
Hello,
I'm doing an upgrade from 8.2.4 to 8.2.10. The documentation says,
"When you update between compatible versions, you can simply replace
the executables and reuse the data directory on disk." I guess I
don't quite understand what this means. Replace them by running some
parts of the installation process? Replace them by copying them.
Are you talking about those files that usually reside in /usr/local/
pgsql/bin and include psql and pg_ctl?
I know these may seem like dumb questions to those of you who are old
hands at this. I'd be glad to read more documentation if there is
some that is more explicit than what I quoted above.
Thanks so much,
Carol
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Upgrade in same major version
2008-10-14 16:41 Upgrade in same major version Carol Walter <walterc@indiana.edu>
@ 2008-10-14 17:18 ` Evan Rempel <erempel@uvic.ca>
2008-10-14 17:24 ` Re: Upgrade in same major version Alvaro Herrera <alvherre@commandprompt.com>
2 siblings, 1 reply; 7+ messages in thread
From: Evan Rempel @ 2008-10-14 17:18 UTC (permalink / raw)
To: pgsql-admin
What this means is that you do not have to "update" the data repository (wherever your
postgresql database is stored). All that needs to be done is to uninstall the old version,
and install the new version. Start the new version and use the data where it sits.
Now, that all sound fine when I say it fast. There are a number of precautions that
you may prefer to take, and the steps may differ significantly depending on your system.
1. Probably take a complete backup of your database should something go wrong.
2. Ensure that you have a way to "get back" to the previous version, or have
a very reliable way to move forward, such as taking a pgdump that can be loaded
back into the database, nearly regardless of version.
3. Your uninstall may be a package management step such as rpm, or you may
just delete the files if your install was done from source.
4. Your install may be a package management step such as rpm, or you may
require a "sudo make install" if your install was done from source.
I hope this points you in mostly the right direction without begin to long
winded.
Evan.
Carol Walter wrote:
> Hello,
>
> I'm doing an upgrade from 8.2.4 to 8.2.10. The documentation says,
> "When you update between compatible versions, you can simply replace
> the executables and reuse the data directory on disk." I guess I
> don't quite understand what this means. Replace them by running some
> parts of the installation process? Replace them by copying them.
> Are you talking about those files that usually reside in /usr/local/
> pgsql/bin and include psql and pg_ctl?
>
> I know these may seem like dumb questions to those of you who are old
> hands at this. I'd be glad to read more documentation if there is
> some that is more explicit than what I quoted above.
>
> Thanks so much,
>
> Carol
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
--
Evan Rempel erempel@uvic.ca
Senior Programmer Analyst 250.721.7691
University Systems, University of Victoria
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Upgrade in same major version
2008-10-14 16:41 Upgrade in same major version Carol Walter <walterc@indiana.edu>
2008-10-14 17:18 ` Re: Upgrade in same major version Evan Rempel <erempel@uvic.ca>
@ 2008-10-14 17:24 ` Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 0 replies; 7+ messages in thread
From: Alvaro Herrera @ 2008-10-14 17:24 UTC (permalink / raw)
To: Evan Rempel <erempel@uvic.ca>; +Cc: pgsql-admin
Evan Rempel wrote:
> What this means is that you do not have to "update" the data repository (wherever your
> postgresql database is stored). All that needs to be done is to uninstall the old version,
> and install the new version. Start the new version and use the data where it sits.
Actually you don't need to uninstall the old version or delete the
files; a simple "make install" will overwrite them with the new copies,
if you install from source. If you install from RPM or other package
methods, the "upgrade" operation should overwrite the files.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Upgrade in same major version
2008-10-14 16:41 Upgrade in same major version Carol Walter <walterc@indiana.edu>
@ 2008-10-14 17:21 ` Evan Rempel <erempel@uvic.ca>
2 siblings, 0 replies; 7+ messages in thread
From: Evan Rempel @ 2008-10-14 17:21 UTC (permalink / raw)
To: pgsql-admin
What this means is that you do not have to "update" the data repository (wherever your
postgresql database is stored). All that needs to be done is to uninstall the old version,
and install the new version. Start the new version and use the data where it sits.
Now, that all sound fine when I say it fast. There are a number of precautions that
you may prefer to take, and the steps may differ significantly depending on your system.
1. Probably take a complete backup of your database should something go wrong.
2. Ensure that you have a way to "get back" to the previous version, or have
a very reliable way to move forward, such as taking a pgdump that can be loaded
back into the database, nearly regardless of version.
3. Your uninstall may be a package management step such as rpm, or you may
just delete the files if your install was done from source.
4. Your install may be a package management step such as rpm, or you may
require a "sudo make install" if your install was done from source.
I hope this points you in mostly the right direction without begin to long
winded.
Evan.
Carol Walter wrote:
> Hello,
>
> I'm doing an upgrade from 8.2.4 to 8.2.10. The documentation says,
> "When you update between compatible versions, you can simply replace
> the executables and reuse the data directory on disk." I guess I
> don't quite understand what this means. Replace them by running some
> parts of the installation process? Replace them by copying them.
> Are you talking about those files that usually reside in /usr/local/
> pgsql/bin and include psql and pg_ctl?
>
> I know these may seem like dumb questions to those of you who are old
> hands at this. I'd be glad to read more documentation if there is
> some that is more explicit than what I quoted above.
>
> Thanks so much,
>
> Carol
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
--
Evan Rempel erempel@uvic.ca
Senior Programmer Analyst 250.721.7691
University Systems, University of Victoria
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Upgrade in same major version
2008-10-14 16:41 Upgrade in same major version Carol Walter <walterc@indiana.edu>
@ 2008-10-14 17:22 ` Evan Rempel <erempel@uvic.ca>
2008-10-16 13:47 ` Re: Upgrade in same major version Carol Walter <walterc@indiana.edu>
2 siblings, 1 reply; 7+ messages in thread
From: Evan Rempel @ 2008-10-14 17:22 UTC (permalink / raw)
To: pgsql-admin
What this means is that you do not have to "update" the data repository (wherever your
postgresql database is stored). All that needs to be done is to uninstall the old version,
and install the new version. Start the new version and use the data where it sits.
Now, that all sound fine when I say it fast. There are a number of precautions that
you may prefer to take, and the steps may differ significantly depending on your system.
1. Probably take a complete backup of your database should something go wrong.
2. Ensure that you have a way to "get back" to the previous version, or have
a very reliable way to move forward, such as taking a pgdump that can be loaded
back into the database, nearly regardless of version.
3. Your uninstall may be a package management step such as rpm, or you may
just delete the files if your install was done from source.
4. Your install may be a package management step such as rpm, or you may
require a "sudo make install" if your install was done from source.
I hope this points you in mostly the right direction without begin to long
winded.
Evan.
Carol Walter wrote:
> Hello,
>
> I'm doing an upgrade from 8.2.4 to 8.2.10. The documentation says,
> "When you update between compatible versions, you can simply replace
> the executables and reuse the data directory on disk." I guess I
> don't quite understand what this means. Replace them by running some
> parts of the installation process? Replace them by copying them.
> Are you talking about those files that usually reside in /usr/local/
> pgsql/bin and include psql and pg_ctl?
>
> I know these may seem like dumb questions to those of you who are old
> hands at this. I'd be glad to read more documentation if there is
> some that is more explicit than what I quoted above.
>
> Thanks so much,
>
> Carol
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
--
Evan Rempel erempel@uvic.ca
Senior Programmer Analyst 250.721.7691
University Systems, University of Victoria
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Upgrade in same major version
2008-10-14 16:41 Upgrade in same major version Carol Walter <walterc@indiana.edu>
2008-10-14 17:22 ` Re: Upgrade in same major version Evan Rempel <erempel@uvic.ca>
@ 2008-10-16 13:47 ` Carol Walter <walterc@indiana.edu>
2008-10-16 14:29 ` Re: Upgrade in same major version Tim Bruce - Postgres <postgres@tbruce.com>
0 siblings, 1 reply; 7+ messages in thread
From: Carol Walter @ 2008-10-16 13:47 UTC (permalink / raw)
To: Evan Rempel <erempel@uvic.ca>; +Cc: pgsql-admin
Let me see if I understand this correctly.
Always do a backup before doing any destructive sys admin functions. =)
First, I run configure, taking care to make sure all the options point
to the right places.
Second, I run gmake
Third, I run gmake install.
Thanks,
Carol
On Oct 14, 2008, at 1:22 PM, Evan Rempel wrote:
> What this means is that you do not have to "update" the data
> repository (wherever your
> postgresql database is stored). All that needs to be done is to
> uninstall the old version,
> and install the new version. Start the new version and use the data
> where it sits.
>
> Now, that all sound fine when I say it fast. There are a number of
> precautions that
> you may prefer to take, and the steps may differ significantly
> depending on your system.
>
> 1. Probably take a complete backup of your database should something
> go wrong.
> 2. Ensure that you have a way to "get back" to the previous version,
> or have
> a very reliable way to move forward, such as taking a pgdump
> that can be loaded
> back into the database, nearly regardless of version.
> 3. Your uninstall may be a package management step such as rpm, or
> you may
> just delete the files if your install was done from source.
> 4. Your install may be a package management step such as rpm, or you
> may
> require a "sudo make install" if your install was done from
> source.
>
> I hope this points you in mostly the right direction without begin
> to long
> winded.
>
> Evan.
>
> Carol Walter wrote:
>> Hello,
>>
>> I'm doing an upgrade from 8.2.4 to 8.2.10. The documentation says,
>> "When you update between compatible versions, you can simply replace
>> the executables and reuse the data directory on disk." I guess I
>> don't quite understand what this means. Replace them by running some
>> parts of the installation process? Replace them by copying them.
>> Are you talking about those files that usually reside in /usr/local/
>> pgsql/bin and include psql and pg_ctl?
>>
>> I know these may seem like dumb questions to those of you who are old
>> hands at this. I'd be glad to read more documentation if there is
>> some that is more explicit than what I quoted above.
>>
>> Thanks so much,
>>
>> Carol
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>
> --
> Evan Rempel erempel@uvic.ca
> Senior Programmer Analyst 250.721.7691
> University Systems, University of Victoria
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Upgrade in same major version
2008-10-14 16:41 Upgrade in same major version Carol Walter <walterc@indiana.edu>
2008-10-14 17:22 ` Re: Upgrade in same major version Evan Rempel <erempel@uvic.ca>
2008-10-16 13:47 ` Re: Upgrade in same major version Carol Walter <walterc@indiana.edu>
@ 2008-10-16 14:29 ` Tim Bruce - Postgres <postgres@tbruce.com>
0 siblings, 0 replies; 7+ messages in thread
From: Tim Bruce - Postgres @ 2008-10-16 14:29 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: Evan Rempel <erempel@uvic.ca>; pgsql-admin
On Thu, October 16, 2008 06:47, Carol Walter wrote:
> Let me see if I understand this correctly.
> Always do a backup before doing any destructive sys admin functions. =)
> First, I run configure, taking care to make sure all the options point
> to the right places.
> Second, I run gmake
> Third, I run gmake install.
>
> Thanks,
> Carol
>
> On Oct 14, 2008, at 1:22 PM, Evan Rempel wrote:
>
>> What this means is that you do not have to "update" the data
>> repository (wherever your
>> postgresql database is stored). All that needs to be done is to
>> uninstall the old version,
>> and install the new version. Start the new version and use the data
>> where it sits.
>>
>> Now, that all sound fine when I say it fast. There are a number of
>> precautions that
>> you may prefer to take, and the steps may differ significantly
>> depending on your system.
>>
>> 1. Probably take a complete backup of your database should something
>> go wrong.
>> 2. Ensure that you have a way to "get back" to the previous version,
>> or have
>> a very reliable way to move forward, such as taking a pgdump
>> that can be loaded
>> back into the database, nearly regardless of version.
>> 3. Your uninstall may be a package management step such as rpm, or
>> you may
>> just delete the files if your install was done from source.
>> 4. Your install may be a package management step such as rpm, or you
>> may
>> require a "sudo make install" if your install was done from
>> source.
>>
>> I hope this points you in mostly the right direction without begin
>> to long
>> winded.
>>
>> Evan.
>>
>> Carol Walter wrote:
>>> Hello,
>>>
>>> I'm doing an upgrade from 8.2.4 to 8.2.10. The documentation says,
>>> "When you update between compatible versions, you can simply replace
>>> the executables and reuse the data directory on disk." I guess I
>>> don't quite understand what this means. Replace them by running some
>>> parts of the installation process? Replace them by copying them.
>>> Are you talking about those files that usually reside in /usr/local/
>>> pgsql/bin and include psql and pg_ctl?
>>>
>>> I know these may seem like dumb questions to those of you who are old
>>> hands at this. I'd be glad to read more documentation if there is
>>> some that is more explicit than what I quoted above.
>>>
>>> Thanks so much,
>>>
>>> Carol
>>>
>>> --
>>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>>
>> --
>> Evan Rempel erempel@uvic.ca
>> Senior Programmer Analyst 250.721.7691
>> University Systems, University of Victoria
>>
>>
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
As part of your backup, make sure you also backup your postgresql.conf and
pg_hba.conf if they are in your data directory. These are done at the
Operating System level using the cp (copy) command. They shouldn't be
overwritten, but having a backup copy of those is always nice for when
Murphy strikes.
Tim
--
Timothy J. Bruce
visit my Website at: http://www.tbruce.com
Registered Linux User #325725
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2008-10-16 14:29 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-10-14 16:41 Upgrade in same major version Carol Walter <walterc@indiana.edu>
2008-10-14 17:18 ` Evan Rempel <erempel@uvic.ca>
2008-10-14 17:24 ` Alvaro Herrera <alvherre@commandprompt.com>
2008-10-14 17:21 ` Evan Rempel <erempel@uvic.ca>
2008-10-14 17:22 ` Evan Rempel <erempel@uvic.ca>
2008-10-16 13:47 ` Carol Walter <walterc@indiana.edu>
2008-10-16 14:29 ` Tim Bruce - Postgres <postgres@tbruce.com>
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