You need to specify coordinator's host and port with -h and -p option
respectively. Otherwise, psql will assume local host and 5432 for
these parameter, which you have not configured.
When you create tables (this is mostly done in the above case),
Postgres-XC assumes each table is distributed by the first column.
You can correct this afterwords with ALTER TABLE. If you'd like to
distribute/replicate tables, you should run CREATE TABLE in advance.
Then data will be distributed as you wish from the scratch.
Regards;
---
Koichi Suzuki
2014-03-14 9:08 GMT+00:00 Juned Khan <jkh...@gm...>:
> Hi All,
>
> I have just setup postgre-xc with four servers for testing.
> but i have some questions regarding import process.
>
> I just found this link to backup and dump
> http://postgres-xc.sourceforge.net/docs/1_0/backup-dump.html
>
> my question is do i need to specifu coordinator name or datanode name
> or port for restoring dump file?
>
> If i don't specify datanode and port then where this data will be imported ?
>
> PGXC psql -d astpp /home/postgres/itn-gtm.sql
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> PGXC psql astpp < /home/postgres/itn-gtm.sql
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> I have dump of postgresql database which i want to import in postgre-xc
> but its gving me above error
>
> So here what i need to do make it working ?
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/13534_NeoTech
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
|
