Thread: Postgresql Upgrade 7.4 to 8.2

Postgresql Upgrade 7.4 to 8.2

From
"Radhika Sambamurti"
Date:
Hi,

I am soon going to be testing postgresql upgrades from our ancient 7.4
version to the latest 8.2.
Part of the reason (apart from the obvious) is that I want to implement
WAL logging for backup and recovery.

Some general questions I have are:
1. How is the backup and recovery using WAL logging in 8.2
Currently we use Slony for replication, but have no PITR / backup in
place, which makes me very nervous.

Any insights on upgrading will also help.

Thank you,
Radhika


--
It is all a matter of perspective. You choose your view by choosing where
to stand.
Larry Wall
---


Re: Postgresql Upgrade 7.4 to 8.2

From
Matthias.Pitzl@izb.de
Date:
>
> Any insights on upgrading will also help.
>
> Thank you,
> Radhika
>

Hello!

About upgrading you should read these links:
http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html and
http://www.postgresql.org/docs/8.2/interactive/migration.html

Greetings,
Matthias

Re: Postgresql Upgrade 7.4 to 8.2

From
"Milen A. Radev"
Date:
Radhika Sambamurti написа:
[...]
> Some general questions I have are:
> 1. How is the backup and recovery using WAL logging in 8.2
> Currently we use Slony for replication, but have no PITR / backup in
> place, which makes me very nervous.
[...]

Also these:

http://www.postgresql.org/docs/8.2/static/continuous-archiving.html
http://www.postgresql.org/docs/8.2/static/warm-standby.html


--
Milen A. Radev

Re: Postgresql Upgrade 7.4 to 8.2

From
Peter Eisentraut
Date:
Radhika Sambamurti wrote:
> 1. How is the backup and recovery using WAL logging in 8.2

It's great!

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: Postgresql Upgrade 7.4 to 8.2

From
"Joshua D. Drake"
Date:
Peter Eisentraut wrote:
> Radhika Sambamurti wrote:
>> 1. How is the backup and recovery using WAL logging in 8.2
>
> It's great!
>

Less filling!

Seriously though, the PITR recovery mechanism is quite mature and usable.

Sincerely,

Joshua D. Drake

--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


Re: Postgresql Upgrade 7.4 to 8.2

From
Zach Bagnall
Date:
On 01/25/07 06:11, Joshua D. Drake wrote:
> Peter Eisentraut wrote:
>> Radhika Sambamurti wrote:
>>> 1. How is the backup and recovery using WAL logging in 8.2
 >>
>> It's great!
>
> Less filling!
>
> Seriously though, the PITR recovery mechanism is quite mature and usable.

I would say it is a good start - and progress is clearly being made. But
it wont be "usable" for most serious applications until we have
per-database transaction logging and backup recovery. Having to run a
new instance (or obliterate the main instance) for recovery simply isn't
practical.

Re: Postgresql Upgrade 7.4 to 8.2

From
Tom Lane
Date:
Zach Bagnall <zach.bagnall@bulletinwireless.com> writes:
>> Seriously though, the PITR recovery mechanism is quite mature and usable.

> I would say it is a good start - and progress is clearly being made. But
> it wont be "usable" for most serious applications until we have
> per-database transaction logging and backup recovery.

Don't hold your breath; that's not even on the agenda, much less
something that's likely to appear soon.  If you need separable recovery
then run a different postmaster instance for each database.

            regards, tom lane

Re: Postgresql Upgrade 7.4 to 8.2

From
"Joshua D. Drake"
Date:
Tom Lane wrote:
> Zach Bagnall <zach.bagnall@bulletinwireless.com> writes:
>>> Seriously though, the PITR recovery mechanism is quite mature and usable.
>
>> I would say it is a good start - and progress is clearly being made. But
>> it wont be "usable" for most serious applications until we have
>> per-database transaction logging and backup recovery.
>
> Don't hold your breath; that's not even on the agenda, much less
> something that's likely to appear soon.  If you need separable recovery
> then run a different postmaster instance for each database.

I would have to concur... if you need such a feature I would wonder why
you are running multiple databases within the same cluster at all.

Joshua D. Drake


>
>             regards, tom lane
>


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


Re: Postgresql Upgrade 7.4 to 8.2

From
Zach Bagnall
Date:
On 02/14/07 16:00, Joshua D. Drake wrote:
> Tom Lane wrote:
>> Zach Bagnall <zach.bagnall@bulletinwireless.com> writes:
>>>> Seriously though, the PITR recovery mechanism is quite mature and usable.
>>> I would say it is a good start - and progress is clearly being made. But
>>> it wont be "usable" for most serious applications until we have
>>> per-database transaction logging and backup recovery.
>
>> Don't hold your breath; that's not even on the agenda, much less
>> something that's likely to appear soon.  If you need separable recovery
>> then run a different postmaster instance for each database.
>
> I would have to concur... if you need such a feature I would wonder why
> you are running multiple databases within the same cluster at all.

It's not exactly an exotic feature. Sybase has had it for as long as I
can remember, as has Informix and DB2 (I'm told).

The obvious reason for not running multiple instances is that postgresql
will know how to use the available memory most efficiently. By splitting
them up, each postmaster must be tuned and adjusted by a stupid human.

Unless you meant using a new hardware server for each database..