I didn't do anything specific to load those functions into template1.
I was under the impression that that particular debugger wasn't
supposed to be on by default on windows - and that it was an installer
oversight - and that you may turn it off by default for future builds
of the windows installe
"Dan Armbrust" <[EMAIL PROTECTED]> writes:
> If I disable that debugger library in the config file, create a
> database, backup the database, and then restore the database, I get
> many errors - all similar to the one I posted before.
Perhaps you've got those functions loaded into template1?
> Ar
Dan Armbrust escribió:
> Sorry, I don't follow.
>
> If I disable that debugger library in the config file, create a
> database, backup the database, and then restore the database, I get
> many errors - all similar to the one I posted before.
>
> They are reported at the end of the restore as erro
Sorry, I don't follow.
If I disable that debugger library in the config file, create a
database, backup the database, and then restore the database, I get
many errors - all similar to the one I posted before.
They are reported at the end of the restore as errors.
Are you saying they are really j
"Dan Armbrust" <[EMAIL PROTECTED]> writes:
> It turns out, that commenting out the "shared_preload_libraries" in
> the postgresql.conf file breaks pg_restore.
It hardly "breaks" anything. The errors you show just indicate that you
had the plpgsql debugger loaded into your database.
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" <[EMAIL PROTECTED]> 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
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
