Hi Yiming The tutorial you mentioned is for Greenplum Database, not for HAWQ. You can find HAWQ documents for 1.3 version in this link.
http://hawq.docs.pivotal.io/ On Sun, Nov 8, 2015 at 4:21 PM, Yiming Liu <[email protected]> wrote: > Hi HAWQ experts, > > I"m trying to deploy HAWQ to my cluster, following the tutorial: > http://gpdb.docs.pivotal.io/4330/install_guide/install_guide.html > > My HAWQ version is 1.3.1.0. But the installation failed, the console shows > "no gpadmin database" when I tried to connect psql. I have on master node, > and three segments nodes. When I checked the log file gpinitsystem.log, I > found there are some warnings when initdb. > I tried to google the source code and found the initdb in HAWQ repo is > just "creating template1 database", but my warning was "create template0 > database". There may be something wrong. Could you give me some help? > > Following are the detail logs: > > 20151108:14:34:47:586892 gpinitsystem:easydmp69:gpadmin-[INFO]:-Start > Function ARRAY_REORDER > 20151108:14:34:47:586892 gpinitsystem:easydmp69:gpadmin-[INFO]:-End > Function ARRAY_REORDER > 20151108:14:34:47:586892 gpinitsystem:easydmp69:gpadmin-[INFO]:-Start > Function CREATE_QD_DB > 20151108:14:34:47:586892 gpinitsystem:easydmp69:gpadmin-[INFO]:-Building > the Master instance database, please wait... > 20151108:14:34:47:586892 > gpinitsystem:easydmp69:gpadmin-[INFO]:-Initializing Master Postgres > instance /data/hawq/master/gpseg-1 > 20151108:14:34:47:586892 gpinitsystem:easydmp69:gpadmin-[INFO]:-Commencing > local /usr/local/hawq/./bin/initdb -E UNICODE -D /data/hawq/master/gpseg-1 > --locale=en_US.utf8 --max_connection > s=250 --shared_buffers=128000kB --is_filerep_mirrored=no > --backend_output=/data/hawq/master/gpseg-1.initdb --content_id=-1 > The files belonging to this database system will be owned by user > "gpadmin". > This user must also own the server process. > > The database cluster will be initialized with locale en_US.utf8. > > creating directory /data/hawq/master/gpseg-1 ... ok > creating subdirectories ... ok > selecting default max_connections ... 250 > selecting default shared_buffers/max_fsm_pages ... 125MB/200000 > creating configuration files ... ok > creating template0 database in /data/hawq/master/gpseg-1/base/1 ... > 2015-11-08 06:34:48.283753 > GMT,,,p591743,th2143004704,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9434, > ok > loading file-system persistent tables for template0 (mirrored = false) ... > 2015-11-08 06:34:53.276569 > GMT,,,p591746,th-949397472,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9434, > ok > initializing pg_authid ... 2015-11-08 06:34:54.387948 > GMT,,,p591749,th-1923487712,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9434, > ok > initializing dependencies ... 2015-11-08 06:34:55.414991 > GMT,,,p591751,th329537568,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9434, > ok > creating system views ... 2015-11-08 06:34:56.604558 > GMT,,,p591753,th128555040,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9434, > ok > loading system objects' descriptions ... 2015-11-08 06:34:57.714915 > GMT,,,p591755,th-134670304,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9434, > ok > creating conversions ... 2015-11-08 06:34:59.020746 > GMT,,,p591759,th1800534048,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9434, > ok > setting privileges on built-in objects ... 2015-11-08 06:35:07.921545 > GMT,,,p591762,th-1349728224,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9434, > ok > creating information schema ... 2015-11-08 06:35:08.803969 > GMT,,,p591765,th-1857652704,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9434, > 2015-11-08 06:35:10.726271 > GMT,,,p591767,th-1193289696,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9434, > ok > creating HAWQ schema ... 2015-11-08 06:35:11.565366 > GMT,,,p591769,th159533088,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9434, > ok > vacuuming database template0 ... 2015-11-08 06:35:12.913042 > GMT,,,p591771,th43874336,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": can > not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9434, > ok > updating content id ... 2015-11-08 06:35:19.245955 > GMT,,,p591775,th136087584,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9434, > ok > > WARNING: enabling "trust" authentication for local connections > You can change this by editing pg_hba.conf or using the -A option the > next time you run initdb. > > Success. You can now start the database server using: > > /usr/local/hawq/./bin/postgres -D /data/hawq/master/gpseg-1 > or > /usr/local/hawq/./bin/pg_ctl -D /data/hawq/master/gpseg-1 -l logfile > start > > > Thank you very much. > > Yiming Liu. -- Best Regards ---------- Zhanwei Wang
