Re: pg_dump and restore

Поиск
Список
Период
Сортировка
От Arun Padule
Тема Re: pg_dump and restore
Дата
Msg-id CAE469vDaSPCWtBC0r+u3t92q9FEZsAz1xwcLkhVPNUz=jOAxvw@mail.gmail.com
обсуждение исходный текст
Ответ на pg_dump and restore  ("suhas.basavaraj12" <suhas.b@verse.in>)
Ответы Re: pg_dump and restore  (Birta Levente <blevi.linux@gmail.com>)
Список pgsql-admin
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 many other functions that might not be used or compatible with the higher version of postgres.

In this case you need to explicit on the changes in the proc or function. Like as below.

where '5'::integer = 5;

Thanks,
Arun

On Wed, Jan 9, 2013 at 5:18 PM, suhas.basavaraj12 <suhas.b@verse.in> wrote:
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.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Using pre-configured vs building Postgres
Следующее
От: Birta Levente
Дата:
Сообщение: Re: pg_dump and restore