Re: [GENERAL] Upgrade from 9.1 to 9.10

2013-10-22 Thread ramistuni
Thanks much. It is of great help. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Upgrade-from-9-1-to-9-10-tp5775290p5775534.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list

[GENERAL] Upgrade from 9.1 to 9.10

2013-10-21 Thread ramistuni
Hi All, I am relatively new to postgres and need to upgrade postgres 9.1.1 to 9.1.10. As I understood from the documentation that Upgrading to a minor release does not require a dump and restore; merely stop the database server, install the updated binaries, and restart the server Is there any

Re: [GENERAL] Upgrade from 9.1 to 9.10

2013-10-21 Thread John R Pierce
On 10/21/2013 10:57 AM, ramistuni wrote: Hi All, I am relatively new to postgres and need to upgrade postgres 9.1.1 to 9.1.10. As I understood from the documentation that Upgrading to a minor release does not require a dump and restore; merely stop the database server, install the updated

Re: [GENERAL] Upgrade from 9.1 to 9.10

2013-10-21 Thread David Johnston
ramistuni wrote We are currently running PostgreSQL 9.1.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51), 64-bit This is packaging (thus Linux Distro) concern and not that of PostgreSQL proper. As I use Ubuntu and you appear to be using a Red Hat variant

Re: [GENERAL] Upgrade from 9.1 to 9.10

2013-10-21 Thread ramistuni
Thanks so much David and John for your quick responses. These databases were recently transitioned to me from a team which are not part of our organization any more. Please bare with my knowledge, but is there any way to find if the past installations were done using YUM? We have been given

Re: [GENERAL] Upgrade from 9.1 to 9.10

2013-10-21 Thread John R Pierce
On 10/21/2013 12:00 PM, ramistuni wrote: Please bare with my knowledge, but is there any way to find if the past installations were done using YUM? This is all standard redhat installation/administration stuff... # rpm -qf /usr/pgsql-9.2/bin/postgres

Re: [GENERAL] Upgrade from 9.1 to 9.10

2013-10-21 Thread John R Pierce
On 10/21/2013 12:15 PM, John R Pierce wrote: # rpm -qf /etc/yum.repos.d/pgdg-9* pgdg-centos90-9.0-5.noarch pgdg-centos92-9.2-6.noarch you should see the 91 version. oh, to clarify something.the version of that pgdg-.noarch repository file is NOT directly related to the