On 10/01/2013 09:47, Arun Padule wrote:
Hi,
Yes you a dump data from one version of postgres to the other version.
But later you will facing issue with casting of data type's.
As documentaion said, you need to make a dump with pg_dump from the
"destination" version. But if you want to migrat
Hi,
Yes you a dump data from one version of postgres to the other version.
But later you will facing issue with casting of data type's.
e,g
where '5' = 5; works in 8.0 version
But same where clause through's a data type miss match on 9.1 version.
These is just a one example, there might be man
Armin Resch wrote:
> one needs to evaluate to what extent an upgrade of postgres is contained
PostgreSQL minor releases (where the version number matches to the
left of the second dot) only contain fixes for bugs and security
vulnerabilities. Dependencies on other packages should not change.
htt
Greetings,
I'm running postgres-9.2.2 in a Linux-x86_64 cluster with 1 master and
several hot standby servers. Since upgrading to 9.2.2 from 9.1.x a
few months ago, I switched from generating a base backup on the
master, to generating it on a dedicated slave/standby (to reduce the
load on the mast
Hi,
Can we dump data from any postrgres version and restore it to any version
of postgres ?
If not , can anyone tell which version of data is compatible to which
version ?
Rgrds
Suhas.B
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/pg-dump-and-restore-tp5739350.h
