hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lei Chang <chang.lei...@gmail.com>
Subject Re: Install failed when initdb (creating template0 instead template1)
Date Mon, 09 Nov 2015 08:27:39 GMT
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 <liuyiming.vip@foxmail.com>
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"<zwang@pivotal.io>;
> 发送时间: 2015年11月9日(星期一) 上午9:46
> 收件人: "dev"<dev@hawq.incubator.apache.org>;
> 主题: 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 <liuyiming.vip@foxmail.com>
> 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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message