pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgresql Upgrade 7.4 to 8.2
9+ messages / 7 participants
[nested] [flat]

* Postgresql Upgrade 7.4 to 8.2
@ 2007-01-24 14:35 Radhika Sambamurti <radhika@88thstreet.com>
  2007-01-24 15:39 ` Re: Postgresql Upgrade 7.4 to 8.2 Milen A. Radev <milen@radev.net>
  2007-01-24 16:03 ` Re: Postgresql Upgrade 7.4 to 8.2 Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 2 replies; 9+ messages in thread

From: Radhika Sambamurti @ 2007-01-24 14:35 UTC (permalink / raw)
  To: pgsql-admin

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
---




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

* Re: Postgresql Upgrade 7.4 to 8.2
  2007-01-24 14:35 Postgresql Upgrade 7.4 to 8.2 Radhika Sambamurti <radhika@88thstreet.com>
@ 2007-01-24 15:39 ` Milen A. Radev <milen@radev.net>
  1 sibling, 0 replies; 9+ messages in thread

From: Milen A. Radev @ 2007-01-24 15:39 UTC (permalink / raw)
  To: pgsql-admin; +Cc: pgsql-admin

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




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

* Re: Postgresql Upgrade 7.4 to 8.2
  2007-01-24 14:35 Postgresql Upgrade 7.4 to 8.2 Radhika Sambamurti <radhika@88thstreet.com>
@ 2007-01-24 16:03 ` Peter Eisentraut <peter_e@gmx.net>
  2007-01-24 17:11   ` Re: Postgresql Upgrade 7.4 to 8.2 Joshua D. Drake <jd@commandprompt.com>
  1 sibling, 1 reply; 9+ messages in thread

From: Peter Eisentraut @ 2007-01-24 16:03 UTC (permalink / raw)
  To: pgsql-admin; radhika@88thstreet.com

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/



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

* Re: Postgresql Upgrade 7.4 to 8.2
  2007-01-24 14:35 Postgresql Upgrade 7.4 to 8.2 Radhika Sambamurti <radhika@88thstreet.com>
  2007-01-24 16:03 ` Re: Postgresql Upgrade 7.4 to 8.2 Peter Eisentraut <peter_e@gmx.net>
@ 2007-01-24 17:11   ` Joshua D. Drake <jd@commandprompt.com>
  2007-02-13 22:05     ` Re: Postgresql Upgrade 7.4 to 8.2 Zach Bagnall <zach.bagnall@bulletinwireless.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Joshua D. Drake @ 2007-01-24 17:11 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin; radhika@88thstreet.com

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/




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

* Re: Postgresql Upgrade 7.4 to 8.2
  2007-01-24 14:35 Postgresql Upgrade 7.4 to 8.2 Radhika Sambamurti <radhika@88thstreet.com>
  2007-01-24 16:03 ` Re: Postgresql Upgrade 7.4 to 8.2 Peter Eisentraut <peter_e@gmx.net>
  2007-01-24 17:11   ` Re: Postgresql Upgrade 7.4 to 8.2 Joshua D. Drake <jd@commandprompt.com>
@ 2007-02-13 22:05     ` Zach Bagnall <zach.bagnall@bulletinwireless.com>
  2007-02-14 01:12       ` Re: Postgresql Upgrade 7.4 to 8.2 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 9+ messages in thread

From: Zach Bagnall @ 2007-02-13 22:05 UTC (permalink / raw)
  To: pgsql-admin; +Cc: Joshua D. Drake <jd@commandprompt.com>; Peter Eisentraut <peter_e@gmx.net>; radhika@88thstreet.com

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.



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

* Re: Postgresql Upgrade 7.4 to 8.2
  2007-01-24 14:35 Postgresql Upgrade 7.4 to 8.2 Radhika Sambamurti <radhika@88thstreet.com>
  2007-01-24 16:03 ` Re: Postgresql Upgrade 7.4 to 8.2 Peter Eisentraut <peter_e@gmx.net>
  2007-01-24 17:11   ` Re: Postgresql Upgrade 7.4 to 8.2 Joshua D. Drake <jd@commandprompt.com>
  2007-02-13 22:05     ` Re: Postgresql Upgrade 7.4 to 8.2 Zach Bagnall <zach.bagnall@bulletinwireless.com>
@ 2007-02-14 01:12       ` Tom Lane <tgl@sss.pgh.pa.us>
  2007-02-14 03:00         ` Re: Postgresql Upgrade 7.4 to 8.2 Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Tom Lane @ 2007-02-14 01:12 UTC (permalink / raw)
  To: Zach Bagnall <zach.bagnall@bulletinwireless.com>; +Cc: pgsql-admin@postgresql.org, "Joshua D. Drake" <jd@commandprompt.com>; Peter Eisentraut <peter_e@gmx.net>; radhika@88thstreet.com

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



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

* Re: Postgresql Upgrade 7.4 to 8.2
  2007-01-24 14:35 Postgresql Upgrade 7.4 to 8.2 Radhika Sambamurti <radhika@88thstreet.com>
  2007-01-24 16:03 ` Re: Postgresql Upgrade 7.4 to 8.2 Peter Eisentraut <peter_e@gmx.net>
  2007-01-24 17:11   ` Re: Postgresql Upgrade 7.4 to 8.2 Joshua D. Drake <jd@commandprompt.com>
  2007-02-13 22:05     ` Re: Postgresql Upgrade 7.4 to 8.2 Zach Bagnall <zach.bagnall@bulletinwireless.com>
  2007-02-14 01:12       ` Re: Postgresql Upgrade 7.4 to 8.2 Tom Lane <tgl@sss.pgh.pa.us>
@ 2007-02-14 03:00         ` Joshua D. Drake <jd@commandprompt.com>
  2007-02-14 03:26           ` Re: Postgresql Upgrade 7.4 to 8.2 Zach Bagnall <zach.bagnall@bulletinwireless.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Joshua D. Drake @ 2007-02-14 03:00 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Zach Bagnall <zach.bagnall@bulletinwireless.com>; pgsql-admin@postgresql.org, Peter Eisentraut <peter_e@gmx.net>; radhika@88thstreet.com

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/




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

* Re: Postgresql Upgrade 7.4 to 8.2
  2007-01-24 14:35 Postgresql Upgrade 7.4 to 8.2 Radhika Sambamurti <radhika@88thstreet.com>
  2007-01-24 16:03 ` Re: Postgresql Upgrade 7.4 to 8.2 Peter Eisentraut <peter_e@gmx.net>
  2007-01-24 17:11   ` Re: Postgresql Upgrade 7.4 to 8.2 Joshua D. Drake <jd@commandprompt.com>
  2007-02-13 22:05     ` Re: Postgresql Upgrade 7.4 to 8.2 Zach Bagnall <zach.bagnall@bulletinwireless.com>
  2007-02-14 01:12       ` Re: Postgresql Upgrade 7.4 to 8.2 Tom Lane <tgl@sss.pgh.pa.us>
  2007-02-14 03:00         ` Re: Postgresql Upgrade 7.4 to 8.2 Joshua D. Drake <jd@commandprompt.com>
@ 2007-02-14 03:26           ` Zach Bagnall <zach.bagnall@bulletinwireless.com>
  0 siblings, 0 replies; 9+ messages in thread

From: Zach Bagnall @ 2007-02-14 03:26 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-admin@postgresql.org, Peter Eisentraut <peter_e@gmx.net>; radhika@88thstreet.com

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..



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

* Re: Postgresql Upgrade 7.4 to 8.2
@ 2007-01-24 14:57 Matthias.Pitzl@izb.de
  0 siblings, 0 replies; 9+ messages in thread

From: Matthias.Pitzl@izb.de @ 2007-01-24 14:57 UTC (permalink / raw)
  To: radhika@88thstreet.com; pgsql-admin

> 
> 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



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


end of thread, other threads:[~2007-02-14 03:26 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-24 14:35 Postgresql Upgrade 7.4 to 8.2 Radhika Sambamurti <radhika@88thstreet.com>
2007-01-24 15:39 ` Milen A. Radev <milen@radev.net>
2007-01-24 16:03 ` Peter Eisentraut <peter_e@gmx.net>
2007-01-24 17:11   ` Joshua D. Drake <jd@commandprompt.com>
2007-02-13 22:05     ` Zach Bagnall <zach.bagnall@bulletinwireless.com>
2007-02-14 01:12       ` Tom Lane <tgl@sss.pgh.pa.us>
2007-02-14 03:00         ` Joshua D. Drake <jd@commandprompt.com>
2007-02-14 03:26           ` Zach Bagnall <zach.bagnall@bulletinwireless.com>
2007-01-24 14:57 Re: Postgresql Upgrade 7.4 to 8.2 Matthias.Pitzl@izb.de

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