Ask Question Forum:

Model Library:2025-02-08 Updated:A.I. model including DeepSeek is online for auto reply question page

Show

ASK RECENT

Don't see the folder

Asked by HuaMinChen

at 2024-07-11 00:31:49

Point:230 Replies:24 POST_ID:828953USER_ID:11615

Topic:

PostgreSQL Database;;Miscellaneous Databases

Hi,
I have already set up
postgresql-server-8.4.20-1.el6_5.x86_64

on Linux Redhat, but I do not see this folder

/usr/local/pgsql

why?

Author: HuaMinChen replied at 2024-07-22 21:54:03

Please omit the last post above.

Author: HuaMinChen replied at 2024-07-22 21:20:26

Sorry, how to resolve this error attached, when logging into the OS using postgres account?

Assisted Solution

Expert: earth man2 replied at 2024-07-22 00:10:11

115 points EXCELLENT

The postgres account is used to administrate the database. Eg set up database roles and table access privileges. If you need to set logon restrictions then you would only allow logon if sat at the server console.

Author: HuaMinChen replied at 2024-07-21 18:56:51

Sorry Earthman.

I was confused to this as other people told me that it is suggested not to log into a service account, in this
http://www.experts-exchange.com/Database/PostgreSQL/Q_28479805.html#a40208103

Expert: earth man2 replied at 2024-07-21 12:38:26

logon as postgres. Were you successful?

Author: HuaMinChen replied at 2024-07-20 05:48:15

Thanks a lot.
I've already successfully changed the password of user "postgres" and then what to check next?

Expert: earth man2 replied at 2024-07-20 03:21:21

Set password for user postgres if you haven't done so already as root
passwd postgres

Then logon as postgres. Were you successful?

Then consider if SELinux is the problem
http://docs.fedoraproject.org/en-US/Fedora/13/html/Managing_Confined_Services/sect-Managing_Confined_Services-PostgreSQL-Configuration_Examples.html

Expert: earth man2 replied at 2024-07-20 03:03:00

-R

Author: HuaMinChen replied at 2024-07-19 15:35:26

Sorry, please advise to this

[root@CentOS65x64 huamin]# chown -r postgres /var/lib/pgsqlchown: invalid option -- 'r'Try `chown --help' for more information.[root@CentOS65x64 huamin]#

1:2:3:4:

Select All Code

Expert: earth man2 replied at 2024-07-19 13:11:19

Your installation is messed up.
Try this for starters as root, until user postgres can logon nothing will work as intended

chown -r postgres /var/lib/pgsql

1:

Select All Code

Author: HuaMinChen replied at 2024-07-18 16:30:40

Many thanks. Any advice to these?

[root@CentOS65x64 huamin]# su - postgressu: warning: cannot change directory to /var/lib/pgsql: Permission denied-bash: /var/lib/pgsql/.bash_profile: Permission denied-bash-4.1$ postgres -D /var/lib/pgsql/datapostgres cannot access the server configuration file "/var/lib/pgsql/data/postgresql.conf": Permission denied-bash-4.1$

1:2:3:4:5:6:

Select All Code

Accepted Solution

Expert: earth man2 replied at 2024-07-18 14:21:21

115 points EXCELLENT

use postgres user account rather than change file privielges
ie
as root
su - postgres
postgres -D /var/lib/pgsql/data

Author: HuaMinChen replied at 2024-07-15 00:11:46

what to adjust then?
Hi,
I've edited this file
/etc/sysconfig/pgsql/postgresql

but I still get this

[root@CentOS65x64 huamin]# service postgresql startStarting postgresql service:                               [  OK  ][root@CentOS65x64 huamin]# exitexit[huamin@CentOS65x64 ~]$ postgres -D /var/lib/pgsql/datapostgres cannot access the server configuration file "/var/lib/pgsql/data/postgresql.conf": Permission denied

1:2:3:4:5:6:

Select All Code

Author: HuaMinChen replied at 2024-07-13 18:50:46

Many thanks.
It means huamin user below, is not able to access the folder,

[huamin@CentOS65x64 ~]$ cd /var/lib/pgsql/data/bash: cd: /var/lib/pgsql/data/: Permission denied[huamin@CentOS65x64 ~]$ suPassword:[root@CentOS65x64 huamin]# cd /var/lib/pgsql/data/[root@CentOS65x64 data]#

1:2:3:4:5:6:

Select All Code

then which privileges should be added to "huamin"?

Expert: duncanb7 replied at 2024-07-11 18:07:10

(in the first post) editing /etc/sysconfig/pgsql/postgresql and check this out

PGDATA=/var/lib/pgsql/data
PGPORT=5432
PGLOG=/var/lib/pgsql/pgstartup.log
PGOPTS=

Duncan

Expert: duncanb7 replied at 2024-07-11 18:02:30

Take a look at this link to explain the process for postresql
http://www.kelvinwong.ca/tag/postgresql-conf/

Is there any postgresql.conf, conf file at /var/lib/pgsql/data/ ?

Duncan

Author: HuaMinChen replied at 2024-07-11 17:54:09

Sorry, I get this

[root@CentOS65x64 huamin]# service postgresql startStarting postgresql service:                               [  OK  ][root@CentOS65x64 huamin]# exitexit[huamin@CentOS65x64 ~]$ postgres -D /usr/local/pgsql/datapostgres cannot access the server configuration file "/usr/local/pgsql/data/postgresql.conf": No such file or directory

1:2:3:4:5:6:

Select All Code

I don't know how to create "postgresql.conf".

Expert: duncanb7 replied at 2024-07-11 03:29:20

Take a look at this article
http://blog.endpoint.com/2009/09/permission-denied-for-postgresqlconf.html

about "postgres cannot access the server configuration file "/var/lib/pgsql/data/postgresql.conf": Permission denied"

Duncan

Author: HuaMinChen replied at 2024-07-11 03:22:06

Many thanks. This is in CentOS 6.5.

i still get this

[root@CentOS65x64 huamin]# chkconfig postgresql on[root@CentOS65x64 huamin]# service postgresql startStarting postgresql service:                               [  OK  ][root@CentOS65x64 huamin]# exitexit[huamin@CentOS65x64 ~]$ postgres -D /var/lib/pgsql/datapostgres cannot access the server configuration file "/var/lib/pgsql/data/postgresql.conf": Permission denied[huamin@CentOS65x64 ~]$

1:2:3:4:5:6:7:8:

Select All Code

Expert: duncanb7 replied at 2024-07-11 03:06:37

In the link posted previously, for older version linux
Please try it again
----------------------------------------
chkconfig postgresql on
service postgresql start

What is Linux version?

Duncan

Author: HuaMinChen replied at 2024-07-11 02:42:33

Sorry, I still get this

[root@CentOS65x64 huamin]# service postgresql startStarting postgresql service:                               [  OK  ][root@CentOS65x64 huamin]# exitexit[huamin@CentOS65x64 ~]$ postgres -D /var/lib/pgsql/datapostgres cannot access the server configuration file "/var/lib/pgsql/data/postgresql.conf": Permission denied[huamin@CentOS65x64 ~]$

1:2:3:4:5:6:7:

Select All Code

Expert: duncanb7 replied at 2024-07-11 02:28:11

Is there any file or directory in /var/lib/ ? If so, it proved you did installation before
Supposed the installation will do setup for you so you don't need to do environment setup

just run

service postgresql start

you can take sometime to review the link in previous post

Duncan

Author: HuaMinChen replied at 2024-07-11 02:24:09

Sorry, I get this

[huamin@CentOS65x64 lib]$ cd /var/lib[huamin@CentOS65x64 lib]$ postgrespostgres does not know where to find the server configuration file.You must specify the --config-file or -D invocation option or set the PGDATA environment variable.[huamin@CentOS65x64 lib]$

1:2:3:4:5:

Select All Code

Expert: duncanb7 replied at 2024-07-11 00:46:00

Is it at /var/lib/pgsql ?
Please take a look this link, the variable setting is set to /var/lib/pgsql
https://wiki.postgresql.org/wiki/PostgreSQL_on_RedHat_Linux

Duncan

&nbps;

About Us|Service|Pricing

即時新聞:↓

即時新聞:↑

On Balance Volume (OBV):

Ask Question Forum:

Don't see the folder

Video♬:↓

Your Information

Members/Profolio