Upgrade to 7.2

Lists: pgsql-admin
From: Scott Taylor <scott(dot)taylor(at)4i-dotcom(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Upgrade to 7.2
Date: 2002-05-21 10:42:28
Message-ID: 200205211142.29019.scott.taylor@4i-dotcom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Could anyone tell me what (if anything) I can do if I upgraded from 7.1.3 to
7.2, without doing backup (pg_dump). I cannot read my dataset because it is
incompatible with new version. Could you give me the commands?

I have Red Hat 7.3 (running SQL Ledger)

my data set is at: /usr/local/www/sql-ledger/users/accs.db
run command: postmaster -iD /var/lib/pgsql/data

Regards

Scott Taylor


From: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>
To: Scott Taylor <scott(dot)taylor(at)4i-dotcom(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Upgrade to 7.2
Date: 2002-05-21 13:24:25
Message-ID: 200205211854.25121.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Hi Scott,

You must dump and reload the data
when upgrading from 7.1.x to 7.2.x
I feel i had read like that in the release notes
for 7.2.x

are u facing any problem in pg_dumping ??

regds.
mallah.

On Tuesday 21 May 2002 04:12 pm, Scott Taylor wrote:
> Could anyone tell me what (if anything) I can do if I upgraded from 7.1.3
> to 7.2, without doing backup (pg_dump). I cannot read my dataset because it
> is incompatible with new version. Could you give me the commands?
>
> I have Red Hat 7.3 (running SQL Ledger)
>
> my data set is at: /usr/local/www/sql-ledger/users/accs.db
> run command: postmaster -iD /var/lib/pgsql/data
>
> Regards
>
> Scott Taylor
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Taylor <scott(dot)taylor(at)4i-dotcom(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Upgrade to 7.2
Date: 2002-05-21 14:20:52
Message-ID: 20471.1021990852@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Scott Taylor <scott(dot)taylor(at)4i-dotcom(dot)com> writes:
> Could anyone tell me what (if anything) I can do if I upgraded from 7.1.3 to
> 7.2, without doing backup (pg_dump). I cannot read my dataset because it is
> incompatible with new version. Could you give me the commands?

You're going to have to reinstall 7.1.3 and run pg_dumpall.

regards, tom lane