On Mon, Mar 14, 2011 at 1:38 PM, Vick Khera wrote:
> On Mon, Mar 14, 2011 at 10:06 AM, Alexander Pyhalov wrote:
> > Am I right that on PostgreSQL upgrade to new major version (e.g. from 9.0
> to
> > 9.1) I'll loose my backups (base backups and wal files will be useless)?
> So
> > to go to past a
On Mon, Mar 14, 2011 at 10:06 AM, Alexander Pyhalov wrote:
> Am I right that on PostgreSQL upgrade to new major version (e.g. from 9.0 to
> 9.1) I'll loose my backups (base backups and wal files will be useless)? So
> to go to past after DB upgrade I had to install old version(9.0), recover
> dat
Hello.
On 03/14/2011 17:38, Vibhor Kumar wrote:
You won't be able to use the Data Directory of New Version for PG 9.0,
you have to use your old backup.
What is the preferred way to deal with this issue?
I would recommend to take pg_dump backup with Filesystem Backup before any
upgrade.
Ca
On Mar 14, 2011, at 7:36 PM, Alexander Pyhalov wrote:
> Am I right that on PostgreSQL upgrade to new major version (e.g. from 9.0 to
> 9.1) I'll loose my backups (base backups and wal files will be useless)?
Yes, those Backups would not be valid.
> So to go to past after DB upgrade I had to i
Hello.
Am I right that on PostgreSQL upgrade to new major version (e.g. from
9.0 to 9.1) I'll loose my backups (base backups and wal files will be
useless)? So to go to past after DB upgrade I had to install old
version(9.0), recover data and then upgrade DBMS software...
What is the preferre
