Thread: versions

Hi,
johnf@linux-12:~> pg_dump --version
pg_dump (PostgreSQL) 9.1.1
johnf@linux-12:~> pg_restore --version
pg_restore (PostgreSQL) 9.1.1

Can I still use the above version with Postgres 8.4????

Johnf

On Sun, 2011-12-11 at 07:05 -0800, John Fabiani wrote:
> Hi,
> johnf@linux-12:~> pg_dump --version
> pg_dump (PostgreSQL) 9.1.1
> johnf@linux-12:~> pg_restore --version
> pg_restore (PostgreSQL) 9.1.1
> 
> Can I still use the above version with Postgres 8.4????
> 

You can use pg_dump 9.1.1 to dump a PostgreSQL 8.4 database, but you'll
only be able to restore it on a 9.1+ database. IOW, you won't be able to
restore it on your 8.4 database. You need a 8.4 dump to do that.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com

On Sun, 2011-12-11 at 13:50 -0800, John Fabiani wrote:
> Ok then how can I use the correct versions.  I need to back and restore for both versions.

Install them :)

And if your linux distro doesn't have them prepackaged, you still can
compile them.

PS: answer to the list please.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com

On Sun, 2011-12-11 at 13:50 -0800, John Fabiani wrote:
> Ok then how can I use the correct versions.  I need to back and restore for both versions.

Install them :)

And if your linux distro doesn't have them prepackaged, you still can
compile them.

PS: answer to the list please.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com