Re: [ADMIN] Postgresql Upgrade 7.4 to 8.2

2007-02-13 Thread Zach Bagnall
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 -

Re: [ADMIN] Postgresql Upgrade 7.4 to 8.2

2007-02-13 Thread Tom Lane
Zach Bagnall [EMAIL PROTECTED] 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

Re: [ADMIN] Postgresql Upgrade 7.4 to 8.2

2007-02-13 Thread Joshua D. Drake
Tom Lane wrote: Zach Bagnall [EMAIL PROTECTED] 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

Re: [ADMIN] Postgresql Upgrade 7.4 to 8.2

2007-02-13 Thread Zach Bagnall
On 02/14/07 16:00, Joshua D. Drake wrote: Tom Lane wrote: Zach Bagnall [EMAIL PROTECTED] 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

[ADMIN] Postgresql Upgrade 7.4 to 8.2

2007-01-24 Thread Radhika Sambamurti
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

Re: [ADMIN] Postgresql Upgrade 7.4 to 8.2

2007-01-24 Thread Matthias . Pitzl
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: [ADMIN] Postgresql Upgrade 7.4 to 8.2

2007-01-24 Thread Milen A. Radev
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:

Re: [ADMIN] Postgresql Upgrade 7.4 to 8.2

2007-01-24 Thread Peter Eisentraut
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/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] Postgresql Upgrade 7.4 to 8.2

2007-01-24 Thread Joshua D. Drake
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