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

Help with "Permission Denied"

From: Antony Loop <antonyloop(at)gmail(dot)com>
To: austinpug(at)postgresql(dot)org
Subject: Help with "Permission Denied"
Date: 2010-07-20 18:14:47
Message-ID: AANLkTiko6xsPmS_dzL7qTO8sMHAS2EFEUKsIQIAPQnW7@mail.gmail.com (view raw or flat)
Thread:
Lists: austinpug
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

Responses

austinpug by date

Next:From: Jon ErdmanDate: 2010-07-20 18:55:30
Subject: Re: Help with "Permission Denied"
Previous:From: Jon ErdmanDate: 2010-05-28 21:42:40
Subject: Cheap colo in Austin?

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