Dear Serge, It's solved
A lot of thanks Best regards, Carlos Chiriboga Calderon On Thu, 15 Jan 2009 11:48:40 -0700, "Serge Dubrouski" <[email protected]> wrote: > You need to have something like this: > > host all all 127.0.0.1/32 ident sameuser > > in your pg_hba. That would allow local OS users to connect to the > database without passwords. > > On Thu, Jan 15, 2009 at 11:35 AM, Carlos Eduardo Chiriboga Calderon > <[email protected]> wrote: >> >> 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 >> > > > > _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
