{"id":69042,"date":"2024-07-12T06:50:42","date_gmt":"2024-07-12T03:20:42","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/demo-project-3d4b\/"},"modified":"2024-07-12T06:50:42","modified_gmt":"2024-07-12T03:20:42","slug":"demo-project-3d4b","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/demo-project-3d4b\/","title":{"rendered":"\u067e\u0631\u0648\u0698\u0647 \u0646\u0645\u0627\u06cc\u0634\u06cc"},"content":{"rendered":"

Summarize this content to 400 words in Persian Lang
\nssh root@*EIP*<\/p>\n

wget https:\/\/sandbox-expriment-files.obs.cn-north-1.myhuaweicloud.com:443\/20220525\/GaussDB_opengauss_client_tools.zip<\/p>\n

unzip GaussDB_opengauss_client_tools.zip<\/p>\n

cd GaussDB_opengauss_client_tools\/Euler2.8_arm_64\/<\/p>\n

tar -xvf GaussDB-Kernel-V500R001C20-EULER-64bit-gsql.tar.gz<\/p>\n

source gsql_env.sh<\/p>\n

\u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 GaussDB \u0627\u0632 gsql \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u062f\u0631 \u062f\u0633\u062a\u0648\u0631\u060c -h \u0622\u062f\u0631\u0633 IP \u062e\u0635\u0648\u0635\u06cc ECS \u0631\u0627 \u06a9\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 GaussDB \u0631\u0648\u06cc \u0622\u0646 \u0645\u0633\u062a\u0642\u0631 \u0634\u062f\u0647 \u0627\u0633\u062a\u060c -d \u0646\u0627\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\u060c -U \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc\u060c -p \u067e\u0648\u0631\u062a \u0648 -W \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n

gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -r<\/p>\n

\\q<\/p>\n

gsql –help<\/p>\n

\\copyright<\/p>\n

\\h<\/p>\n

\\help CREATE DATABASE<\/p>\n

\\?<\/p>\n

gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -l<\/p>\n

gsql -V<\/p>\n

gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -q<\/p>\n

create table t_test (firstcol int);<\/p>\n

insert into t_test values(200);<\/p>\n

select * from t_test;<\/p>\n

\\q<\/p>\n

gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -S<\/p>\n

select * from t_test;<\/p>\n

select * from t_test<\/p>\n

\\q<\/p>\n

gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -r<\/p>\n

select * from t_test;<\/p>\n

\u062a\u0631\u0645\u06cc\u0646\u0627\u0644 \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0631\u062f\u0647 \u0648 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0628\u0647 ECS \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f:<\/p>\n

ssh username@ecs-ip-address<\/p>\n

wget https:\/\/example.com\/path\/to\/GaussDB_opengauss_client_tools.zip
\nunzip GaussDB_opengauss_client_tools.zip -d \/path\/to\/destination<\/p>\n

cd \/path\/to\/destination\/EulerOS_X86_64<\/p>\n

cd \/path\/to\/destination\/EulerOS_X86_64
\n.\/gsql -d hccdp_db -h 192.168.0.183 -p 8000 -U hccdp<\/p>\n

systemctl status gaussdb<\/p>\n

systemctl start gaussdb<\/p>\n

\u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0648 \u0627\u062c\u0631\u0627\u06cc gsql Client Tools<\/p>\n

wget https:\/\/example.com\/path\/to\/GaussDB_opengauss_client_tools.zip
\nunzip GaussDB_opengauss_client_tools.zip -d \/path\/to\/destination
\ncd \/path\/to\/destination\/EulerOS_X86_64
\n.\/gsql -d hccdp_db -h 192.168.0.183 -p 8000 -U hccdp<\/p>\n

\u0628\u0647 \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u06a9\u0647 \u06a9\u0644\u0627\u06cc\u0646\u062a gsql \u062f\u0631 \u0622\u0646 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f.<\/p>\n

cd \/path\/to\/GaussDB_opengauss_client_tools\/EulerOS_X86_64<\/p>\n

\u0628\u0647 GaussDB \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f<\/p>\n

.\/gsql -h 192.168.0.183 -U root -d postgres -p 8000 -W yourpassword -r<\/p>\n

\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 192.168.0.183 \u0622\u062f\u0631\u0633 IP GaussDB\u060c \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0631\u06cc\u0634\u0647\u060c \u0646\u0627\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 postgres\u060c 8000 \u0634\u0645\u0627\u0631\u0647 \u067e\u0648\u0631\u062a \u0648 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0634\u0645\u0627 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0634\u0645\u0627 \u0627\u0633\u062a.<\/p>\n

\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0628\u0647 GaussDB \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f:<\/p>\n

.\/gsql -d hccdp_db -h 192.168.0.183 -p 8000 -U hccdp<\/p>\n

\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 hccdp_db \u0646\u0627\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\u060c 192.168.0.183 \u0622\u062f\u0631\u0633 IP GaussDB\u060c 8000 \u0634\u0645\u0627\u0631\u0647 \u067e\u0648\u0631\u062a \u0648 hccdp username.o \u0627\u0633\u062a.<\/p>\n

CREATE SCHEMA hccdp;
\nCREATE TABLE hccdp.nation (
\n N_NATIONKEY INT PRIMARY KEY,
\n N_NAME VARCHAR(25),
\n N_REGIONKEY INT,
\n N_COMMENT VARCHAR(152)
\n);<\/p>\n

\\copy hccdp.nation FROM ‘\/path\/to\/nation.csv’ WITH (FORMAT csv, HEADER true);
\n\\copy hccdp.part FROM ‘\/path\/to\/part.csv’ WITH (FORMAT csv, HEADER true);
\n\\copy hccdp.supplier FROM ‘\/path\/to\/supplier.csv’ WITH (FORMAT csv, HEADER true);
\n\\copy hccdp.partsupp FROM ‘\/path\/to\/partsupp.csv’ WITH (FORMAT csv, HEADER true);
\n\\copy hccdp.orders FROM ‘\/path\/to\/orders.csv’ WITH (FORMAT csv, HEADER true);
\n\\copy hccdp.lineitem FROM ‘\/path\/to\/lineitem.csv’ WITH (FORMAT csv, HEADER true);<\/p>\n

\u0645\u062b\u0627\u0644\u06cc \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 SQL \u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc \u062f\u0627\u062f\u0647:<\/p>\n

SELECT * FROM hccdp.nation;<\/p>\n

\u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u0631\u0648\u06cc\u0647 \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647:<\/p>\n

CREATE OR REPLACE PROCEDURE proc_nation() AS $$
\nBEGIN
\n — Buraya prosed\u00fcr i\u00e7eri\u011fi gelecek
\nEND;
\n$$ LANGUAGE plpgsql;<\/p>\n

\n
ssh root@*EIP*\n<\/code><\/pre>\n<\/div>\n
\n
wget https:\/\/sandbox-expriment-files.obs.cn-north-1.myhuaweicloud.com:443\/20220525\/GaussDB_opengauss_client_tools.zip\n\n<\/code><\/pre>\n<\/div>\n
\n
unzip GaussDB_opengauss_client_tools.zip\n\n<\/code><\/pre>\n<\/div>\n
\n
cd GaussDB_opengauss_client_tools\/Euler2.8_arm_64\/\n\n<\/code><\/pre>\n<\/div>\n
\n
tar -xvf GaussDB-Kernel-V500R001C20-EULER-64bit-gsql.tar.gz\n\n<\/code><\/pre>\n<\/div>\n
\n
source gsql_env.sh\n\n<\/code><\/pre>\n<\/div>\n
\u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 GaussDB \u0627\u0632 gsql \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.  \u062f\u0631 \u062f\u0633\u062a\u0648\u0631\u060c -h \u0622\u062f\u0631\u0633 IP \u062e\u0635\u0648\u0635\u06cc ECS \u0631\u0627 \u06a9\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 GaussDB \u0631\u0648\u06cc \u0622\u0646 \u0645\u0633\u062a\u0642\u0631 \u0634\u062f\u0647 \u0627\u0633\u062a\u060c -d \u0646\u0627\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\u060c -U \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc\u060c -p \u067e\u0648\u0631\u062a \u0648 -W \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u062f.\n<\/p>\n
\n
gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -r\n\n<\/code><\/pre>\n<\/div>\n
\n
\\q\n<\/code><\/pre>\n<\/div>\n
\n
gsql --help\n<\/code><\/pre>\n<\/div>\n
\n
\\copyright\n\n<\/code><\/pre>\n<\/div>\n
\n
\\h\n\n<\/code><\/pre>\n<\/div>\n
\n
\\help CREATE DATABASE\n<\/code><\/pre>\n<\/div>\n
\n
\\?\n<\/code><\/pre>\n<\/div>\n
\n
gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -l\n\n<\/code><\/pre>\n<\/div>\n
\n
gsql -V\n<\/code><\/pre>\n<\/div>\n
\n
gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -q\n\n<\/code><\/pre>\n<\/div>\n
\n
create table t_test (firstcol int);\n\n<\/code><\/pre>\n<\/div>\n
\n
insert into t_test values(200);\n\n<\/code><\/pre>\n<\/div>\n
\n
select * from t_test;\n\n<\/code><\/pre>\n<\/div>\n
\n
\\q\n<\/code><\/pre>\n<\/div>\n
\n
gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -S\n\n<\/code><\/pre>\n<\/div>\n
\n
select * from t_test;\n\n<\/code><\/pre>\n<\/div>\n
\n
select * from t_test\n<\/code><\/pre>\n<\/div>\n
\n
\\q\n<\/code><\/pre>\n<\/div>\n
\n
gsql -h *Private IP address* -U root -d postgres -p 8000 -W yourpassword -r\n\n<\/code><\/pre>\n<\/div>\n
\n
select * from t_test;\n<\/code><\/pre>\n<\/div>\n
\u062a\u0631\u0645\u06cc\u0646\u0627\u0644 \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0631\u062f\u0647 \u0648 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0628\u0647 ECS \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f:\n<\/p>\n
\n
ssh username@ecs-ip-address\n\n<\/code><\/pre>\n<\/div>\n
\n
wget https:\/\/example.com\/path\/to\/GaussDB_opengauss_client_tools.zip\nunzip GaussDB_opengauss_client_tools.zip -d \/path\/to\/destination\n\ncd \/path\/to\/destination\/EulerOS_X86_64\n\n<\/code><\/pre>\n<\/div>\n
\n
cd \/path\/to\/destination\/EulerOS_X86_64\n.\/gsql -d hccdp_db -h 192.168.0.183 -p 8000 -U hccdp\n\n<\/code><\/pre>\n<\/div>\n
\n
systemctl status gaussdb\n\n<\/code><\/pre>\n<\/div>\n
\n
systemctl start gaussdb\n\n<\/code><\/pre>\n<\/div>\n
\u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0648 \u0627\u062c\u0631\u0627\u06cc gsql Client Tools\n<\/p>\n
\n
wget https:\/\/example.com\/path\/to\/GaussDB_opengauss_client_tools.zip\nunzip GaussDB_opengauss_client_tools.zip -d \/path\/to\/destination\ncd \/path\/to\/destination\/EulerOS_X86_64\n.\/gsql -d hccdp_db -h 192.168.0.183 -p 8000 -U hccdp\n\n<\/code><\/pre>\n<\/div>\n
\u0628\u0647 \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u06a9\u0647 \u06a9\u0644\u0627\u06cc\u0646\u062a gsql \u062f\u0631 \u0622\u0646 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f.\n<\/p>\n
\n
cd \/path\/to\/GaussDB_opengauss_client_tools\/EulerOS_X86_64\n\n<\/code><\/pre>\n<\/div>\n
\u0628\u0647 GaussDB \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f\n<\/p>\n
\n
.\/gsql -h 192.168.0.183 -U root -d postgres -p 8000 -W yourpassword -r\n\n<\/code><\/pre>\n<\/div>\n
\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 192.168.0.183 \u0622\u062f\u0631\u0633 IP GaussDB\u060c \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0631\u06cc\u0634\u0647\u060c \u0646\u0627\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 postgres\u060c 8000 \u0634\u0645\u0627\u0631\u0647 \u067e\u0648\u0631\u062a \u0648 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0634\u0645\u0627 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0634\u0645\u0627 \u0627\u0633\u062a.<\/p>\n
\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0628\u0647 GaussDB \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f:\n<\/p>\n
\n
.\/gsql -d hccdp_db -h 192.168.0.183 -p 8000 -U hccdp\n\n<\/code><\/pre>\n<\/div>\n
\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 hccdp_db \u0646\u0627\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\u060c 192.168.0.183 \u0622\u062f\u0631\u0633 IP GaussDB\u060c 8000 \u0634\u0645\u0627\u0631\u0647 \u067e\u0648\u0631\u062a \u0648 hccdp username.o \u0627\u0633\u062a.\n<\/p>\n
\n
CREATE SCHEMA hccdp;\nCREATE TABLE hccdp.nation (\n  N_NATIONKEY INT PRIMARY KEY,\n  N_NAME VARCHAR(25),\n  N_REGIONKEY INT,\n  N_COMMENT VARCHAR(152)\n);\n\n<\/code><\/pre>\n<\/div>\n
\n
\\copy hccdp.nation FROM '\/path\/to\/nation.csv' WITH (FORMAT csv, HEADER true);\n\\copy hccdp.part FROM '\/path\/to\/part.csv' WITH (FORMAT csv, HEADER true);\n\\copy hccdp.supplier FROM '\/path\/to\/supplier.csv' WITH (FORMAT csv, HEADER true);\n\\copy hccdp.partsupp FROM '\/path\/to\/partsupp.csv' WITH (FORMAT csv, HEADER true);\n\\copy hccdp.orders FROM '\/path\/to\/orders.csv' WITH (FORMAT csv, HEADER true);\n\\copy hccdp.lineitem FROM '\/path\/to\/lineitem.csv' WITH (FORMAT csv, HEADER true);\n\n<\/code><\/pre>\n<\/div>\n
\u0645\u062b\u0627\u0644\u06cc \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 SQL \u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc \u062f\u0627\u062f\u0647:\n<\/p>\n
\n
SELECT * FROM hccdp.nation;\n\n<\/code><\/pre>\n<\/div>\n
\u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u0631\u0648\u06cc\u0647 \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647:\n<\/p>\n
\n
CREATE OR REPLACE PROCEDURE proc_nation() AS $$\nBEGIN\n  -- Buraya prosed\u00fcr i\u00e7eri\u011fi gelecek\nEND;\n$$ LANGUAGE plpgsql;\n\n<\/code><\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Summarize this content to 400 words in Persian Lang ssh root@*EIP* wget https:\/\/sandbox-expriment-files.obs.cn-north-1.myhuaweicloud.com:443\/20220525\/GaussDB_opengauss_client_tools.zip unzip GaussDB_opengauss_client_tools.zip cd GaussDB_opengauss_client_tools\/Euler2.8_arm_64\/ tar -xvf GaussDB-Kernel-V500R001C20-EULER-64bit-gsql.tar.gz source gsql_env.sh \u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 GaussDB \u0627\u0632 gsql \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u062f\u0631 \u062f\u0633\u062a\u0648\u0631\u060c -h \u0622\u062f\u0631\u0633 IP \u062e\u0635\u0648\u0635\u06cc ECS \u0631\u0627 \u06a9\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 GaussDB \u0631\u0648\u06cc \u0622\u0646 \u0645\u0633\u062a\u0642\u0631 \u0634\u062f\u0647 \u0627\u0633\u062a\u060c -d \u0646\u0627\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\u060c -U \u0646\u0627\u0645 …<\/p>\n","protected":false},"author":2,"featured_media":69043,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-69042","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/69042","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=69042"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/69042\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/69043"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=69042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=69042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=69042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}