PostgreSQL服务启动时报错：“FATAL: could not create lock fil

PostgreSQL服务启动时报错：FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock": 权限不够

PostgreSQL服务启动时报错：FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": 权限不够

1：添加linux用户及创建数据库目录 addgroup postgresql adduser -G postgresql postgresql 此处需要输入密码，后面有此密码来链接数据库 mkdir -p /usr/local/pgsql/data mkdir -p /usr/local/pgsql/log touch /usr/local/pgsql/log/pgsql.log 2：更改数据库目录所属权限 chown -R postgresql:postgresql /usr/local/pgsql/data chown -R postgresql:postgresql /usr/local/pgsql/log chown -R postgresql:postgresql /usr/local/pgsql/log/pgsql.log chown -R postgresql:postgresql tmp 3：创建数据库用户(可忽略) createuser -sADEP postgresql 此处需要输入密码，用来连接数据库 4：初始化及启动数据库 ./initdb -D /usr/local/pgsql/data ./pg_ctl -D /usr/local/pgsql/data -l /usr/local/pgsql/log/pgsql.log start [postgresql@iTOP-4412 /binpost/bin]$./pg_ctl -D /usr/local/pgsql/data -l /usr/local/pgsql/log/pgsql.log start server starting 5：登陆到postgresql命令行/创建数据库及表，添加纪录。 首先需要以之前创建的用户登录 postgresql psql postgres 执行命令的时候，出现如下问题： [postgresql@iTOP-4412 /binpost/bin]$./psql postgres psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? 百度之后是权限的问题： 对/tmp目录的所属权限进行设置 [postgresql@iTOP-4412 /binpost/bin]$ su - root [root@iTOP-4412]# ls bin etd proc usr binpost home root var binpost.tar.bz2 lib sbin work createsocket linuxrc showtable dev mnt sys etc opt tmp [root@iTOP-4412]# chown -R postgresql:postgresql tmp [root@iTOP-4412]# su postgresql [postgresql@iTOP-4412 /binpost/bin]$./pg_ctl -D /usr/local/pgsql/data -l /usr/lo cal/pgsql/log/pgsql.log start server starting [postgresql@iTOP-4412 /binpost/bin]$./psql postgres psql (9.1.9) Type "help" for help. postgres=# CREATE DATABASE psmp; postgres=# l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+------------+-----------+---------+-------+--------------------------- postgres | postgresql | SQL_ASCII | C | C | psmp | postgresql | SQL_ASCII | C | C | template0 | postgresql | SQL_ASCII | C | C | =c/postgresql + | | | | | postgresql=CTc/postgresql template1 | postgresql | SQL_ASCII | C | C | =c/postgresql + | | | | | postgresql=CTc/postgresql (4 rows) 创建表company并添加纪录 CREATE TABLE COMPANY( ID INT PRIMARY KEY NOT NULL,NAME TEXT NOT NULL,AGE INT NOT NULL,ADDRESS CHAR(50),SALARY REAL,JOIN_DATE DATE ); INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY,JOIN_DATE) VALUES (1,'Paul',32,'California',20000.00,'2001-07-13'); INSERT INTO COMPANY (ID,JOIN_DATE) VALUES (3,'Teddy',23,'Norway',DEFAULT ); 6：直接登录数据库 [postgresql@iTOP-4412 /binpost/bin]$ [postgresql@iTOP-4412 /binpost/bin]$ [postgresql@iTOP-4412 /binpost/bin]$./psql -d psmp -U postgresql psql (9.1.9) Type "help" for help. psmp=# d List of relations Schema | Name | Type | Owner --------+---------+-------+------------ public | company | table | postgresql (1 row) psmp=# select * from company; id | name | age | address | salary | join_date ----+-------+-----+----------------------------------------------------+--------+------------ 1 | Paul | 32 | California | 20000 | 2001-07-13 3 | Teddy | 23 | Norway | 20000 | (2 rows) psmp=#

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!