From: Michael P. <mic...@gm...> - 2012-04-21 01:25:16
|
On Sat, Apr 21, 2012 at 3:19 AM, Phil Somers <phi...@ne...> wrote: > I turned up the logging on both coord/datanode VMs as per your suggestion > but nothing of any significance was noted. > > In attempts to troubleshoot the issue, I then updated the node > initialization removing the remote nodes on each VM. Once I did this, the > CREATE DATABASE sql would run clean but only get created on the local node, > which made sense, seeing only the local datanode was configured in the > pgxc_node catalog. > > Seeing it was probably network related, one of my SA co-workers took a > thorough look at the network configs on each VM and found that one of the > VMs had an additional NIC configured called virbr0. This apparently > occured when VMTools was installed on this host (another SA was testing out > the VMTool suite a while back and used this VM to run his tests). > > I disabled and removed the virbr0 NIC. I then had to edit the pg_hba.conf > hosts on coord1, data1, coord2 and data2 as follows: > > host all all 192.168.38.0/24 trust > > I had originally added it as 'host all all 192.168.38.0*/32* trust' but > the /32 was causing issues where postgres-xc couldn't find the hosts > properly. > OK. Good to know you found the origin of the problem. Once I did all this and updated the node initialization to include the > remote hosts on each VM, the CREATE DATABASE SQL ran clean. > > I have subsequently created 3 test db's, numerous login roles, numerous > group roles and loaded pg_dump backups into each test db on one of the db > VMs. The second db VM was then accessed and all db objects that were > created on the remote db VM had successfully been created on the db VM I > was accessing. As well, all the data on the remote db VM had successfully > been loaded into the db VM I was accessing. > > Postgres-XC is working great so far!! > Thanks for your feedback. It is appreciated too. Don't forget that we released 1.0beta1, we have more features in so you might try it. Regards, -- Michael Paquier http://michael.otacoo.com |