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

Re: Help with "Permission Denied"

From: Jon Erdman <postgresql(at)thewickedtribe(dot)net>
To: Antony Loop <antonyloop(at)gmail(dot)com>
Cc: austinpug(at)postgresql(dot)org
Subject: Re: Help with "Permission Denied"
Date: 2010-07-20 18:55:30
Message-ID: 4C45F122.1070308@thewickedtribe.net (view raw or flat)
Thread:
Lists: austinpug
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 07/20/2010 01: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

The unix user postgres doesn't have permission to read the file
/usr/local/pgsql/create_tables-bpsimple.sql so as the user that owns
that file do:

chmod a+r /usr/local/pgsql/create_tables-bpsimple.sql
- --
Jon T Erdman (aka StuckMojo)
    PostgreSQL Zealot
-----BEGIN PGP SIGNATURE-----
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkxF8SIACgkQRAk1+p0GhSEJSgCfXOM0uIAhDB/NcIr68EaaDKVQ
XXoAnArlZLdBWVHpLh++7k1HdtiMFcZ9
=IWQm
-----END PGP SIGNATURE-----

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

In response to

austinpug by date

Next:From: Bryan HintonDate: 2010-07-20 19:20:26
Subject: Re: Help with "Permission Denied"
Previous:From: Antony LoopDate: 2010-07-20 18:14:47
Subject: Help with "Permission Denied"

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