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

Re: Help with "Permission Denied"

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

chown postgres:postgres create_tables-bpsimple.sql && chmod 0640 $_

On 7/20/10 6:24 PM, Jon Erdman wrote:
> 
> 
> 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 ;)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.12 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBAgAGBQJMRkJ5AAoJENyAZH/azyee840P/1FCf1vPtLG2XAoiK53wE6Et
hGxzU8hO6OisY18eW6F13rrRJ/E9lEIHFXFh3LWlGlaTMVNv38m4S1+DpOhP8lsd
IsZaTaCzVvyVtHj2Ix0mBxQN9bJJ/PMCU/hAx+np8hqnyMzYKBFxIlEtMoBj2tEX
GjiASbVW/vc8bYwbBwKoGR+T8RX6+6ft8MPPSYYAf/hPxxqI5CZQCTJIj9ZXVOqo
GUS0p624jRNUQxhNC/Fe+I63ldtLIn+8Yqgf0qjVza5vxel/Xj1I+4eYsJKJlB+7
esVKPl5Z/LaLhpJJ7JaBBWUqLXk2snufoJqFYaMntMjMhwzSgUG9qpYxB22f+RF+
hahXJGhKMKVjOgNmQDRqrrPJB+ZAtM7vDgHAyNar2jsQYd66zxdU8UbHvlg/s3VI
Nrifvfsd8NnNG9PLl4J61vuTxra52JNgPKbax24LIpmfnVE/l02Mnbjm2WigfNlC
m+WDbBzqmcD2J1fGQKjLZtnvJWuEYbYLMB7THk0WHMPdwjS9hFum0A7WXEP3VWW7
k8I2O/QOhphNYwos/xVbU61hw+dXXqgzYfLFvnY96NsgIM0Cjut86V76cSsFZMWC
zIYtWNpCRf5haJjP5BoPdKRiFwFa/b/NTV1i3dYHmj2eOP7bg3GLf4J9Fk2etn8t
n/eu4WlNJ5TwPie3UeM1
=y3eN
-----END PGP SIGNATURE-----

In response to

austinpug by date

Next:From: Jim NasbyDate: 2010-09-17 17:09:21
Subject: Fwd: Know any good Database Engineers/Architects?
Previous:From: Jon ErdmanDate: 2010-07-20 23:24:54
Subject: Re: Help with "Permission Denied"

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