it will say "database postgres does not exist"
------------------ Original ------------------ From: "Lei Chang";<[email protected]>; Date: Mon, Nov 9, 2015 04:27 PM To: "dev"<[email protected]>; Subject: Re: Install failed when initdb (creating template0 instead template1) Looks your database has been created. Can you try "psql -d postgres"? Cheers Lei On Mon, Nov 9, 2015 at 11:13 AM, Yiming Liu <[email protected]> wrote: > My mistake. Thank you, I did follow the HAWQ tutorial: > http://hawq.docs.pivotal.io/docs-hawq/topics/install-ambari.html, > installed by Ambari. I have no idea why the log shows "creating template0 > database in /data/hawq/master/gpseg-1/base/1 ...". But the initdb source > code (at > https://github.com/apache/incubator-hawq/blob/96779dd2ecd6a215da8789079116915caa99d408/src/bin/initdb/initdb.c > line 1547) has only the code "printf(_("creating template1 database in > %s/base/1 ... "), pg_data);" > > > > > ------------------ ???????? ------------------ > ??????: "Zhanwei Wang"<[email protected]>; > ????????: 2015??11??9??(??????) ????9:46 > ??????: "dev"<[email protected]>; > ????: Re: Install failed when initdb (creating template0 instead template1) > > > > 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 >
