pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed`postgresql.conf' has wrong permissions???
3+ messages / 3 participants
[nested] [flat]
* `postgresql.conf' has wrong permissions???
@ 2001-08-03 13:08 rocael@usa.net
2001-08-03 21:07 ` Re: `postgresql.conf' has wrong permissions??? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: rocael@usa.net @ 2001-08-03 13:08 UTC (permalink / raw)
To: pgsql-sql
Hi,
I have a trouble when I try to start my postgres server (pg7.1 installed from
source), it has been running postgres ok, then my linux redhat 7.1 box was
rebooted (without stoping postgres), now I tried to run again the postgres
server and I got this message:
FATAL 1: configuration file `postgresql.conf' has wrong permissions
I tried to run it as usual with this commands:
as root
su -l postgres -c '/usr/local/pgsql/bin/postmaster -B 1000 -o "-S 2000" -S -D
/usr/local/pgsql/data'
as postgres
[postgres@localhost pgsql]$ bin/postmaster -D data/
in both cases I got the same error message, this is the first time I have this
trouble, I have stopped and restarted that DB server a lot of times.
my directories permissions says:
ls -la /usr/local/
drwxr-x--x 9 postgres web 4096 Jul 30 18:07 pgsql
ls -la /usr/local/pgsql
drwxrwxrwx 2 postgres web 4096 Jun 29 23:15 bin
drwxrwxrwx 5 postgres web 4096 Aug 3 09:19 data
drwxrwxrwx 3 postgres web 4096 Jun 29 23:15 doc
-rwxrwxrwx 1 postgres web 747 Jun 29 17:22 .emacs
drwxrwxrwx 4 postgres web 4096 Jun 29 23:15 include
drwxrwxrwx 2 postgres web 4096 Jul 2 10:09 lib
drwxrwxrwx 4 postgres web 4096 Jun 29 23:15 man
-rwxrwxrwx 1 postgres web 46 Jul 30 20:29 .psql_history
-rwxrwxrwx 1 postgres web 3728 Jun 29 17:22 .screenrc
drwxrwxrwx 2 postgres web 4096 Jun 29 23:15 share
ls -la /usr/local/pgsql/data/
drwxrwxrwx 5 postgres web 4096 Aug 3 09:19 .
drwxr-x--x 9 postgres web 4096 Jul 30 18:07 ..
drwxrwxrwx 10 postgres web 4096 Jul 26 12:46 base
drwxrwxrwx 2 postgres web 4096 Jul 2 10:52 global
-rwxrwxrwx 1 postgres web 7399 Jun 29 23:15 pg_hba.conf
-rwxrwxrwx 1 postgres web 1118 Jun 29 23:15 pg_ident.conf
-rwxrwxrwx 1 postgres web 4 Jun 29 23:15 PG_VERSION
drwxrwxrwx 2 postgres web 4096 Aug 2 23:09 pg_xlog
-rwxrwxrwx 1 postgres web 3137 Jun 29 23:15 postgresql.conf
-rwxrwxrwx 1 postgres web 93 Jul 30 22:31 postmaster.opts
I just did chmod 777 -R /usr/local/pgsql
Is not working...
One thing to note is that before I rebooted linux I did this:
chmod 755 -R /usr/local/pgsql
I did this when postgresql was alredy running, and the reason is because I
needed that for a driver works well.
Please help me, I don't know what to do now!
Thank you,
Greetings,
Rocael.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: `postgresql.conf' has wrong permissions???
2001-08-03 13:08 `postgresql.conf' has wrong permissions??? rocael@usa.net
@ 2001-08-03 21:07 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-08-15 16:25 ` Re: `postgresql.conf' has wrong permissions??? fimbulvetr <fimbulvetr@lycos.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2001-08-03 21:07 UTC (permalink / raw)
To: rocael@usa.net; +Cc: pgsql-sql
<rocael@usa.net> writes:
> FATAL 1: configuration file `postgresql.conf' has wrong permissions
> One thing to note is that before I rebooted linux I did this:
> chmod 755 -R /usr/local/pgsql
That was a bad idea. 700 is the most permission you should have on the
/usr/local/pgsql/data directory. I am not sure why the code is so picky
about postgresql.conf and not about the data directory as a whole ---
but it will refuse to start up if postgresql.conf has more than 744
permissions.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: `postgresql.conf' has wrong permissions???
2001-08-03 13:08 `postgresql.conf' has wrong permissions??? rocael@usa.net
2001-08-03 21:07 ` Re: `postgresql.conf' has wrong permissions??? Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-08-15 16:25 ` fimbulvetr <fimbulvetr@lycos.com>
0 siblings, 0 replies; 3+ messages in thread
From: fimbulvetr@lycos.com @ 2001-08-15 16:25 UTC (permalink / raw)
To: pgsql-sql
tgl@sss.pgh.pa.us (Tom Lane) wrote in message news:<25631.996872872@sss.pgh.pa.us>...
> <rocael@usa.net> writes:
> > FATAL 1: configuration file `postgresql.conf' has wrong permissions
>
> > One thing to note is that before I rebooted linux I did this:
> > chmod 755 -R /usr/local/pgsql
>
> That was a bad idea. 700 is the most permission you should have on the
> /usr/local/pgsql/data directory. I am not sure why the code is so picky
> about postgresql.conf and not about the data directory as a whole ---
> but it will refuse to start up if postgresql.conf has more than 744
> permissions.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
I experienced this problem as well, I changed permissions on
/usr/local in order to get our samba share to work, and the next day
the database would not start.
744 will allow the postmaster to start again.
Dan
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-08-15 16:25 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-08-03 13:08 `postgresql.conf' has wrong permissions??? rocael@usa.net
2001-08-03 21:07 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-08-15 16:25 ` fimbulvetr <fimbulvetr@lycos.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox