Re: [BUGS] 9.2 beta2 - pg_ctl crashes on Win32 when neither PGDATA nor -D specified

2012-06-12 Thread Edmund Horner
On 13 June 2012 00:54, Amit Kapila wrote: >>> I note that "postgres -C data_directory" will refuse to run on the >>> command line because I've got admin privileges in Windows, and that >>> pg_ctl normally starts postgres.exe using CreateRestrictedProcess. >>> But it does not do so for the popen ca

Re: [BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-06-11 Thread Edmund Horner
On 26 May 2012 01:10, Bruce Momjian wrote: > Ah, turns out I only need one extra log file on Windows, not two, > because I can reuse the utility file for pg_ctl stop.  The original > beta1 code usesd the utility file for pg_ctl stop and start, which is > what caused the problem. > > Applied patch

Re: [BUGS] 9.2 beta2 - pg_ctl crashes on Win32 when neither PGDATA nor -D specified

2012-06-11 Thread Edmund Horner
On 12 June 2012 14:51, Tom Lane wrote: > Edmund Horner writes: >> On 12 June 2012 14:23, Tom Lane wrote: >>> Hm, that patch seems to be several bricks shy of a load.  I will fix >>> two obvious bugs in it: >>> (1) not dump core on boxes where printf("%s

Re: [BUGS] 9.2 beta2 - pg_ctl crashes on Win32 when neither PGDATA nor -D specified

2012-06-11 Thread Edmund Horner
On 12 June 2012 14:23, Tom Lane wrote: > Edmund Horner writes: >> In 9.1, if I run "pg_ctl start" without providing way for it to find >> the datadir, it prints the error: > >>     C:\ehorner\pgsql-old\bin>pg_ctl start >>     pg_ctl: no database d

[BUGS] 9.2 beta2 - pg_ctl crashes on Win32 when neither PGDATA nor -D specified

2012-06-10 Thread Edmund Horner
In 9.1, if I run "pg_ctl start" without providing way for it to find the datadir, it prints the error: C:\ehorner\pgsql-old\bin>pg_ctl start pg_ctl: no database directory specified and environment variable PGDATA unset Try "pg_ctl --help" for more information. In 9.2 (beta1 and beta2)

Re: [BUGS] 9.2 beta1 libxml2 can't be loaded on Windows

2012-06-10 Thread Edmund Horner
On 9 June 2012 03:48, Dave Page wrote: > On Fri, Jun 1, 2012 at 1:39 AM, Edmund Horner wrote: >> On 1 June 2012 12:36, Edmund Horner wrote: >>> On 1 June 2012 12:14, Edmund Horner wrote: >>>> I tried using an older libxml2.dll.  Replace with the one from >&

Re: [BUGS] 9.2 beta1 libxml2 can't be loaded on Windows

2012-05-31 Thread Edmund Horner
On 1 June 2012 12:36, Edmund Horner wrote: > On 1 June 2012 12:14, Edmund Horner wrote: >> I tried using an older libxml2.dll.  Replace with the one from >> ftp://ftp.zlatkovic.com/libxml/oldreleases/libxml2-2.6.9.win32.zip >> (and copying zlib1.dll to zlib.dll), and it wor

Re: [BUGS] 9.2 beta1 libxml2 can't be loaded on Windows

2012-05-31 Thread Edmund Horner
On 1 June 2012 12:14, Edmund Horner wrote: > I tried using an older libxml2.dll.  Replace with the one from > ftp://ftp.zlatkovic.com/libxml/oldreleases/libxml2-2.6.9.win32.zip > (and copying zlib1.dll to zlib.dll), and it works. > > I note that the previous 9.1.3 binaries used th

Re: [BUGS] 9.2 beta1 libxml2 can't be loaded on Windows

2012-05-31 Thread Edmund Horner
On 31 May 2012 14:14, Edmund Horner wrote: > Hello, apologies if this is already in your radar. > > I can successfully install the PostgreSQL 9.2 beta1 binaries on > Windows XP and successfully perform most queries.  However I've run > into some trouble with the XML supp

[BUGS] 9.2 beta1 libxml2 can't be loaded on Windows

2012-05-30 Thread Edmund Horner
Hello, apologies if this is already in your radar. I can successfully install the PostgreSQL 9.2 beta1 binaries on Windows XP and successfully perform most queries. However I've run into some trouble with the XML support. >From a very cursory search I did not see anything changed since 9.1.3 tha

Re: [BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-24 Thread Edmund Horner
On 25 May 2012 11:48, Edmund Horner wrote: > It still fails (when run in verbose mode): Sorry, let me correct that to: It still fails, regardless of verbose mode. And, in verbose mode, the output is... -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to y

Re: [BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-24 Thread Edmund Horner
On 25 May 2012 01:59, Bruce Momjian wrote: > On Thu, May 24, 2012 at 03:42:25PM +0200, Magnus Hagander wrote: >> I've built a new one off git master + Bruce's patch. You can get it >> from http://www.hagander.net/tmp/pg_upgrade.zip - please see if that >> one works for you. > > Thanks, but thinkin

Re: [BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-23 Thread Edmund Horner
On 24 May 2012 12:33, Bruce Momjian wrote: > I have applied the attached patch which should fix the problem.   How > can we get Edmund a copy of a new binary for testing?  Does he have to > wait for beta2? My uneducated guess is that your patch will fix the problem. But I don't think I'm up to c

Re: [BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-22 Thread Edmund Horner
On 22 May 2012 18:49, Craig Ringer wrote: > When you shut down the 9.1.3 cluster did you make absolutely certain there > were no postgres.exe processes lurking around when you tested? Given the > incredible thouroughness of your report I imagine you did, but it's worth > checking, as a lingering `

[BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-21 Thread Edmund Horner
(Sending this again to pgsql-bugs with no attachments; hopefully it'll be accepted. Apologies for any duplicates! I'll provide the attachments if you need them, though I suspect things may become clear without them.) Hello, I'm forwarding this to pgsql-bugs after sending it to pgsql-testers. I'

Re: [BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-21 Thread Edmund Horner
Hum. My first email sent to this list a few days ago still has not arrived, so these two are kind of orphaned. Should I resend it? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-20 Thread Edmund Horner
On 18 May 2012 23:06, Edmund Horner wrote: > I ran into a bit of trouble running pg_upgrade to upgrade from my > 9.1.3 cluster.  This is the first time I have run pg_upgrade.  It is > entirely possible I've done something wrong. > > As a control, I was able to success