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: (view raw, whole thread or download thread mbox)
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

Reini Urban

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-2017 The PostgreSQL Global Development Group