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