Re: pg_dumpall -> by hand without --binary-upgrade or BUG #5690: pg_upgrade fails

Lists: pgsql-bugs
From: Chris English <sglish(at)hotmail(dot)com>
To: pgsql bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: pg_dumpall -> by hand without --binary-upgrade or BUG #5690: pg_upgrade fails
Date: 2010-10-11 23:37:47
Message-ID: SNT117-W18B96A9515D269FD7971A8C5530@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs


> Date: Mon, 11 Oct 2010 16:15:52 -0700> From: pierce(at)hogranch(dot)com> To: sglish(at)hotmail(dot)com> CC: pgsql-bugs(at)postgresql(dot)org> Subject: Re: [BUGS] pg_dumpall -> by hand without --binary-upgrade or BUG #5690: pg_upgrade fails> > On 10/11/10 4:09 PM, Chris English wrote:> >> > C:\WINDOWS\system32>pg_dumpall.exe --port 5433 username--"postgres" > > --schema-onl> > y >"c:/windows/system32/pg_upgrade_dump_all.sql"> > Access is denied.> >> > why are you writing the .sql output to the windows system32 directory?!?!?> > thats a TERRIBLE place to put that.> >C:\WINDOWS\system32>pg_dumpall.exe --port 5432 username--"postgres" --schema-only >"c:/documents and settings/owner/my documents/sql query/9.0/pg_upgrade_dump_all.sql"Access is denied. I take your point though it doesn't advance the solution much. Apologies for the direct reply.Chris