pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrading to 7.4.5
6+ messages / 4 participants
[nested] [flat]
* Upgrading to 7.4.5
@ 2004-10-22 05:41 Chris White (cjwhite) <cjwhite@cisco.com>
2004-10-22 05:55 ` Re: Upgrading to 7.4.5 Frans <fransgunawan@gmail.com>
2004-10-25 05:54 ` Re: Upgrading to 7.4.5 Rajesh Kumar Mallah <mallah@trade-india.com>
0 siblings, 2 replies; 6+ messages in thread
From: Chris White (cjwhite) @ 2004-10-22 05:41 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Upgrading to 7.4.5
2004-10-22 05:41 Upgrading to 7.4.5 Chris White (cjwhite) <cjwhite@cisco.com>
@ 2004-10-22 05:55 ` Frans <fransgunawan@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: Frans @ 2004-10-22 05:55 UTC (permalink / raw)
To: cjwhite@cisco.com; +Cc: pgsql-admin
DB created under 7.4.2 will work with 7.4.5, but I thing You should
backup your data before upgrading to a new version.
--
Best Regards,
Frans Gunawan
fransgunawan@gmail.com
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Upgrading to 7.4.5
2004-10-22 05:41 Upgrading to 7.4.5 Chris White (cjwhite) <cjwhite@cisco.com>
@ 2004-10-25 05:54 ` Rajesh Kumar Mallah <mallah@trade-india.com>
2004-10-25 06:11 ` Re: Upgrading to 7.4.5 Vishal Kashyap @ [Sai Hertz And Control Systems] <vishalonlist@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Rajesh Kumar Mallah @ 2004-10-25 05:54 UTC (permalink / raw)
To: cjwhite@cisco.com; +Cc: pgsql-admin
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
Regds
mallah.
Chris White (cjwhite) wrote:
> 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/ |
+---------------------------------------------------+
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Upgrading to 7.4.5
2004-10-22 05:41 Upgrading to 7.4.5 Chris White (cjwhite) <cjwhite@cisco.com>
2004-10-25 05:54 ` Re: Upgrading to 7.4.5 Rajesh Kumar Mallah <mallah@trade-india.com>
@ 2004-10-25 06:11 ` Vishal Kashyap @ [Sai Hertz And Control Systems] <vishalonlist@gmail.com>
2004-10-25 07:37 ` Re: Upgrading to 7.4.5 Rajesh Kumar Mallah <mallah@trade-india.com>
0 siblings, 1 reply; 6+ messages in thread
From: Vishal Kashyap @ [Sai Hertz And Control Systems] @ 2004-10-25 06:11 UTC (permalink / raw)
To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: cjwhite@cisco.com; pgsql-admin
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
>
> > 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
>
--
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Upgrading to 7.4.5
2004-10-22 05:41 Upgrading to 7.4.5 Chris White (cjwhite) <cjwhite@cisco.com>
2004-10-25 05:54 ` Re: Upgrading to 7.4.5 Rajesh Kumar Mallah <mallah@trade-india.com>
2004-10-25 06:11 ` Re: Upgrading to 7.4.5 Vishal Kashyap @ [Sai Hertz And Control Systems] <vishalonlist@gmail.com>
@ 2004-10-25 07:37 ` Rajesh Kumar Mallah <mallah@trade-india.com>
2004-10-25 09:08 ` Re: Upgrading to 7.4.5 Vishal Kashyap @ [Sai Hertz And Control Systems] <vishalonlist@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Rajesh Kumar Mallah @ 2004-10-25 07:37 UTC (permalink / raw)
To: Vishal Kashyap @ [Sai Hertz And Control Systems] <vishalonlist@gmail.com>; +Cc: cjwhite@cisco.com; pgsql-admin
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/ |
+---------------------------------------------------+
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Upgrading to 7.4.5
2004-10-22 05:41 Upgrading to 7.4.5 Chris White (cjwhite) <cjwhite@cisco.com>
2004-10-25 05:54 ` Re: Upgrading to 7.4.5 Rajesh Kumar Mallah <mallah@trade-india.com>
2004-10-25 06:11 ` Re: Upgrading to 7.4.5 Vishal Kashyap @ [Sai Hertz And Control Systems] <vishalonlist@gmail.com>
2004-10-25 07:37 ` Re: Upgrading to 7.4.5 Rajesh Kumar Mallah <mallah@trade-india.com>
@ 2004-10-25 09:08 ` Vishal Kashyap @ [Sai Hertz And Control Systems] <vishalonlist@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Vishal Kashyap @ [Sai Hertz And Control Systems] @ 2004-10-25 09:08 UTC (permalink / raw)
To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: cjwhite@cisco.com; pgsql-admin
> 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.
>
Opps !! I was wrong and was in the impression that 7.4.2 > migration
calls for initdb and incidently I have been doing the same for all
my clients :(( Its is such a shame for me.
Anyways Chris Rajesh is correct.
Thanks a lot Rajesh to correct me.
--
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2004-10-25 09:08 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-22 05:41 Upgrading to 7.4.5 Chris White (cjwhite) <cjwhite@cisco.com>
2004-10-22 05:55 ` Frans <fransgunawan@gmail.com>
2004-10-25 05:54 ` Rajesh Kumar Mallah <mallah@trade-india.com>
2004-10-25 06:11 ` Vishal Kashyap @ [Sai Hertz And Control Systems] <vishalonlist@gmail.com>
2004-10-25 07:37 ` Rajesh Kumar Mallah <mallah@trade-india.com>
2004-10-25 09:08 ` Vishal Kashyap @ [Sai Hertz And Control Systems] <vishalonlist@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox