Ok, it turns out that the fact that my pg_restore won't work on windows is directly related to this (from a couple days ago) "Dan Armbrust" <daniel.armbrust.list@xxxxxxxxx> writes: > To follow up on my old thread - > I tested another install of Postgres 8.3.0.1 - and on windows, the > postgresql.conf file has this in it: > shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' # > (change requires restart) > I got the impression that that debugger wasn't intended to be enabled, > by default. It looks like the windows installer is enabling it, > however. It turns out, that commenting out the "shared_preload_libraries" in the postgresql.conf file breaks pg_restore. So, perhaps that shouldn't be disabled by default in the installer. Dan On Thu, Feb 28, 2008 at 5:13 PM, Dan Armbrust <daniel.armbrust.list@xxxxxxxxx> wrote: > Using PostgreSQL 8.3 on Windows, I make a backup like this: > pg_dump -U postgres -C -d -D -Fc -f ispaaa-pg.bak ispaaa > > Then restore like this: > pg_restore -U postgres -C -d template1 -v -Fc ispaaa-pg.bak > > And I get lots of these errors: > > > pg_restore: creating TABLE voip > pg_restore: creating FUNCTION pldbg_abort_target(integer) > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 21; 1255 16419 > FUNCTION pldbg_abort_target(integer) postgres > pg_restore: [archiver (db)] could not execute query: ERROR: could not > load library "C:/Program Files (x86)/PostgreSQL/8.3/lib/pldbgapi.dll": > The specified module could not be found. > > Command was: CREATE FUNCTION pldbg_abort_target(session integer) RETURNS SET > OF boolean > AS '$libdir/pldbgapi', 'pldbg_abort_target' > ... > pg_restore: [archiver (db)] could not execute query: ERROR: function public.pld > bg_abort_target(integer) does not exist > Command was: ALTER FUNCTION public.pldbg_abort_target(session integer) OWNER > TO postgres; > > > It looks like a packaging issue with the windows installer - these > commands work fine for me on Linux. > > Thanks, > > Dan > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
