nkiraly/DBSteward — Issue #2: Need example of "slurp"
Author: cbbrowne
Created: 2012-02-14 20:09:30+00:00
State: open

It appears that there's a fair bit more than meets the eye involved in "slurping" out a database from an existing Postgres instance.

Attempts to do so are getting rebuffed with the complaint that DBSteward doesn't know about the built in roles:

cbbrowne% dbsteward --pgschema --dbhost=127.0.0.1 --dbuser=pgsql --dbname=oxrsdb --dbpassword="pass"
PHP Deprecated: Call-time pass-by-reference has been deprecated in /usr/share/php/DBSteward/sql_format/mssql10/mssql10_diff_tables.php on line 99
[DBSteward-1] Connecting to 127.0.0.1:oxrsdb as pgsql
Unhandled exception:

Unknown role translation: oxrs_owner

#0 /usr/share/php/DBSteward/sql_format/pgsql8/pgsql8.php(1143): pgsql8->pgschema_role_translate('oxrs_owner')
#1 /usr/share/php/DBSteward/dbsteward.php(291): pgsql8->fetch_pgschema('127.0.0.1', 'oxrsdb', 'pgsql', 'pass')
#2 /usr/bin/dbsteward.php(33): dbsteward->arg_parse()
#3 /usr/bin/dbsteward(4): require('/usr/bin/dbstew...')
#4 {main}

If we're slurping data out of a database, its contents are, defacto, deemed correct. Should this not simply take the users that are defined in the database, and use them?