pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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> 2007-12-13 21:25 ` Re: Error Creating Tablespace Tom Lane <tgl@sss.pgh.pa.us> 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 19:36 Error Creating Tablespace Ferry, Craig <crferry@wescodist.com> @ 2007-12-13 21:25 ` Tom Lane <tgl@sss.pgh.pa.us> 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