When I start postgresql seems ok: r...@ubuntu01:~# /etc/init.d/postgresql-8.4 start * Starting PostgreSQL 8.4 database server [ OK ]
Then, when I run psql command come problems: r...@ubuntu02:~# psql psql: FATAL: Ident authentication failed for user "root" If I do that whit user postgres all is ok: r...@ubuntu02:~# su - postgres postg...@ubuntu02:~$ psql psql (8.4.3) Type "help" for help. These are my tables: postgres=# \l List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------+----------+-----------+-----------+-------+----------------------- postgres | postgres | SQL_ASCII | C | C | template0 | postgres | SQL_ASCII | C | C | =c/postgres : postgres=CTc/postgres template1 | postgres | SQL_ASCII | C | C | =c/postgres : postgres=CTc/postgres And this is mi pg_hba.conf: # Database administrative login by UNIX sockets local all postgres ident # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all ident # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 Thanks! On 17 May 2010 16:16, Serge Dubrouski <serge...@gmail.com> wrote: > As Dejan pointed out something is wrong with your PostgreSQL > installation, it doesn't start with configuration provided. Can you > start it outside of Pacemaker? Does it have template1 database > available? > > > On Mon, May 17, 2010 at 5:39 AM, Jose <jfcastrol...@gmail.com> wrote: >> On 17 May 2010 13:10, Florian Haas <florian.h...@linbit.com> wrote: >>> On 2010-05-17 12:09, Dejan Muhamedagic wrote: >>>>> config="/etc/postgresql/8.4/main/postgresql.conf" \ >>> >>>>> OCF_RESKEY_config=/etc/postgresql/8.4/main/pg_hba.conf >>> >>> Those don't match. Fix and retry. >> >> Yes, it was a typo. I have: >> >> config="/etc/postgresql/8.4/main/postgresql.conf" >> >> And it doesn't work :( >> >>> Florian >>> >>> >>> _______________________________________________ >>> Linux-HA mailing list >>> Linux-HA@lists.linux-ha.org >>> http://lists.linux-ha.org/mailman/listinfo/linux-ha >>> See also: http://linux-ha.org/ReportingProblems >>> >> _______________________________________________ >> Linux-HA mailing list >> Linux-HA@lists.linux-ha.org >> http://lists.linux-ha.org/mailman/listinfo/linux-ha >> See also: http://linux-ha.org/ReportingProblems >> > > > > -- > Serge Dubrouski. > _______________________________________________ > Linux-HA mailing list > Linux-HA@lists.linux-ha.org > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems > _______________________________________________ Linux-HA mailing list Linux-HA@lists.linux-ha.org http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems