From: | Bryan Hinton <bryan(at)bryanhinton(dot)com> |
---|---|
To: | Antony Loop <antonyloop(at)gmail(dot)com> |
Cc: | austinpug(at)postgresql(dot)org |
Subject: | Re: Help with "Permission Denied" |
Date: | 2010-07-20 19:20:26 |
Message-ID: | 4C45F6FA.6070404@bryanhinton.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | austinpug |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
couple of items:
might want to set $HOME for postgres to /usr/local/pgsql
then chown create_tables-bpsimple.sql as appropriate
last of all, check \dp after you fix the file permissions - to make sure
neil can create tables
On 7/20/10 1:14 PM, Antony Loop wrote:
> Dear Sirs:
>
> Postgresql was installed normally from source code in Ubuntu Hardy Heron
> with standard configuration.
>
> But I receive a message "Permission denied" when trying to run a .sql script
> to create tables
> in a already created database. The script is located in /usr/local/pgsql
>
> Any suggestions?
>
> Session example:
>
> root(at)tikal:/home/pakal# su - postgres
> No directory, logging in with HOME=/
>
> $ /usr/local/pgsql/bin/psql -U neil -d bpsimple
> psql (8.4.4)
> Type "help" for help.
>
> bpsimple=#
>
> bpsimple=# \i /usr/local/pgsql/create_tables-bpsimple.sql
> /usr/local/pgsql/create_tables-bpsimple.sql: Permission denied
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.12 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iQIcBAEBAgAGBQJMRfb6AAoJENyAZH/azyeevkYP/0PRxi6whvROVchjtAY5CIFv
MeAsZww78njO6kvrZzJ6mxw2VQwfyAiU8dAveIjHNl6p4Qsg+wE8hRhWmELOkX4W
dW4CljaHoBw+S2ZF6zre+QnA8Owpu/MkujIOzD4zcYYxVgZNK7Rf9T4yQmwPwO7G
XH8oJghyZwQNZUoidzpktjDe0M9eX0DxS5k6Jz1vP0dpKTt0h6N2JOITrIEkasFm
QN97cdHGq7jqpBEsTsPI0CScbjuE7fYMw6hrjhRhp+9zopbrHxdrirZHuSrh1gOv
JPwxMGnNJYJWOmd31YmyhDJY/8BrQgRieLivomSY2wXosBtAUofdmuG73yHJxnfu
KWmzUY774wuX7/9eWvomZ7IqNYCD430dU0jjj+LF1mlMLuhITCTv6iOiuhPluQ6r
UDdZTzE0eK9sMUIAuSVJcU6U4S1s4JeCj4i3vdopLUKHomjZgkTsMypZxG9bfcmH
s8leqxASTT/QmGB8urMmpnrYxBGW8iR79fACuG2v/Oz/fJPMYHZPTVe3Fm8LgC1S
KW76wVaLFfdsyJK/bKIFXX4ZT3UPUtQBiOHCPpfrghprvrnKpFeWouRd3NDdBj2e
UwnxIE2JkbvL13kyYsHSE09dWkicZnD+7gV7QRkQy82oWK//wh9zmb0zEmOlFHwN
nl1eB6V0gVTw6DBUzBSI
=94xw
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Antony Loop | 2010-07-20 20:49:20 | Re: Help with "Permission Denied". => FIXED Thanks |
Previous Message | Jon Erdman | 2010-07-20 18:55:30 | Re: Help with "Permission Denied" |