Re: [Postgres-xc-general] postgres-xc 0.9.7 : failed to connect to data node/can not connect to datanode 0

[Ashutosh B. <ash...@en...>]

Thanks Phil.

On Wed, Apr 25, 2012 at 3:43 AM, Phil Somers <phi...@ne...> wrote:
> Ashutosh,
>
> We have a standalone postgreSQL db host (v9.0.6) we are currently using for
> QA functional testing.  I used the databases on this host as the source
> db's.  I used pg_dump to dump each QA database to their respective SQL
> files.  I then copied these SQL files over to db_VM1 of the postgres-xc db
> host cluster.  I then used psql to load the SQL files into the test db's I
> had already created on db_VM1.  I then logged onto db_VM2 to verify the
> pg_dump SQLs had been applied to this db node and everything looked good.
>
> However, I subsequently noticed that all the unique constraints on the QA db
> tables did not get applied to the postgres-xc db tables.  I am currently
> looking into fixing this issue.  This appears to be the only issue
> encountered so far since fixing the connection pooling issue.
>
> Thanks,
> Phil.
>
>
> On 4/23/12 3:32 AM, Ashutosh Bapat wrote:
>
>
>>>
>>> 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.
>
>
> Can you please enlist the steps you took to load the databases? From where
> did you dump the data? in which format? How did you load it (depends upon
> format). I think, we can use this as a example case, for those who want to
> move from PostgreSQL to Postgres-XC.
>
>>>
>>>
>>> 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
>>
>>
>> ------------------------------------------------------------------------------
>> For Developers, A Lot Can Happen In A Second.
>> Boundary is the first to Know...and Tell You.
>> Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
>> http://p.sf.net/sfu/Boundary-d2dvs2
>> _______________________________________________
>> Postgres-xc-general mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>>
>
>
>
> --
> Best Wishes,
> Ashutosh Bapat
> EntepriseDB Corporation
> The Enterprise Postgres Company
>



-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Enterprise Postgres Company