Re: [GENERAL] PostgreSQL upgrade 9.3.4 -> 9.3.10

[Francisco Olarte]

Hello:

On Tue, Jan 12, 2016 at 10:28 AM, Dev Kumkar  wrote:
> I want to upgrade my database from version 9.3.4 to 9.3.10.
>
> For this task, do I need to upgrade database using pg_upgrade utility?
> http://www.postgresql.org/docs/9.3/static/pgupgrade.html

No, that is a minor release. Minor version upgrades are normally just
install new vesion & restart. In fact we usually install the new
version over the old one and just restart the server ( but YMMV,
specially if you use one of those operating systems which do not let
you delete open files ).

Minor (9.3.4->9.3.10) version normally preserve on disk formats, so
nothing needs to be done.

Mayor ( 9.3.4 -> 9.4.x )  do not, and they normally need either a dump
& restore or a pg_upgrade ( which works like an optimized dump &
restore ).

In any case, read the release notes ( 9.3 docs, at
end,http://www.postgresql.org/docs/9.3/static/release.html ) for
versions 9.3.5-10, specially the headers, any special instructions
should be contained here, when you read 'A dump/restore is not
required for those running 9.3.X.' it meand you can just install and
restart.

> From the details it looks like for minor version upgrade pg_upgrade utility
> is not required.
> "pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL
> data files to be upgraded to a later PostgreSQL major version without the
> data dump/reload typically required for major version upgrades, e.g. from
> 8.4.7 to the current major release of PostgreSQL. It is not required for
> minor version upgrades, e.g. from 9.0.1 to 9.0.4."
>
> Can someone please provide more details here and also what steps needs to be
> done to upgrade to 9.3.10 level?

When postgres changes on-disk formats it bumps the major version.
Normally these used to mean you needed to dump & restore the database,
( Using the NEWER dump/restore utilities, as 9.4 dump/restore know how
to deal with a 9.3 DB, but 9.3 D/R do not even know wether a 9.4
version exists )

pg_upgrade was developed because the on-disk format changes are
tipically minor, and a special program could be made to transform the
data from a version to a later one faster than dumping & restoring,
but is more or less equivalent to doing that. As minor version
upgrades do not need dump/restore, they do not need pg_upgrade either.

Francisco Olarte.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQL upgrade 9.3.4 -> 9.3.10

[John R Pierce]

On 1/12/2016 1:28 AM, Dev Kumkar wrote:


I want to upgrade my database from version 9.3.4 to 9.3.10.

For this task, do I need to upgrade database using pg_upgrade utility?
http://www.postgresql.org/docs/9.3/static/pgupgrade.html


From the details it looks like for minor version upgrade pg_upgrade 
utility is not required.
"pg_upgrade (formerly called pg_migrator) allows data stored in 
PostgreSQL data files to be upgraded to a later PostgreSQL major 
version without the data dump/reload typically required for major 
version upgrades, e.g. from 8.4.7 to the current major release of 
PostgreSQL. It is not required for minor version upgrades, e.g. from 
9.0.1 to 9.0.4."


Can someone please provide more details here and also what steps needs 
to be done to upgrade to 9.3.10 level?




you can do an inplace upgrade of the software, as others said, 
pg_upgrade is for upgrading from 9.X to 9.Y where Y>X


however, its always a good idea to check the release notes of the 
version you're upgrading to, and seeing if there are any special issues, 
for instance, sometimes there's a potential bug in an obscure feature in 
said A.B.C version, and upgrading to A.B.D might require a reindex or 
something. http://www.postgresql.org/docs/current/static/release-9-3-10.html


I don't see anything specifically for 9.3.4 to 9.3.10 but read it for 
yourself, following the links to the applicable intermediate release notes.

.

--
john r pierce, recycling bits in santa cruz

Re: [GENERAL] PostgreSQL upgrade 9.3.4 -> 9.3.10

[Andreas Kretschmer]

Dev Kumkar  wrote:

> Hello,
> 
> 
> I want to upgrade my database from version 9.3.4 to 9.3.10.
> 
> For this task, do I need to upgrade database using pg_upgrade utility?
> http://www.postgresql.org/docs/9.3/static/pgupgrade.html

No.


> Can someone please provide more details here and also what steps needs to be
> done to upgrade to 9.3.10 level?

Just install the new version and restart PG. 


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.  (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.  N 51.05082°, E 13.56889°


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQL upgrade 9.3.4 -> 9.3.10

[Shulgin, Oleksandr]

On Tue, Jan 12, 2016 at 10:28 AM, Dev Kumkar 
wrote:
>
> Hello,
>
>
> I want to upgrade my database from version 9.3.4 to 9.3.10.
>
> For this task, do I need to upgrade database using pg_upgrade utility?
> http://www.postgresql.org/docs/9.3/static/pgupgrade.html
>
>
> From the details it looks like for minor version upgrade pg_upgrade
utility is not required.
> "pg_upgrade (formerly called pg_migrator) allows data stored in
PostgreSQL data files to be upgraded to a later PostgreSQL major version
without the data dump/reload typically required for major version upgrades,
e.g. from 8.4.7 to the current major release of PostgreSQL. It is not
required for minor version upgrades, e.g. from 9.0.1 to 9.0.4."
>
> Can someone please provide more details here and also what steps needs to
be done to upgrade to 9.3.10 level?

Hello,

You don't need pg_upgrade for minor version upgrades.  Please refer to the
documentation: http://www.postgresql.org/docs/9.3/static/upgrading.html

"Minor releases never change the internal storage format and are always
compatible with earlier and later minor releases of the same major version
number, e.g., 8.4.2 is compatible with 8.4, 8.4.1 and 8.4.6. To update
between compatible versions, you simply replace the executables while the
server is down and restart the server. The data directory remains unchanged
— minor upgrades are that simple."

--
Alex

[GENERAL] PostgreSQL upgrade 9.3.4 -> 9.3.10

[Dev Kumkar]

Hello,


I want to upgrade my database from version 9.3.4 to 9.3.10.

For this task, do I need to upgrade database using pg_upgrade utility?
http://www.postgresql.org/docs/9.3/static/pgupgrade.html


>From the details it looks like for minor version upgrade pg_upgrade utility
is not required.
"pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL data
files to be upgraded to a later PostgreSQL major version without the data
dump/reload typically required for major version upgrades, e.g. from 8.4.7
to the current major release of PostgreSQL. It is not required for minor
version upgrades, e.g. from 9.0.1 to 9.0.4."

Can someone please provide more details here and also what steps needs to
be done to upgrade to 9.3.10 level?

Regards...

Re: [GENERAL] PostgreSQL upgrade 9.3.4 -> 9.3.10

[Dev Kumkar]

On Tue, Jan 12, 2016 at 3:25 PM, John R Pierce  wrote:

> On 1/12/2016 1:28 AM, Dev Kumkar wrote:
>
>
> I want to upgrade my database from version 9.3.4 to 9.3.10.
>
> For this task, do I need to upgrade database using pg_upgrade utility?
> 
> http://www.postgresql.org/docs/9.3/static/pgupgrade.html
>
>
> From the details it looks like for minor version upgrade pg_upgrade
> utility is not required.
> "pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL 
> data
> files to be upgraded to a later PostgreSQL major version without the data
> dump/reload typically required for major version upgrades, e.g. from 8.4.7
> to the current major release of PostgreSQL. It is not required for minor
> version upgrades, e.g. from 9.0.1 to 9.0.4."
>
> Can someone please provide more details here and also what steps needs to
> be done to upgrade to 9.3.10 level?
>
>
> you can do an inplace upgrade of the software, as others said, pg_upgrade
> is for upgrading from 9.X to 9.Y where Y>X
>
> however, its always a good idea to check the release notes of the version
> you're upgrading to, and seeing if there are any special issues, for
> instance, sometimes there's a potential bug in an obscure feature in said
> A.B.C version, and upgrading to A.B.D might require a reindex or
> something.
> http://www.postgresql.org/docs/current/static/release-9-3-10.html
>
> I don't see anything specifically for 9.3.4 to 9.3.10 but read it for
> yourself, following the links to the applicable intermediate release notes.
> .
>
> --
> john r pierce, recycling bits in santa cruz
>
> Thanks everyone for your quick comments, appreciate it !

Yes nothing specifically mentioned for 9.3.4 to 9.3.10

Regards...

Re: [GENERAL] PostgreSQL upgrade 9.3.4 -> 9.3.10

[Adrian Klaver]

On 01/12/2016 01:37 AM, Shulgin, Oleksandr wrote:

On Tue, Jan 12, 2016 at 10:28 AM, Dev Kumkar > wrote:
 >
 > Hello,
 >
 >
 > I want to upgrade my database from version 9.3.4 to 9.3.10.
 >
 > For this task, do I need to upgrade database using pg_upgrade utility?
 > http://www.postgresql.org/docs/9.3/static/pgupgrade.html
 >
 >
 > From the details it looks like for minor version upgrade pg_upgrade
utility is not required.
 > "pg_upgrade (formerly called pg_migrator) allows data stored in
PostgreSQL data files to be upgraded to a later PostgreSQL major version
without the data dump/reload typically required for major version
upgrades, e.g. from 8.4.7 to the current major release of PostgreSQL. It
is not required for minor version upgrades, e.g. from 9.0.1 to 9.0.4."
 >
 > Can someone please provide more details here and also what steps
needs to be done to upgrade to 9.3.10 level?

Hello,

You don't need pg_upgrade for minor version upgrades.  Please refer to
the documentation: http://www.postgresql.org/docs/9.3/static/upgrading.html

"Minor releases never change the internal storage format and are always
compatible with earlier and later minor releases of the same major
version number, e.g., 8.4.2 is compatible with 8.4, 8.4.1 and 8.4.6. To
update between compatible versions, you simply replace the executables
while the server is down and restart the server. The data directory
remains unchanged — minor upgrades are that simple."


While that is the rule, there have been exceptions, one I could find:

http://www.postgresql.org/docs/9.1/interactive/release-8-0-3.html

Per another post down thread, the prudent thing to do is to read the 
Release Notes for each release.




--
Alex



--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general