温馨提示！由于新浪微博认证机制调整，您的新浪微博帐号绑定已过期，请重新绑定！&&|&&
Free PostgreSQL Support.
LOFTER精选
Postgre-XL单节点集群创建表空间也没有问题, 原因是XL对表空间目录名做了修改, 添加了xl的节点名,&PGXCNodeName.代码如下 :&src/backend/catalog/catalog.c#ifdef PGXC& & & & & & & & & & & & /* Postgres-XC tablespaces include node name in path */& & & & & & & & & & & & strlen(PGXCNodeName) + 1 +#endif#ifdef PGXC& & & & & & & & & & & & if (forknum != MAIN_FORKNUM)& & & & & & & & & & & & & & & & snprintf(path, pathlen, "pg_tblspc/%u/%s_%s/%u/%u_%s",& & & & & & & & & & & & & & & & & & & & & & & & &rnode.spcNode, TABLESPACE_VERSION_DIRECTORY,& & & & & & & & & & & & & & & & & & & & & & & & &PGXCNodeName,& & & & & & & & & & & & & & & & & & & & & & & & &rnode.dbNode, rnode.relNode,& & & & & & & & & & & & & & & & & & & & & & & & &forkNames[forknum]);& & & & & & & & & & & & else& & & & & & & & & & & & & & & & snprintf(path, pathlen, "pg_tblspc/%u/%s_%s/%u/%u",& & & & & & & & & & & & & & & & & & & & & & & & &rnode.spcNode, TABLESPACE_VERSION_DIRECTORY,& & & & & & & & & & & & & & & & & & & & & & & & &PGXCNodeName,& & & & & & & & & & & & & & & & & & & & & & & & &rnode.dbNode, rnode.relNode);创建表空间目录 :&mkdir /ssd4/pgxl/tbs_test在coordinator节点创建表空间.pgxl@db-172-16-3-150-& psql -p 11921 postgres postgrespsql (PGXL 9.2.0, based on PG 9.2.4 (Postgres-XL 9.2.0))Type "help" for help.postgres=# create tablespace tbs_test location '/ssd4/pgxl/tbs_test';CREATE TABLESPACE可以看到, 路径不会出现重复.pgxl@db-172-16-3-150-& cd $PGDATApgxl@db-172-16-3-150-& cd pg_tblspc/pgxl@db-172-16-3-150-& lltotal 0lrwxrwxrwx 1 pgxl pgxl 19 Jul 25 11:40 16484 -& /ssd4/pgxl/tbs_testpgxl@db-172-16-3-150-& cd 16484/pgxl@db-172-16-3-150-& lltotal 20Kdrwx------ 3 pgxl pgxl 4.0K Jul 25 11:41 PG_9.2__c11921drwx------ 3 pgxl pgxl 4.0K Jul 25 11:41 PG_9.2__d11922drwx------ 3 pgxl pgxl 4.0K Jul 25 11:41 PG_9.2__d11923drwx------ 3 pgxl pgxl 4.0K Jul 25 11:41 PG_9.2__d11924drwx------ 3 pgxl pgxl 4.0K Jul 25 11:41 PG_9.2__d11925创建数据库pgxl@db-172-16-3-150-& psql -h 127.0.0.1 -p 11921 postgres postgrespsql (PGXL 9.2.0, based on PG 9.2.4 (Postgres-XL 9.2.0))Type "help" for help.postgres=# create database test template template0 encoding 'UTF8' tablespace tbs_CREATE DATABASE创建测试表postgres=# \c test&You are now connected to database "test" as user "postgres".test=# create table t1(id int primary key, info text, crt_time timestamp) distribute by hash(id) to group gp1;NOTICE: &CREATE TABLE / PRIMARY KEY will create implicit index "t1_pkey" for table "t1"CREATE TABLE创建用户create role digoal superuser encrypted password 'digoal';[参考]1.&
阅读(352)|
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
历史上的今天
在LOFTER的更多文章
loftPermalink:'',
id:'fks_',
blogTitle:'Postgres-XL use unique_node_name can create database, tablespace on single host.',
blogAbstract:'在使用Postgres-XL时, 担心单主机的测试环境创建表空间带来重复目录的问题, 其实不然.Postgre-XL单节点集群创建表空间也没有问题, 原因是XL对表空间目录名做了修改, 添加了xl的节点名,&PGXCNodeName.代码如下 :&src/backend/catalog/catalog.c#ifdef PGXC& & & & & & & & & & & & /* Postgres-XC tablespaces include node name in path */& & &',
blogTag:'',
blogUrl:'blog/static/',
isPublished:1,
istop:false,
modifyTime:9,
publishTime:5,
permalink:'blog/static/',
commentCount:0,
mainCommentCount:0,
recommendCount:0,
bsrk:-100,
publisherId:0,
recomBlogHome:false,
currentRecomBlog:false,
attachmentsFileIds:[],
groupInfo:{},
friendstatus:'none',
followstatus:'unFollow',
pubSucc:'',
visitorProvince:'',
visitorCity:'',
visitorNewUser:false,
postAddInfo:{},
mset:'000',
remindgoodnightblog:false,
isBlackVisitor:false,
isShowYodaoAd:false,
hostIntro:'Free PostgreSQL Support.',
hmcon:'1',
selfRecomBlogCount:'0',
lofter_single:''
{list a as x}
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{list a as x}
推荐过这篇日志的人：
{list a as x}
{if !!b&&b.length>0}
他们还推荐了：
{list b as y}
转载记录：
{list d as x}
{list a as x}
{list a as x}
{list a as x}
{list a as x}
{if x_index>4}{break}{/if}
${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{list a as x}
{if !!(blogDetail.preBlogPermalink)}
{if !!(blogDetail.nextBlogPermalink)}
{list a as x}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
{list a as x}
{var first_option =}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if}&&“${b[voteToOption_index]}”&&
{if (x.role!="-1") },“我是${c[x.role]}”&&{/if}
&&&&&&&&${fn1(x.voteTime)}
{if x.userName==''}{/if}
网易公司版权所有&&
{list x.l as y}
{if defined('wl')}
{list wl as x}{/list}The USGS Water Science School
& to previous page
Water Questions & Answers
Water at Home
Floods, droughts, glaciers:
Water Questions & AnswersHow much water does the average person use at home per day?
Estimates vary, but each person uses about 80-100 gallons of water per day. Are you surprised that the largest use of household water is to flush the toilet, and after that, to take showers and baths? That is why, in these days of water conservation, we are starting to see toilets and showers that use less water than before.
Many local governments now have laws that specify that water faucets, toilets, and showers only allow a certain amount of water flow per minute. Water agencies in some areas, such as here in Atlanta, Georgia, offer rebates if you install a water-efficient toilet. In fact, I just put in two new toilets and received a rebate of $100 for each. Yes, they really do use a lot less water. For your kitchen and bathroom faucets, if you look real close at the head of a faucet, you might see something like &1.0 gpm&, which means that the faucet head will allow water to flow at a maximum of 1.0 gallons per minute.
NOTE: Our data here is very general in nature...just to give you a quick idea of your water use. There are some other Web sites that will give you a much more detailed and accurate estimate of your per-capita water use:
Typical water use at home
BathA full tub is about 36 gallons.
Shower 2-2.5 gallons per minute. Old shower heads use as much as 4 gallons per minute.
Teeth brushing &1 gallon, especially if water is turned off while brushing. Newer bath faucets use about 1 gallon per minute, whereas older models use over 2 gallons.
Hands/face washing 1 gallon
Face/leg shaving 1 gallon
Dishwasher 20 gallons/load, depending of efficiency of dishwasher
Dishwashing by hand: 4 gallons/minute for old faucets.. Newer kitchen faucets use about 1-2 gallons per minutes.
Clothes washer
25 gallons/load for newer washers. Older models use about 40 gallons per load.
Toilet flush 3 gallons for older models. Most all new toilets use 1.2-1.6 gallons per flush.
Glasses of water drunk 8 oz. per glass
Outdoor watering 2 gallons per minute