Ok. Are there any error messages in the PostgerSQL log files when you try to start it with pgsql RA? And is your data directory really /var/lib/postgresql/8.4/main/ or /var/lib/postgresql/8.4/main//data ? What's in that directory?
Actually how do you synchronize data directory between the nodes? On Mon, May 17, 2010 at 8:51 AM, Jose <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> wrote: >>> On 17 May 2010 13:10, Florian Haas <[email protected]> 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 >>>> [email protected] >>>> http://lists.linux-ha.org/mailman/listinfo/linux-ha >>>> See also: http://linux-ha.org/ReportingProblems >>>> >>> _______________________________________________ >>> Linux-HA mailing list >>> [email protected] >>> http://lists.linux-ha.org/mailman/listinfo/linux-ha >>> See also: http://linux-ha.org/ReportingProblems >>> >> >> >> >> -- >> Serge Dubrouski. >> _______________________________________________ >> Linux-HA mailing list >> [email protected] >> http://lists.linux-ha.org/mailman/listinfo/linux-ha >> See also: http://linux-ha.org/ReportingProblems >> > _______________________________________________ > Linux-HA mailing list > [email protected] > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems > -- Serge Dubrouski. _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
