Обсуждение: upgrade from postgres 7.3.2
Hi all,
I am new to postgres. The current version of postgres we are using is 7.3.2.
I am looking to upgrade to 7.4.x. Is the upgrade necessary? If so, which is the most stable version to upgrade to?
We have more than 300 tables with lot of data to be backed up and restored. It would be nice if someone could give the steps to upgrade from 7.3.2 to one of the latest stable version.
Here is the output from select version();
version
-------------------------------------------------------------
PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
Thanks,
Saranya
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com
Sarlav , > > I am new to postgres. Welcome to the most powerfull Database system. > I am looking to upgrade to 7.4.x. Is the upgrade necessary? > Your upgrade to 7.4.x would be worth in many terms as 7.4. has many performance enhancements also if your app uses subquery then 7.4 is advisable. >If so, which is > the most stable version to upgrade to? 7.4.5 > > > > We have more than 300 tables with lot of data to be backed up and restored. > It would be nice if someone could give the steps to upgrade from 7.3.2 to > one of the latest stable version. 1. Backup everything make a file system bacup of the PostgreSQL database (plz make sutre to shut down PostgreSQL before doing this) 2. Backup data. 3. Backup Schema 4. Install 7.4.5 give database path diffrent 5. Initdb the database (This is required as you are upgrading to a major version) 6. Restore schema in new system 7. Restore database 8. Run PostgreSQL make sure you append the $PGDATA Now you are on PostgreSQL 7.4.5 If something goes wrong. Reinstall PostgreSQL 7.3.2 Restore your filesyatem backup. Hope this helps -- With Best Regards, Vishal Kashyap. Did you know SaiPACS is one and only PACS Management tool. http://saihertz.com, http://vishalkashyap.tk
Hi Vishal,
Thanks a lot for the information and procedure to upgrade.
I will mostly try to upgrade this week or next week. Will let you know how it goes!
Thanks again,
Saranya
"Vishal Kashyap @ [SaiHertz]" <vishalonlist@gmail.com> wrote:
"Vishal Kashyap @ [SaiHertz]" <vishalonlist@gmail.com> wrote:
Sarlav ,
>
> I am new to postgres.
Welcome to the most powerfull Database system.
> I am looking to upgrade to 7.4.x. Is the upgrade necessary?
>
Your upgrade to 7.4.x would be worth in many terms as 7.4. has many
performance enhancements also if your app uses subquery then 7.4 is advisable.
>If so, which is
> the most stable version to upgrade to?
7.4.5
>
>
>
> We have more than 300 tables with lot of data to be backed up and restored.
> It would be nice if someone could give the steps to upgrade from 7.3.2 to
> one of the latest stable version.
1. Backup everything make a file system bacup of the PostgreSQL
database (plz make sutre to shut down PostgreSQL before doing this)
2. Backup data.
3. Backup Schema
4. Install 7.4.5 give data base path diffrent
5. Initdb the database (This is required as you are upgrading to a
major version)
6. Restore schema in new system
7. Restore database
8. Run PostgreSQL make sure you append the $PGDATA
Now you are on PostgreSQL 7.4.5
If something goes wrong.
Reinstall PostgreSQL 7.3.2
Restore your filesyatem backup.
Hope this helps
--
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
http://saihertz.com,
http://vishalkashyap.tk
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
Do you Yahoo!?
Discover all that�s new in My Yahoo!
Saranya , Sorry but the latest release is 7.4.6 kindly note it. > I will mostly try to upgrade this week or next week. Will let you know how > it goes! > Best luck it would be easy trust me ;-) -- With Best Regards, Vishal Kashyap. Did you know SaiPACS is one and only PACS Management tool. http://saihertz.com, http://vishalkashyap.tk
Hi,
Thanks again.
I would like to subscribe for a message digest. I tried sending a mail to pgsql-novice-request@postgresql.org with a single line in the body of the message:
subscribe-digest
But I get a mail saying that the command was not successful.
Any idea how I can subscribe for a digest??
Thanks,
Saranya
"Vishal Kashyap @ [SaiHertz]" <vishalonlist@gmail.com> wrote:
Sarlav ,
>
> I am new to postgres.
Welcome to the most powerfull Database system.
> I am looking to upgrade to 7.4.x. Is the upgrade necessary?
>
Your upgrade to 7.4.x would be worth in many terms as 7.4. has many
performance enhancements also if your app uses subquery then 7.4 is advisable.
>If so, which is
> the most stable version to upgrade to?
7.4.5
>
>
>
> We have more than 300 tables with lot of data to be backed up and restored.
> It would be nice if someone could give the steps to upgrade from 7.3.2 to
> one of the latest stable version.
1. Backup everything make a file system bacup of the PostgreSQL
database (plz make sutre to shut down PostgreSQL before doing this)
2. Backup data.
3. Backup Schema
4. Install 7.4.5 give data base path diffrent
5. Initdb the database (This is required as you are upgrading to a
major version)
6. Restore schema in new system
7. Restore database
8. Run PostgreSQL make sure you append the $PGDATA
Now you are on PostgreSQL 7.4.5
If something goes wrong.
Reinstall PostgreSQL 7.3.2
Restore your filesyatem backup.
Hope this helps
--
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
http://saihertz.com,
http://vishalkashyap.tk
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
Do you Yahoo!?
Discover all that�s new in My Yahoo!
sarlav kumar <sarlavk@yahoo.com> writes:
> Any idea how I can subscribe for a digest??
I think you subscribe normally and then set your configuration to
"digest" instead of regular. majordomo has fairly extensive help
--- try sending it "help" and "help set" commands.
regards, tom lane
If I'm reading the help files properly, you should be able to send it as: subscribe-set <listname> digest in fact, for those wishing to do a 'nomail' subscribe (ie. those reading Usenet), you can do it as: subscribe-set <listname> nomail Again, assuming I'm reading the help file correctly ... On Wed, 17 Nov 2004, Tom Lane wrote: > sarlav kumar <sarlavk@yahoo.com> writes: >> Any idea how I can subscribe for a digest?? > > I think you subscribe normally and then set your configuration to > "digest" instead of regular. majordomo has fairly extensive help > --- try sending it "help" and "help set" commands. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
Hi,
Thank you guys.
I sent a mail to majordomo with the body of the mail
set LISTNAME digest
I then had to confirm the set request to get the digests!!
Anyone has any idea about the index problem I had sent earlier?
Thanks,
Saranya
"Marc G. Fournier" <scrappy@postgresql.org> wrote:
"Marc G. Fournier" <scrappy@postgresql.org> wrote:
If I'm reading the help files properly, you should be able to send it as:
subscribe-set digest
in fact, for those wishing to do a 'nomail' subscribe (ie. those reading
Usenet), you can do it as:
subscribe-set nomail
Again, assuming I'm reading the help file correctly ...
On Wed, 17 Nov 2004, Tom Lane wrote:
> sarlav kumar writes:
>> Any idea how I can subscribe for a digest??
>
> I think you subscribe normally and then set your configuration to
> "digest" instead of regular. majordomo has fairly extensive help
> --- try sending it "help" and "help set" commands.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Hi All,
Everytime I post a message to pgsql-novice, I get an automated mail from this id:
The content of the mail is this:
Paul Daniels no longer works for Arinbe Technologies, Inc. Any inquiries related to his projects will be handled by Reginald Marbray via email (marbrayr@arinbe.com) or telephone (703-968-6052). Thank you. Arinbe Information Administrator
Is there a way to get around this??
Thanks,
Saranya
"Vishal Kashyap @ [SaiHertz]" <vishalonlist@gmail.com> wrote:
Sarlav ,
>
> I am new to postgres.
Welcome to the most powerfull Database system.
> I am looking to upgrade to 7.4.x. Is the upgrade necessary?
>
Your upgrade to 7.4.x would be worth in many terms as 7.4. has many
performance enhancements also if your app uses subquery then 7.4 is advisable.
>If so, which is
> the most stable version to upgrade to?
7.4.5
>
>
>
> We have more than 300 tables with lot of data to be backed up and restored.
> It would be nice if someone could give the steps to upgrade from 7.3.2 to
> one of the latest stable version.
1. Backup everything make a file system bacup of the PostgreSQL
database (plz make sutre to shut down PostgreSQL before doing this)
2. Backup data.
3. Backup Schema
4. Install 7.4.5 give data base path diffrent
5. Initdb the database (This is required as you are upgrading to a
major version)
6. Restore schema in new system
7. Restore database
8. Run PostgreSQL make sure you append the $PGDATA
Now you are on PostgreSQL 7.4.5
If something goes wrong.
Reinstall PostgreSQL 7.3.2
Restore your filesyatem backup.
Hope this helps
--
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
http://saihertz.com,
http://vishalkashyap.tk
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection ar ound
http://mail.yahoo.com
email address removed form the lists ... thanks ... On Wed, 17 Nov 2004, sarlav kumar wrote: > Hi All, > > Everytime I post a message to pgsql-novice, I get an automated mail from this id: > pdaniels@arinbe.com > > The content of the mail is this: > > Paul Daniels no longer works for Arinbe Technologies, Inc. Any inquiries related to his projects will be handled by ReginaldMarbray via email (marbrayr@arinbe.com) or telephone (703-968-6052).Thank you.Arinbe Information Administrator > > > > Is there a way to get around this?? > > Thanks, > Saranya > > "Vishal Kashyap @ [SaiHertz]" <vishalonlist@gmail.com> wrote: > Sarlav , > > >> >> I am new to postgres. > > Welcome to the most powerfull Database system. > >> I am looking to upgrade to 7.4.x. Is the upgrade necessary? >> > Your upgrade to 7.4.x would be worth in many terms as 7.4. has many > performance enhancements also if your app uses subquery then 7.4 is advisable. > > >> If so, which is >> the most stable version to upgrade to? > > 7.4.5 > >> >> >> >> We have more than 300 tables with lot of data to be backed up and restored. >> It would be nice if someone could give the steps to upgrade from 7.3.2 to >> one of the latest stable version. > > 1. Backup everything make a file system bacup of the PostgreSQL > database (plz make sutre to shut down PostgreSQL before doing this) > 2. Backup data. > 3. Backup Schema > 4. Install 7.4.5 give database path diffrent > 5. Initdb the database (This is required as you are upgrading to a > major version) > 6. Restore schema in new system > 7. Restore database > 8. Run PostgreSQL make sure you append the $PGDATA > > Now you are on PostgreSQL 7.4.5 > If something goes wrong. > Reinstall PostgreSQL 7.3.2 > Restore your filesyatem backup. > > > > > > Hope this helps > > > > -- > With Best Regards, > Vishal Kashyap. > Did you know SaiPACS is one and only PACS > Management tool. > http://saihertz.com, > http://vishalkashyap.tk > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
Vishal Kashyap @ [SaiHertz] wrote: > Sarlav , > > > >>I am new to postgres. > > > Welcome to the most powerfull Database system. > > >>I am looking to upgrade to 7.4.x. Is the upgrade necessary? >> > > Your upgrade to 7.4.x would be worth in many terms as 7.4. has many > performance enhancements also if your app uses subquery then 7.4 is advisable. > > > >>If so, which is >>the most stable version to upgrade to? > > > 7.4.5 Last version is 7.4.6, you'll find however the doc version for 7.4.5 because doc maintaners say that nothing changed. I still do not understand why the doc version didn't change, not all postgres users are following the list. If a new user arrive on www.postgresql.org and it downloads the 7.4.6 engine I think it's normal look for the 7.4.6 docs, don't you believe ? Regards Gaetano Mendola
On Thu, Nov 18, 2004 at 11:37:29 +0100, Gaetano Mendola <mendola@bigfoot.com> wrote: > > Last version is 7.4.6, you'll find however the doc version for 7.4.5 > because doc maintaners say that nothing changed. I still do not understand > why the doc version didn't change, not all postgres users are following the > list. > If a new user arrive on www.postgresql.org and it downloads the 7.4.6 engine > I think it's normal look for the 7.4.6 docs, don't you believe ? I run 7.4 stable from CVS and did a refresh last night. The copy of the docs I have, have the release notes for 7.4.6 in them.