[Postgres-xc-general] How to import database in postgre-xc

[Juned K. <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