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 > -- Serge Dubrouski. _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
