| Lists: | pgsql-cygwin |
|---|
| From: | laurie(dot)burrow(at)powerconv(dot)alstom(dot)com |
|---|---|
| To: | pgsql-cygwin(at)postgresql(dot)org |
| Subject: | pg_dump and Postgres 8.0.0 Release on cygwin |
| Date: | 2005-03-07 17:05:07 |
| Message-ID: | OF2666034A.BC0C3A8E-ON80256FBD.0052C86A-80256FBD.005E494F@transport.alstom.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-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.
| From: | Reini Urban <rurban(at)x-ray(dot)at> |
|---|---|
| To: | laurie(dot)burrow(at)powerconv(dot)alstom(dot)com |
| Cc: | pgsql-cygwin(at)postgresql(dot)org |
| Subject: | Re: pg_dump and Postgres 8.0.0 Release on cygwin |
| Date: | 2005-03-08 07:09:04 |
| Message-ID: | 422D4F90.10608@x-ray.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-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