suhas.basavaraj12 wrote:
> We will be dumping data from version 9.0 and restore to 9.1.
That should work fine, as long as use use pg_dump from version
9.1 to dump the 9.0 database.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
h
Thanks for the info .We will be dumping data from version 9.0 and restore to
9.1.
Rgrds
Suhas
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/pg-dump-and-restore-tp5739350p5739517.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent vi
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
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
Hello again,
I have some additional information that points to an
encoding problem. I pulled the COPY sql from the dump
file for the table that didn't get inserted properly
and tried to run just that section (with psql -f). I
got this error:
psql -f bibent_data.sql HRS
psql:bibent_dat
Hello,
I've looked for this in the books and archives and
haven't been able to find an answer.
I did a pg_dump on an older postgres database (I
believe it's 7.0.something), and restored to 7.2.1
with multibyte capability. The old db is not
multibyte. What's happened is that there are a
signifi
