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

[Phil S. <phi...@ne...>]

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...
>     <mailto:Pos...@li...>
>     https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>
>
>
> -- 
> Best Wishes,
> Ashutosh Bapat
> EntepriseDB Corporation
> The Enterprise Postgres Company
>