pg_upgrade issues
От | |
---|---|
Тема | pg_upgrade issues |
Дата | |
Msg-id | 29F36C7C98AB09499B1A209D48EAA615B49DD7A5C6@mail2a.alliedtesting.com обсуждение исходный текст |
Ответы |
Re: pg_upgrade issues
|
Список | pgsql-bugs |
PostgreSQL 9.0 beta 2 Windows XP Professional SP2 While migrating the database from 8.4 to 9.0 using pg_upgrade (now part of = the Postgres project), the following issues came up: 1. When using the --logfile option, pg_upgrade quits with an error like thi= s: The process cannot access the file because it is being used by another proc= ess. There were problems executing ""C:\PostgreSQL\8.4\bin/pg_ctl" -l "pg_upgrad= e.log " -D "D:\PostgreSQL84_matlab1b" -o "-p 5432 -c autovacuum=3Doff -c autovacu= um_free ze_max_age=3D2000000000" start >> "pg_upgrade.log" 2>&1" 2. Although pg_upgrade has a username option, this option is not used when = pg_dump is called, which tries to use the current logon account name as the= user name. As a result, pg_upgrade can only be used when the command shell= is launched under the postgres account. (I know that this is mentioned on = the doc page, but this doesn't seem right). 3. The old database had the pgadmin debugger installed. The module is part = of 8.4 and 9.0 distributions for Windows. However, pg_upgrade reported the = following error: ERROR: could not load library "C:/PostgreSQL/9.0/lib/pldbgapi.dll": The sp= ecified module could not be found. I had to uninstall the debugger from the old database before I could procee= d.
В списке pgsql-bugs по дате отправления: