| From: | Dave Page <dpage(at)postgresql(dot)org> |
|---|---|
| To: | Pavlos Stamboulides <pavlos(at)psychology(dot)gr> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: pg_dump and pg_restore not working properly for 8.1 |
| Date: | 2007-04-22 15:37:30 |
| Message-ID: | 462B813A.5000301@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Pavlos Stamboulides wrote:
> I found and resolved an issue.
>
> It is interesting and will surely save a lot of time to many people.
>
> The latest pgAdmin version (1.6.3) comes with the latest
> pg_dump/pg_restore executables (from 8.2.3). At least in Windows, when
> trying to do operations on a 8.1 server, the files it generates and then
> tries to restore will fail with many errors. My messages had to do
> especially with the "owned" keyword not being recognized and subsequent
> error messages for undeclared objects followed.
Yeah, that was a screwup on my part - sorry.
> To fix this, I found the binaries (pg_dump.exe/pg_restore.exe) from
> postgres 8.1 and replaced them in the pgAdmin installation. It worked
> like a charm.
>
> Hope it proves useful to some people.
>
> Should a compatibility version of pg_dump be included in future versions
> of pgAdmin?
The next version of pgAdmin will ship with the 8.3 pg_*, but will allow
you to select an alternate set in the options. You can also separately
select EnterpriseDB utilities should you need them to work with EDB
databases.
Regards, Dave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shieldy | 2007-04-23 03:22:41 | where is the functions definitions in the src? |
| Previous Message | Pavlos Stamboulides | 2007-04-22 00:23:01 | pg_dump and pg_restore not working properly for 8.1 |