Note: "permalinks" may not be as permanent as we would like,
direct links of old sources may well be a few messages off.
-----Original Message----- From: David Sent: Saturday, 27 August 2005 5:27 AM To: roberto ms Subject: RE: [DRBD-user] Drbd postgresql slave node problem > -----Original Message----- > From: drbd-user-bounces at lists.linbit.com > [mailto:drbd-user-bounces at lists.linbit.com]On Behalf Of roberto ms > Sent: Saturday, 27 August 2005 5:22 AM > To: drbd-user at lists.linbit.com > Subject: [DRBD-user] Drbd postgresql slave node problem > > > Hi, > > I have an active/passive pc setup. > > Everything works just fine, except for pgsql. > > While the master computer is on, I am able to open postgresql. > > However, if I make the other (slave) computer to be the primary one, I am > not able to start > postgres, because the ownership of its directories is changed. > > I get following error: pg_ctl: could not open PID file > ".../data/postmaster.pid": Permission > denied. couple of suggestions... 1) you probaly will just want to delete that pid file anyway, since it is not going to be relevent to the state of the (non-running) pgsql process on the second machine 2) presumably the pgsql directory and its files are owned by the pgsql user so... are the pid/uid numbers for the pgsql user the same on both machines? they will need to be the same otherwise to the pgsql process running on the second system it will appear that they are not owned by pgsql, thus it will not have permission to access them > If I switch back to the master node, then I am able to start postgres. > > It seems to me that DRBD is changing the ownership of postgresql > directories > on > the slave node. > > It looks like I am missing something, but I can´t figure it out. > > I´m using slackware 10. There are no drbd error msg. > > I´d appreciate any help. > > Thanks. > > Roberto Modesto. > > _________________________________________________________________ > Chegou o que faltava: MSN Acesso Grátis. Instale Já! > http://www.msn.com.br/discador > > _______________________________________________ > drbd-user mailing list > drbd-user at lists.linbit.com > http://lists.linbit.com/mailman/listinfo/drbd-user > > !DSPAM:430f7307323351484316874! > > hth David