Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by HuaMinChen
at 2024-07-11 00:31:49
ModifyPoint: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?
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
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?
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
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:
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
Try this for starters as root, until user postgres can logon nothing will work as intended
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:
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
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
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:
Author: HuaMinChen replied at 2024-07-13 18:50:46
Many thanks.
It means huamin user below, is not able to access the folder,
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:
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
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
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:
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
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
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:
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
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:
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
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:
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
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
