From: Oliver Elphick <olly@lfix.co.uk>
To: jlt@wvinter.net
Cc: Brett Schwarz <brett_schwarz@yahoo.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: PGACCESS Error Relative Path @ export table
Date: 01 Aug 2002 00:51:48 +0100
Message-ID: <1028159509.22663.70.camel@linda> (raw)
In-Reply-To: <200207311445.05814.jlt@wvinter.net>
References: <HKEIIDPFPDBMOMDLIEEGAEMNCKAA.iavor.raytchev@verysmall.org>
<200207311255.19111.jlt@wvinter.net>
<1028122329.25431.62.camel@thor>
<200207311445.05814.jlt@wvinter.net>
On Wed, 2002-07-31 at 15:45, John L. Turner wrote:
> > > SO that leads to the bottom line Question:
> > > How does a user in postgresql obtain permissions to other directories ?
> >
> > This is at the OS level. Pgaccess is really only accessing the file via
> > the filesystem of the OS that you are running. You need to make sure
> > that the user you start PGAccess with has permissions for those
> > files/directories. For example, on Unix machines, you would use chmod.
> > If you are on a machine that is maintained by someone else, then you
> > would need to ask that person to set the permissions correctly for you.
...
> 3) I started pgaccess as user jlt ( normal user me ). @ /home/jlt
> Within pgaccess, USERS tab, I added jlt (me) as a user.
Your own user name is irrelevant, because it is not you but the backend
which is trying to write the file. Therefore the relevant user is
'postgres' (if that is the user that started the postmaster).
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"And why call ye me, Lord, Lord, and do not the things
which I say?" Luke 6:46
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: olly@lfix.co.uk, jlt@wvinter.net, brett_schwarz@yahoo.com
Subject: Re: PGACCESS Error Relative Path @ export table
In-Reply-To: <1028159509.22663.70.camel@linda>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox