Can not upgrade database with password only with ident authentication

[Ronald Portier (Therp)]

When trying to upgrade a server configuration where the postgress database is secured by a password (not approached through ident/peer authentication) an exception occurs:

openeyedev@laptop01:~/var/oe_repo/checkouts/openupgrade-server-7.0/openupgrade-server-7.0/scripts$ ./migrate.py -C ~/var/projects/oe_dapper/project.cfg -D oe_dapper_dev -R "7.0"
No handlers could be found for logger "bzr"
getting lp:openerp-web/7.0
getting lp:openupgrade-addons/7.0
getting lp:openupgrade-server/7.0
copying database oe_dapper_dev to oe_dapper_dev_migrated...
Traceback (most recent call last):
  File "./migrate.py", line 188, in <module>
    conn=psycopg2.connect(database=db_name, user=db_user)
  File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect
    connection_factory=connection_factory, async=async)
psycopg2.OperationalError: FATAL: Peer authentication failed for user "oe_dapper_dev"

[Holger Brunn (Therp) (hbrunn)]

Thanks, that's indeed not covered at the moment.

As this is only the cloning part, you still should be able to run the migration(s) with the -I switch. But then of course you'll have to take care of making the copy yourself, as you certainly don't want to run the migration on the original database.