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
