pgsql-server/src/bin/scripts Tag: REL7_3_STABL ... - Mailing list pgsql-committers

CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    momjian@svr1.postgresql.org    03/09/29 15:53:08

Modified files:
    src/bin/scripts: Tag: REL7_3_STABLE clusterdb

Log message:
    [ Patch applied only to 7.3.X.]

    Hi There's a bug in the clusterdb script where it looks like the arguments
    to the psql command are being passed in the wrong order, so it fails when
    you run it on a database that is not on localhost.
    Here's the output from the command:

    133 anands-Computer:bin/scripts> clusterdb -h wooster -U rr granada
    psql: warning: extra option wooster ignored
    psql: warning: extra option -U ignored
    psql: warning: extra option rr ignored
    psql: warning: extra option -F: ignored
    psql: warning: extra option -P ignored
    psql: warning: extra option format=unaligned ignored
    psql: warning: extra option -t ignored
    psql: warning: extra option -c ignored
    psql: warning: extra option SELECT nspname, pg_class.relname,
    pg_class_2.relname FROM pg_class, pg_class AS pg_class_2 JOIN pg_namespace
    ON (pg_namespace.oid=relnamespace), pg_index WHERE
    pg_class.oid=pg_index.indrelid AND pg_class_2.oid=pg_index.indexrelid AND
    pg_index.indisclustered AND pg_class.relowner=(SELECT usesysid FROM
    pg_user WHERE usename=current_user) ignored
    psql: FATAL:  user "-h" does not exist

    I'm attaching a patch that fixes the problem. The diff was run on
    postgresql 7.3.4

    Thanks a lot.
    Anand Ranganathan