linux下postgresql安装
1 2 | 1、下载地址 https: //www.enterprisedb.com/download-postgresql-binaries |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 | 2、创建用户并修改密码 [root@node01 ~]# useradd postgres [root@node01 ~]# passwd postgres Changing password for user postgres. New password: BAD PASSWORD: The password contains the user name in some form Retype new password: passwd: all authentication tokens updated successfully. [root@node01 ~]# id postgres uid=1000(postgres) gid=1000(postgres) groups=1000(postgres) 3、创建目录并授权 [root@node01 ~]# mkdir /software/pgsql_data ---------数据目录 [root@node01 ~]# mkdir -p /stage ---------软件安装目录 [root@node01 ~]# chown -R postgres.postgres /software* [root@node01 ~]# chown -R postgres.postgres /stage* 4、切换postgres用户,并解压安装包 [root@node01 stage]# su - postgres [postgres@node01 ~]$ cd /stage/ [postgres@node01 stage]$ ll total 156744 -rw-r--r-- 1 postgres postgres 160504039 Aug 17 23:11 postgresql-10.14-1-linux-x64-binaries.tar.gz [postgres@node01 stage]$ tar -xvf postgresql-10.14-1-linux-x64-binaries.tar.gz 5、初始化 [postgres@node01 stage]$ /stage/pgsql/bin/initdb -D /software/pgsql_data The files belonging to this database system will be owned by user "postgres" . This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8" . The default database encoding has accordingly been set to "UTF8" . The default text search configuration will be set to "english" . Data page checksums are disabled. fixing permissions on existing directory /software/pgsql_data ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default timezone ... PRC selecting dynamic shared memory implementation ... posix creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using : /stage/pgsql/bin/pg_ctl -D /software/pgsql_data -l logfile start 6、启动数据库 [postgres@node01 stage]$ /stage/pgsql/bin/pg_ctl -D /software/pgsql_data -l logfile start waiting for server to start.... done server started 7、登陆数据库 [postgres@node01 stage]$ psql -Upostgres -dpostgres psql.bin (10.14) Type "help" for help. postgres=# 8、关闭数据库 [postgres@node01 stage]$ /stage/pgsql/bin/pg_ctl -D /software/pgsql_data -l logfile stop waiting for server to shut down.... done server stopped 9、扩展 postgres=# \l ---------列出所有的database postgres=# \c test ----------选择database test=# \d ----------列出所用database的表 test=# \d tablename ----------查看表结构 test=# \q ---------退出登陆 |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步