| From: | Malm Paul <paul(dot)malm(at)saabgroup(dot)com> |
|---|---|
| To: | pgsql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Setting up tablepace |
| Date: | 2011-06-15 10:34:14 |
| Message-ID: | 2CF53313EAE78542876F7C9689F9F7253724F4C3@corpappl746.corp.saab.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all,
I have a problem with setting up tablespace on a ramdisk.
the ramdisk shall be used temporary for storing unprotected map data, that is normaly protected.
I'm working in Linux.
I have an ordirnary Linux user called normaluser, a user called chartuser (the ramdisk owner, the password is not known to the normal users), and a ordinary postgres user.
Chartuser and root are the only ones that has access to the ramdisk.
I have succeeded to store (as normaluser) the unprotected map files on the ramdisk, only accessable for chartuser.
I would now like to import the map files to a GIS db that has the tabespace on the ramdisk. But I'm not able to create the tablespace on the ramdisk.
Trying logged in as chartuser to run: psql -c "CREATE TABLESPACE ramspc LOCATION '/tmp/ramdisk0/tblspace'"
"could not set permission on directory "/tmp/ramdisk0/tblspace": premission denied"...
Any ideas, anyone?
Thanks,
Paul
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2011-06-15 10:40:14 | Re: random backend crashes - Needed Information included |
| Previous Message | Joel Jacobson | 2011-06-15 07:03:58 | psql \s not working - OS X |