Dear Serge,
I can run all commands of your last reply, but, when i run the command:
/usr/local/pgsql/bin/psql -p 5432 -U postgres postgres -c 'select
now();'
i need input a password, but i don't know what is the password, then i run
the command:
/usr/local/pgsql/bin/psql -p 5432 -U admin postgres -c 'select now();'
And i input the admin's password and voila, i get the date and the time.
What need i do for resolve this?
Best regards,
Carlos Chiriboga Calderon
PD: Im sorry for my bad english.
On Thu, 15 Jan 2009 10:27:02 -0700, "Serge Dubrouski" <[email protected]>
wrote:
> Please try to start it like that:
>
> /usr/local/pgsql/bin/pg_ctl -D /replica/pgdata/data/ -l
> /replica/pglogs/postgres.log -o "-p 5432'" start
>
> And then if it starts check if you can do following:
>
> /usr/local/pgsql/bin/psql -p 5432 -U postgres postgres -c 'select now();'
>
> And see if it works. For some reason pgsql RA doesn't see your instance
> running.
>
> On Thu, Jan 15, 2009 at 10:03 AM, Carlos Eduardo Chiriboga Calderon
> <[email protected]> wrote:
>> Yes, i can start the postgres manually with de command:
>>
>> /usr/local/pgsql/bin/pg_ctl start -D /replica/pgdata/data/
>>
>> My /var/log/messages is attached to his mail.
>>
>> Best regards,
>>
>> Carlos Chiriboga Calderon
>>
>>
>>
>> On Thu, 15 Jan 2009 06:41:43 -0700, "Serge Dubrouski"
> <[email protected]>
>> wrote:
>>> Can you start start PostgreSQL manually outside of the Heartbeat?
>>> What's in the postgres.log file?
>>>
>>> On Wed, Jan 14, 2009 at 11:42 PM, Carlos Eduardo Chiriboga Calderon
>>> <[email protected]> wrote:
>>>>
>>>>
>>>> Hello everyboddy,
>>>> First, i'm sorry for my bad english.
>>>>
>>>> I'm from ecuador and i'm trying configure a ha cluster with 2 nodes,
>>>> the resource are:
>>>>
>>>> IP
>>>>
>>>> filesystem (with a SAN)
>>>>
>>>> apache
>>>>
>>>> postgresql
>>>> The problem is then when i start the cluster, everything go to up,
>>>> but the posgres resource not, in the logs (/var/log/messages) i get
>>>> this:
>>>> Jan 14 23:32:49 ohgyedbs02 pengine: [28713]: WARN: unpack_rsc_op:
>>>> Processing failed op postgres_start_0 on ohgyedbs01: Timed Out
>>>> Jan 14 23:32:49 ohgyedbs02 pengine: [28713]: WARN: unpack_rsc_op:
>>>> Compatability handling for failed op postgres_start_0 on ohgyedbs01
>>>> Jan 14 23:32:49 ohgyedbs02 pengine: [28713]: WARN: unpack_rsc_op:
>>>> Processing failed op postgres_start_0 on ohgyedbs02: Timed Out
>>>> Jan 14 23:32:49 ohgyedbs02 pengine: [28713]: WARN: unpack_rsc_op:
>>>> Compatability handling for failed op postgres_start_0 on ohgyedbs02
>>>> Jan 14 23:32:49 ohgyedbs02 pengine: [28713]: notice: native_print:
>>>> postgres (ocf::heartbeat:pgsql): Stopped
>>>> Jan 14 23:32:49
>>>> ohgyedbs02 pengine: [28713]: WARN: native_color:
>>>> Resource postgres cannot run anywhere
>>>> Someone can say me what is wrong?
>>>>
>>>> My cib.xml is attached to this message with the name "test.xml"
>>>>
>>>> Thanks for your help.
>>>> Best regards,
>>>> Carlos Chiriboga Calderon
>>>> _______________________________________________
>>>> 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
>>
>
>
>
>
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems
