Skip site navigation (1) Skip section navigation (2)

Re: Help with "Permission Denied". => FIXED Thanks

From: Antony Loop <antonyloop(at)gmail(dot)com>
To: Bryan Hinton <bryan(at)bryanhinton(dot)com>
Cc: austinpug(at)postgresql(dot)org
Subject: Re: Help with "Permission Denied". => FIXED Thanks
Date: 2010-07-20 20:49:20
Message-ID: AANLkTilxN3mqYY_ucfhx34TYIRtVGMQbVwb7UJyenDNs@mail.gmail.com (view raw or flat)
Thread:
Lists: austinpug
Thank you very much for your help and attention, I could now continue
with the exercises of a book I an following.

Loop

On Tue, Jul 20, 2010 at 2:20 PM, Bryan Hinton <bryan(at)bryanhinton(dot)com> wrote:

> -----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-----
>

austinpug by date

Next:From: Jon ErdmanDate: 2010-07-20 23:24:54
Subject: Re: Help with "Permission Denied"
Previous:From: Bryan HintonDate: 2010-07-20 19:20:26
Subject: Re: Help with "Permission Denied"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group