postgresql - 致命 : password authentication when bucardo add tables

Question

系统规范:

• Ubuntu 14.04
• bucardo 版本 4.99.10
• psql (PostgreSQL) 9.3.14

到目前为止我尝试了什么？

我已经用 openerp postgres 用户创建了 master 数据库。

- Setup Source Database

    export SOURCE_HOST=localhost
    export SOURCE_PORT=5432  
    export SOURCE_DATABASE=master
    export SOURCE_USERNAME=openerp  
    export SOURCE_PASSWORD=openerp

- Setup Destination Database

    export DEST_HOST=localhost 
    export DEST_PORT=5432  
    export DEST_DATABASE=slave  
    export DEST_USERNAME=openerp  
    export DEST_PASSWORD=openerp    

- Finally, the tables to be migrated

    export TABLES="-t res_partner"

    export TABLES_WITH_SPACES="res_partner"

- Set up the Destination Database

    cat >> $HOME/.pgpass <<EOL  
    $DEST_HOST:$DEST_PORT:$DEST_DATABASE:$DEST_USERNAME:$DEST_PASSWORD
    $SOURCE_HOST:$SOURCE_PORT:$SOURCE_DATABASE:$SOURCE_USERNAME:$SOURCE_PASSWORD
    EOL  

- Create schema.sql 

- Create Slave database

- Load schema into Slave

- Setting up Bucardo Sync (Source Database and  Destination Database) 

- Now I am trying to add the tables we want to migrate and add them to a "copying herd"

    ./bucardo add tables res_partner db=master

出现以下错误:

openerp@odedra-Lenovo-Z50-70:/usr/local/src/bucardo$ ./bucardo add tables res_partner db=master DBI connect('dbname=master;host=localhost;port=5432','openerp',...) failed: FATAL: password authentication failed for user "openerp" FATAL: password authentication failed for user "openerp" at ./bucardo line 8632.

我有解析脚本bucardo。我对在第 84、85 行声明的 dbuser 和 dbpass 变量感到困惑。

(I have tried with dbuser = 'openerp' and dbpass='openerp' but result same)

我的pg_hba.conf

# Database administrative login by Unix domain socket
local   all             postgres                                ident

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication     postgres                                peer
#host    replication     postgres        127.0.0.1/32            md5
#host    replication     postgres        ::1/128                 md5

数据库列表:

                                   List of databases
    Name     |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   
-------------+----------+----------+-------------+-------------+-----------------------
 bucardo     | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 master      | openerp  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 postgres    | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 slave       | openerp  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 slave_copy  | openerp  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 slave_copy1 | openerp  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 slave_copy2 | openerp  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0   | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
             |          |          |             |             | postgres=CTc/postgres
 template1   | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
             |          |          |             |             | postgres=CTc/postgres

您可以指导我应该更改哪些内容来修复上述错误或有用的相关链接吗？

如何使用 Bucardo 实现主从功能？

Answer 1

我发现 pg_hba.conf 文件有问题。为了解决错误，我在该文件中添加了以下行。

local   all             openerp                                ident