Skip site navigation (1) Skip section navigation (2)

Re: pg_dump and Postgres 8.0.0 Release on cygwin

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 (view raw or flat)
Thread:
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

In response to

pgsql-cygwin by date

Next:From: Tom McMillenDate: 2005-03-08 08:57:49
Subject: Re: Building DBD::Pg fails at make test
Previous:From: Afton & Ray StillDate: 2005-03-08 07:07:11
Subject: Re: [ADMIN] PostgreSQL installation problem on Windows XP Home

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group