Java Mailing List Archive

http://www.redhatconfig.com/

Home » Red Hat Enterprise Linux 5 »

Re: [rhelv5-list] Postgresql: Could not create a
 tablespace  -  permission denied

Graham Leggett

2008-04-19

Replies: Find Java Web Hosting

Author LoginPost Reply
Hugh Brown wrote:

> I'd check that the user postgresql is running as can create files in
> /home/chandler/fma/db/pgsql
>
> # assuming postgres is the user
> su - postgres
> touch /home/chandler/fma/db/pgsql/foo
> rm /home/chandler/fma/db/pgsql/foo

That was the first thing that I checked, and it all worked correctly.

As it turned out, the postgresql server had cached an older version of
the credentials, and the attempt to add the tablespace failed until the
postgresql server was restarted.

Regards,
Graham
--

Attachment: smime.p7s (zipped)
_______________________________________________
rhelv5-list mailing list
rhelv5-list@(protected)
https://www.redhat.com/mailman/listinfo/rhelv5-list
©2008 redhatconfig.com - Jax Systems, LLC, U.S.A.