Обсуждение: pg_dump and Postgres 8.0.0 Release on cygwin
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? Thanks Laurie :.________________ CONFIDENTIALITY : This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium.
laurie.burrow@powerconv.alstom.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
Reini wrote > 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/ Thanks for the help, I've installed it and it works fine for me (I am using only the client tools on cygwin). En passant: As far as I can tell the performance of the cygwin ports is at least as good if not better than the native ports running on the same machine (W2K desktop) to the same postgres 8.0.0 server (W2K server) doing the exact same job. I am curious as why this might be. Regards Laurie :.________________ CONFIDENTIALITY : This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium.