Re: pg_dump and Postgres 8.0.0 Release on cygwin

laurie(dot)burrow(at)powerconv(dot)alstom(dot)com schrieb:

> I use many bash scripts running on cygwin to support postgres
> administration operations in a Windows 2000 server.
>
> Unfortunately the pg_dump contained in the cygwin port of Postgres 8 is
> version 8.0.0.beta3 which gives error
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: column "nsptablespace" does not
> exist
> pg_dump: The command was: SELECT tableoid, oid, nspname, (select usename
> from pg
> _user where nspowner = usesysid) as usename, nspacl, (SELECT spcname FROM
> pg_tab
> lespace t WHERE t.oid = nsptablespace) AS nsptablespace FROM pg_namespace
>
> As I recall this was an error in pg_dump that is corrected in Postgres
> 8.0.0 release. Will the postgres 8.0.0 release be ported to cygwin and any
> ideas about when?

I have an experimental 8.0.0 version on my site, but I encounter
IPC permissions problems (only related to cygwin).
It works for most installations though.

Point setup to http://xarch.tu-graz.ac.at/publ/cygwin/

--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban
http://phpwiki.org