Обсуждение: Postgresql Upgrade 7.4 to 8.2
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 ---
> > 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
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
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/
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/
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.
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
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/
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..