pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql 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>
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: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
* Re: Postgresql Upgrade 7.4 to 8.2
@ 2007-01-24 15:39 Milen A. Radev <milen@radev.net>
parent: Radhika Sambamurti <radhika@88thstreet.com>
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 16:03 Peter Eisentraut <peter_e@gmx.net>
parent: Radhika Sambamurti <radhika@88thstreet.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 17:11 Joshua D. Drake <jd@commandprompt.com>
parent: Peter Eisentraut <peter_e@gmx.net>
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-02-13 22:05 Zach Bagnall <zach.bagnall@bulletinwireless.com>
parent: Joshua D. Drake <jd@commandprompt.com>
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-02-14 01:12 Tom Lane <tgl@sss.pgh.pa.us>
parent: Zach Bagnall <zach.bagnall@bulletinwireless.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-02-14 03:00 Joshua D. Drake <jd@commandprompt.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
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-02-14 03:26 Zach Bagnall <zach.bagnall@bulletinwireless.com>
parent: Joshua D. Drake <jd@commandprompt.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
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