X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 35CC33A40A3 for ; Mon, 25 Oct 2004 08:36:39 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75406-10 for ; Mon, 25 Oct 2004 07:36:36 +0000 (GMT) Received: from trade-india.com (unknown [203.101.29.41]) by svr1.postgresql.org (Postfix) with SMTP id CA1343A40D4 for ; Mon, 25 Oct 2004 08:36:33 +0100 (BST) Received: (qmail 9716 invoked from network); 25 Oct 2004 07:30:48 -0000 Received: from valium.trade-india-local.com (HELO ?192.168.0.100?) (192.168.0.100) by system66.trade-india-local.com with SMTP; 25 Oct 2004 07:30:48 -0000 Message-ID: <417CAD4F.1010004@trade-india.com> Date: Mon, 25 Oct 2004 13:07:51 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla Thunderbird 0.7.3 (X11/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Vishal Kashyap @ [Sai Hertz And Control Systems]" Cc: cjwhite@cisco.com, pgsql-admin@postgresql.org Subject: Re: Upgrading to 7.4.5 References: <200410220541.i9M5flk2007783@sj-core-1.cisco.com> <417C9524.2080001@trade-india.com> <77b69d2104102423114fa588fd@mail.gmail.com> In-Reply-To: <77b69d2104102423114fa588fd@mail.gmail.com> Content-Type: multipart/alternative; boundary="------------050606030902040008070508" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_MESSAGE, HTML_TITLE_EMPTY X-Spam-Level: * X-Archive-Number: 200410/321 X-Sequence-Number: 15314 This is a multi-part message in MIME format. --------------050606030902040008070508 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Vishal Kashyap @ [Sai Hertz And Control Systems] wrote: >Dear Rajesh , > > > >>The release notes of upgrades usually indicate whether initdb >>is required or not. Generally when the last digit of a version >>change it does not require a dump and reload. In this case >>the release notes say: >> >>http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-5 >> >> E.1.1. Migration to version 7.4.5 >> >>A dump/restore is not required for those running 7.4.X >> >> >> > >But migration from 7.4.2 > requires a initdb. > >Check the release notes of 7.4.3 > > The release notes does not seems to say anything like that can you tell me where u read ? http://www.postgresql.org/docs/7.4/static/release-7-4-3.html E.3.1. Migration to version 7.4.3 A dump/restore is not required for those running 7.4.X. However: <>http://www.postgresql.org/docs/7.4/static/release-7-4-2.html does say that dump/initdb/reload is an option to fix 2 errors. These two errors can also be fixed manually without dump / reload which is described in same URL. Since Chris is already using 7.4.2 he may have already fixed it if the data were imported from < 7.4.2 . If original database was created using 7.4.2 dump/reload shud not be required for upgrading to 7.4.5 It is a great timesaver to skip dump/initdb/reload especially when GIGs' of data is involved. Not just in terms of time but also minor manual tweaks that are required to be done to dump files sometime. Regds Mallah. > > >>>Will a DB created under 7.4.2 work with 7.4.5, or do I need to back it >>>up and restore it to a newly created 7.5.4 DB? >>> >>>Chris White >>> >>> >>-- >> >>regds >>Mallah. >> >>Rajesh Kumar Mallah >>+---------------------------------------------------+ >>| Tradeindia.com (3,11,246) Registered Users | >>| Indias' Leading B2B eMarketPlace | >>| http://www.tradeindia.com/ | >>+---------------------------------------------------+ >> >>---------------------------(end of broadcast)--------------------------- >>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >> >> >> > > > > -- regds Mallah. Rajesh Kumar Mallah +---------------------------------------------------+ | Tradeindia.com (3,11,246) Registered Users | | Indias' Leading B2B eMarketPlace | | http://www.tradeindia.com/ | +---------------------------------------------------+ --------------050606030902040008070508 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Vishal Kashyap @ [Sai Hertz And Control Systems] wrote: 
Dear Rajesh ,
 
  
The release notes of upgrades usually indicate whether initdb
is required or not. Generally   when the last digit of a version
change it does not require a dump and reload. In this case
the release notes say:

http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-5

    E.1.1. Migration to version 7.4.5

A dump/restore is not required for those running 7.4.X

    

But migration from 7.4.2 > requires a initdb.

Check the release notes of 7.4.3

The release notes does not seems to say anything like that
can you tell me where u read ?

http://www.postgresql.org/docs/7.4/static/release-7-4-3.html

E.3.1. Migration to version 7.4.3

A dump/restore is not required for those running 7.4.X.


However:

<>http://www.postgresql.org/docs/7.4/static/release-7-4-2.html
does say that dump/initdb/reload is an option to fix 2 errors.
These two errors can also be fixed manually without dump / reload
which is described in same URL.

Since Chris is already using 7.4.2  he may have already fixed it
if the data were imported from  < 7.4.2 . If original database was
created using 7.4.2 dump/reload shud not be required for
upgrading to 7.4.5


It is a great timesaver to skip dump/initdb/reload especially
when GIGs' of data is involved. Not just in terms of time but also
minor manual tweaks that are required to be done to dump files
sometime.

Regds
Mallah.






  
Will a DB created under 7.4.2 work with 7.4.5, or do I need to back it
up and restore it to a newly created 7.5.4 DB?

Chris White
      
--

regds
Mallah.

Rajesh Kumar Mallah
+---------------------------------------------------+
| Tradeindia.com  (3,11,246) Registered Users       |
| Indias' Leading B2B eMarketPlace                  |
| http://www.tradeindia.com/                        |
+---------------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

    


  


-- 

regds
Mallah.

Rajesh Kumar Mallah
+---------------------------------------------------+
| Tradeindia.com  (3,11,246) Registered Users 	    | 
| Indias' Leading B2B eMarketPlace                  |
| http://www.tradeindia.com/			    |
+---------------------------------------------------+
--------------050606030902040008070508--