0

I have tried to create postgres-xc cluster database.So i followed their documentation do that (http://postgres-xc.sourceforge.net/docs/1_1/install-short.html)

After following that documentation procedure I'm not able to create node. I'm getting the following error:

ERROR: syntax error at or near "NODE"

when running following command

/usr/local/pgsql/bin/psql -c "CREATE NODE datanode1 WITH (TYPE = 'datanode', PORT = 15432)" postgres

Can anyone help me to do solve this.

sachin
  • 13,605
  • 14
  • 42
  • 55

1 Answers1

1

I suspect a_horse_with_no_name is right. postgres-xc and postgresql are different codebases and you can't run CREATE NODE on PostgreSQL and have it work. You must be running Postgres-XC.

To find out, run SELECT version() from psql.

To install Postgres-XC the first step is to actually install the Postgres-XC software either from packages or from source (by compiling).

Chris Travers
  • 25,424
  • 6
  • 65
  • 182