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