Le 23/02/2011 22:58, Micka a écrit : > I tried to test the pcp command myself : > > mickael@PTI2:/usr/local/bin$ psql -U postgres > psql (9.0.3) > Type "help" for help. > > postgres=# ALTER USER postgres WITH PASSWORD 'toto'; > ALTER ROLE > postgres=# \q > mickael@PTI2:/usr/local/bin$ pcp_recovery_node -d 10 localhost 9898 postgres > toto 1 > DEBUG: send: tos="R", len=46 > DEBUG: recv: tos="r", len=63, data=AuthenticationFailed > DEBUG: authentication failed. reason=AuthenticationFailed > AuthorizationError > > But nothing more, I don't understand why I got the AuthorizationError. >
PCP authorization has nothing to do with PostgreSQL users and passwords. You set user and password in pcp.conf (user in clear text, password in md5). You need to use pg_md5 to hash the password. -- Guillaume http://www.postgresql.fr http://dalibo.com _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
