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

Re: Help with "Permission Denied"

From: Jon Erdman <postgresql(at)thewickedtribe(dot)net>
To: Bryan Hinton <bryan(at)bryanhinton(dot)com>
Cc: Antony Loop <antonyloop(at)gmail(dot)com>, austinpug(at)postgresql(dot)org
Subject: Re: Help with "Permission Denied"
Date: 2010-07-20 23:24:54
Message-ID: 4C463046.4090204@thewickedtribe.net (view raw or flat)
Thread:
Lists: austinpug
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



Look closer, the permission denied was on the actual .sql file he was
trying to read into psql...i.e. postgres user didn't have read on it,
filesystem wise ;)
- --
Jon T Erdman (aka StuckMojo)
    PostgreSQL Zealot

On 07/20/2010 02:20 PM, Bryan Hinton wrote:
> 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-----
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkxGMEYACgkQRAk1+p0GhSE8zQCeM8Q9gswTViihMnL4VK/mWw5w
nNMAn1R13h7jIeNHLgoNRug/7sW3Ftqi
=Xl7Y
-----END PGP SIGNATURE-----

Attachment: 0x9D068521.asc
Description: application/pgp-keys (2.1 KB)

In response to

Responses

austinpug by date

Next:From: Bryan HintonDate: 2010-07-21 00:42:34
Subject: Re: Help with "Permission Denied"
Previous:From: Antony LoopDate: 2010-07-20 20:49:20
Subject: Re: Help with "Permission Denied". => FIXED Thanks

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