Description of problem: spacewalk-dump-schema does not support intuitive way to specify external/managed PostgreSQL hostname and port. Version-Release number of selected component (if applicable): spacewalk-utils-2.3.2-10.el6sat.noarch How reproducible: always Steps to Reproduce: 1. Have PostgreSQL database on different machine or port 2. Try to run spacewalk-dump-schema on it Actual results: You can connect only with knowledge of Perl code and PostgreSQL library: spacewalk-dump-schema --from=postgresql --db="spacesatschema;host=guest;port=5432" --user=spacesatuser --password=spacesatpw You have to stack it into --db parameter. Expected results: Have additional parameters to specify host and port.
fixed in spacewalk master: a1e39941d4588db30f1d9e86ab3760d4bb175851
RE-VERIFIED on Satellite-5.7.0-RHEL6-re20150105.1 (spacewalk-utils-2.3.2-13.el6sat). > spacewalk-dump-schema --help Usage: /usr/bin/spacewalk-dump-schema [--from=oracle] [--to=DB_BACKEND] [--db=SID --user=USERNAME --password=PASSWORD] /usr/bin/spacewalk-dump-schema [--from=postgresql] [--to=DB_BACKEND] [--db=DBNAME --host=HOSTNAME --port=PORT --user=USERNAME --password=PASSWORD] /usr/bin/spacewalk-dump-schema [ --help ] > man spacewalk-dump-schema <MAN> ... spacewalk-dump-schema [--from=postgresql] [--to=DB_BACKEND] [--db=DBNAME --host=HOSTNAME --port=PORT --user=USERNAME --pass word=PASSWORD] ... spacewalk-dump-schema --to=oracle --db=spaceschema \ --host=localhost --port=5433 \ --user=spaceuser --password=o9k2HInsl \ | NLS_LANG=AMERICAN_AMERICA.UTF8 sqlplus spaceuser/spacepw@//localhost/XE </MAN> > spacewalk-dump-schema --from=postgresql --to=oracle --db=spaceschema --host=ext-pg.redhat.com --port=5432 --user=spaceuser --password=xxx > /tmp/schema-oracle.dump > ls -lh /tmp/schema-oracle.dump -rw-r--r--. 1 root root 742M Jan 9 13:50 /tmp/schema-oracle.dump
With the release of Red Hat Satellite 5.7 on January 12th 2015 this bug is being moved to a Closed Current Release state. The Satellite 5.7 GA Errata: - https://rhn.redhat.com/errata/RHSA-2015-0033.html Satellite 5.7 Release Notes: - https://access.redhat.com/documentation/en-US/Red_Hat_Satellite/5.7/html-single/Release_Notes/index.html Satellite Customer Portal Blog announcement for release: - https://access.redhat.com/blogs/1169563/posts/1315743 Cliff