Re: Backup/Restore

kenp wrote:
> Does this imply that pgAdmin picks up a single version of pg_dump and
> pg_restore?
> 
> For example, I have PostgreSQL 8.1.4 and 8.2beta2 installed on my
> machine. I presume the version of pg_dump and pg_restore for each of
> these PostgreSQL versions is different. When I select a database on a
> server, does pgAdmin pick up the verison of pg_dump and pg_restore
> appropriate to that PostgreSQL version?

No, it builds a search path and uses the first copies it finds. It 
differs on Windows, Unix and Mac, but on Windows it will first look in 
the directory that pgAdmin.exe is in, then in any directory that might 
be specified by the most recent installation of PostgreSQL (from 
pgInstaller), and finally will fall back to the normal %PATH%.

The important thing is to make sure you use the most recent pg_dump as 
they're backwards compatible. pgAdmin is always released with the most 
recent stable versions - and if you have a pgInstaller based 
installation, then of course you already have appropriate version.

Regards, Dave