[Postgres-xl-bugs] Various issues with the tutorial and pgxc_ctl

Pavan Deolasee pavan.deolasee at gmail.com
Tue Mar 1 07:51:43 PST 2016


On Tue, Mar 1, 2016 at 8:29 PM, Ernst-Georg Schmid <
ernst.georg.schmid at googlemail.com> wrote:

> Hello,
>
> I've installed the Beta of postgres-xl 9.5 on Ubuntu 14.04.3 and faced
> several issues with the tutorial:
> http://files.postgres-xl.org/documentation/tutorial-createcluster.html
>
> 1.) Failure
>
> If you don't run as user 'postgres', pgxc_ctl fails at several stages,
> because it then tries to connect to non existing databases named like the
> user. It doesn't work as the tutorial shows.
>
> Since the 'postgres' database always exists, only the 'postgres' user
> works for all the steps that follow!
>
>
You can change the user in pgxc_ctl configuration file.

pgxcOwner=$USER
pgxcUser=$pgxcOwner


> 2.) Failure
>
> pgxc_ctl
> /bin/bash
> Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash.
> ERROR: File "/home/postgres/pgxc_ctl/pgxc_ctl.conf" not found or not a
> regular file. No such file or directory
> Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash.
> Reading configuration using /home/postgres/pgxc_ctl/pgxc_ctl_bash --home
> /home/postgres/pgxc_ctl --configuration
> /home/postgres/pgxc_ctl/pgxc_ctl.conf
> Finished reading configuration.
>    ******** PGXC_CTL START ***************
>
> Current directory: /home/postgres/pgxc_ctl
> PGXC
>
> The output shown in the tutorial only shows, if a configuration was
> already generated.
>
>
This is ok, though I'm sure we can improve it.


>
>
> testdb=# CREATE TABLE disttab(col1 int, col2 int, col3 text) DISTRIBUTE BY
> HASH(col1);
> CREATE TABLE
> testdb=# CREATE TABLE repltab (col1 int, col2 int) DISTRIBUTE BY
> REPLICATION;
> CREATE TABLE
> testdb=# INSERT INTO disttab VALUES (generate_series(1,100),
> generate_series(101, 200), 'foo');
> ERROR:  set-valued function called in context that cannot accept a set
> testdb=# INSERT INTO repltab VALUES (generate_series(1,100),
> generate_series(101, 200));
> INSERT 0 100
>
> I could create the tables, but only insert into 'repltab'. INSERT into
> 'disttab' fails with the error message shown above. I cannot reproduce this
> with a vanilla PostgreSQL 9.5 where the INSERT syntax is accepted without
> problems.
>
>
Yeah, XL has trouble supporting this syntax because the way functions are
executed. The following should work, which does exactly the same thing:

INSERT INTO disttab SELECT generate_series(1,100), generate_series(101,
200), 'foo';


I might have done something wrong but since I followed the tutorial step by
> step, I suspect that either the tutorial does not match the current
> pgxc_ctl anymore or that pgxc_ctl has issues.
>
>
I think the documentation requires some work. Please feel free to submit a
patch based on your experience.

Thanks,
Pavan

-- 
 Pavan Deolasee                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-bugs-postgres-xl.org/attachments/20160301/5bf9fc0a/attachment.htm>


More information about the postgres-xl-bugs mailing list