pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Error Creating Tablespace
2+ messages / 2 participants
[nested] [flat]

* Error Creating Tablespace
@ 2007-12-13 19:36  Ferry, Craig <crferry@wescodist.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Ferry, Craig @ 2007-12-13 19:36 UTC (permalink / raw)
  To: pgsql-admin

I am trying to create a tablespace logged in as postgres.   I just
installed postgresql 8.2.5 on a Redhat linux server.   

I am receiving the following error.

ERROR:  could not set permissions on directory "/data/pgsql/pgdata":
Permission denied

The SQL command I am using is as follows.

 CREATE TABLESPACE order_history OWNER postgres LOCATION
'/data/pgsql/pgdata';

The following are the details of my system.   From what I can see,
everything is set up as per the documentation I have read.

-bash-3.00$ ps -ef | grep postmaster
postgres 17636     1  0 11:57 ?        00:00:00 /usr/bin/postmaster -p
5432 -D /var/lib/pgsql/data

-bash-3.00$ ls -ltr /data/pgsql
total 16
drwx------  2 postgres postgres 4096 Dec 13 13:17 pgdata
 

I can create a tablespace in the /var/lib/pgsql/data directory, but
wanted a different tablespace in a directory where I have a lot of room
to grow.


I am new to postgresql so, any help would be greatly appreciated.

Craig
 

________________________________

 
	 Craig Ferry
 Sr. Database Administrator

 WESCO Distribution, Inc.


 Suite 700

 225 West Station Square Drive

 Pittsburgh, PA 15219
 P:412-454-2835
 F:412-222-7535

 crferry@wescodist.com <mailto:crferry@wescodist.com> 

	
________________________________




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Error Creating Tablespace
@ 2007-12-13 21:25  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Ferry, Craig <crferry@wescodist.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2007-12-13 21:25 UTC (permalink / raw)
  To: Ferry, Craig <crferry@wescodist.com>; +Cc: pgsql-admin

"Ferry, Craig" <crferry@wescodist.com> writes:
> I am trying to create a tablespace logged in as postgres.   I just
> installed postgresql 8.2.5 on a Redhat linux server.   

> I am receiving the following error.

> ERROR:  could not set permissions on directory "/data/pgsql/pgdata":
> Permission denied

If you've got SELinux enabled, you need to mark that directory with
the right SELinux context to allow the postmaster to access it.
There were details posted a few weeks ago.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-12-13 21:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-12-13 19:36 Error Creating Tablespace Ferry, Craig <crferry@wescodist.com>
2007-12-13 21:25 ` Tom Lane <tgl@sss.pgh.pa.us>

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