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

Re: PGACCESS Error Relative Path @ export table

From: "John L(dot) Turner" <jlt(at)wvinter(dot)net>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: PGACCESS Error Relative Path @ export table
Date: 2002-08-01 08:35:09
Message-ID: 200208010835.09014.jlt@wvinter.net (view raw or flat)
Thread:
Lists: pgsql-interfaces
Oliver Elphick, wanted me to know...
> 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).

Thank you for the reply !

Final question on that subject would be:

What is the purpose of the List of users that is set in:
             pgaccess [ Tab: Users ] ?

I noted that postgres is not in that list in the demo database supplied:     	    
.............  <    formdemo.sql  

Regards,
John


-- 
John 

In response to

pgsql-interfaces by date

Next:From: Corey GibbsDate: 2002-08-01 15:03:40
Subject: HEADS UP Everyone!
Previous:From: Ahmad MunifDate: 2002-08-01 05:18:22
Subject: Getting "unknown host name ..." complied with static library ?

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