pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PGACCESS Error Relative Path @ export table
12+ messages / 6 participants
[nested] [flat]

* PGACCESS Error Relative Path @ export table
@ 2002-07-30 17:45  John L. Turner <jlt@wvinter.net>
  0 siblings, 2 replies; 12+ messages in thread

From: John L. Turner @ 2002-07-30 17:45 UTC (permalink / raw)
  To: pgsql-interfaces

Hi:

Newbe trying to learn pgaccess' import / export of tables

ERROR
"Relative Path not allowed for servers side copy command"

Version downloaded today (Tuesday 30 July 02) was 0.98.8 
( even though the/pgaccess/lib/mainlib.tcl says 0.98.7 )

I opened a test database, created with the command
psql mytestdb <  /pgaccess/demo/formdemo.sql

Open Data base with no local host given,
AND with my local host IP #

I did start postmaster with -i

Then From Main pgaccess Menu: Database | Export Table
Tried to export the table phonebook, received above ERROR

I entered the path /home/jlt/phonebook.txt
ERROR received.

Also tested ~/phonebook.txt
Also tested 192.168.110.42:~/phonebook.txt
__________________________________________

Thanks for ANY pointers

John Turner
http://home.ntelos.net/~JLT
"Just because you do not know the answer
does not mean that someone else does"
Stephen J. Gould, {rip}



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PGACCESS Error Relative Path @ export table
@ 2002-07-31 06:09  Andreas Kretzer <andi@kretzer-berlin.de>
  parent: John L. Turner <jlt@wvinter.net>
  1 sibling, 1 reply; 12+ messages in thread

From: Andreas Kretzer @ 2002-07-31 06:09 UTC (permalink / raw)
  To: pgsql-interfaces

On 30.07.2002 at 17:45 John L. Turner wrote:

>Hi:
>
>Newbe trying to learn pgaccess' import / export of tables
>
>ERROR
>"Relative Path not allowed for servers side copy command"
>
>Version downloaded today (Tuesday 30 July 02) was 0.98.8 
>( even though the/pgaccess/lib/mainlib.tcl says 0.98.7 )
>
>I opened a test database, created with the command
>psql mytestdb <  /pgaccess/demo/formdemo.sql
>
>Open Data base with no local host given,
>AND with my local host IP #
>
>I did start postmaster with -i
>
>Then From Main pgaccess Menu: Database | Export Table
>Tried to export the table phonebook, received above ERROR
>
>I entered the path /home/jlt/phonebook.txt
>ERROR received.
Are you sure that the error was the same? It might have been
'access denied'. Try /tmp/phonebook.txt

>
>Also tested ~/phonebook.txt
>Also tested 192.168.110.42:~/phonebook.txt

Hmm... It should have been possible (except it is explicitly
catched by pgaccess. But of course the home directory
would have been that of the postgres backend processes'
user.

Hope this helps
Andreas




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PGACCESS Error Relative Path @ export table
@ 2002-07-31 10:23  Nigel J. Andrews <nandrews@investsystems.co.uk>
  parent: John L. Turner <jlt@wvinter.net>
  1 sibling, 0 replies; 12+ messages in thread

From: Nigel J. Andrews @ 2002-07-31 10:23 UTC (permalink / raw)
  To: John L. Turner <jlt@wvinter.net>; +Cc: pgsql-interfaces

On Tue, 30 Jul 2002, John L. Turner wrote:

> Hi:
> 
> Newbe trying to learn pgaccess' import / export of tables
> 
> ERROR
> "Relative Path not allowed for servers side copy command"
> 
> Version downloaded today (Tuesday 30 July 02) was 0.98.8 
> ( even though the/pgaccess/lib/mainlib.tcl says 0.98.7 )

I was going to say that this throws doubt on a correct installation of the new
version but then I haven't checked that the new version has had mainlib.tcl
unpdated for the new number.

> 
> I opened a test database, created with the command
> psql mytestdb <  /pgaccess/demo/formdemo.sql
> 
> Open Data base with no local host given,
> AND with my local host IP #
> 
> I did start postmaster with -i

Well, you need that -i switch because you've specified the local host IP. If
your leave the host and port fields blank, i.e. zero length fields, then you
won't need the -i

> 
> Then From Main pgaccess Menu: Database | Export Table
> Tried to export the table phonebook, received above ERROR
> 
> I entered the path /home/jlt/phonebook.txt
> ERROR received.
> 
> Also tested ~/phonebook.txt
> Also tested 192.168.110.42:~/phonebook.txt
> __________________________________________

No idea, I haven't looked at this.


-- 
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PGACCESS Error Relative Path @ export table
@ 2002-07-31 12:55  John L. Turner <jlt@wvinter.net>
  parent: Andreas Kretzer <andi@kretzer-berlin.de>
  0 siblings, 2 replies; 12+ messages in thread

From: John L. Turner @ 2002-07-31 12:55 UTC (permalink / raw)
  To: pgsql-interfaces

Andreas Kretzer, wanted me to know...
> On 30.07.2002 at 17:45 John L. Turner wrote:
> >Hi:
> >
> >Newbe trying to learn pgaccess' import / export of tables
> >
> >ERROR
> >"Relative Path not allowed for servers side copy command"
> >
> >Version downloaded today (Tuesday 30 July 02) was 0.98.8
> >( even though the/pgaccess/lib/mainlib.tcl says 0.98.7 )
> >
> >I opened a test database, created with the command
> >psql mytestdb <  /pgaccess/demo/formdemo.sql
> >
> >Open Data base with no local host given,
> >AND with my local host IP #
> >
> >I did start postmaster with -i
> >
> >Then From Main pgaccess Menu: Database | Export Table
> >Tried to export the table phonebook, received above ERROR
> >
> >I entered the path /home/jlt/phonebook.txt
> >ERROR received.
>
> Are you sure that the error was the same? It might have been
> 'access denied'. Try /tmp/phonebook.txt
>
> >Also tested ~/phonebook.txt
> >Also tested 192.168.110.42:~/phonebook.txt
>
> Hmm... It should have been possible (except it is explicitly
> catched by pgaccess. But of course the home directory
> would have been that of the postgres backend processes'
> user.
>
> Hope this helps
> Andreas
_________________
Seem to have found the answer ( at least ONE answer that worked)

Turns out that the only directory that I have permission to write to is:
/var/lib/pgsql/

I started the postmaster -1  as user  postgres

SO that leads to the bottom line Question:
How does a user in postgresql obtain permissions to other directories ?

Thanks to anyone for a kick in pants to find the answer.

P.S. Why didn't the original message just say permissions not set for X user ?

Regards to all that answered before,

John Turner

"Just because you do not know the answer
does not mean that someone else does"
Stephen J. Gould, {rip}



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PGACCESS Error Relative Path @ export table
@ 2002-07-31 13:32  Brett Schwarz <brett_schwarz@yahoo.com>
  parent: John L. Turner <jlt@wvinter.net>
  1 sibling, 1 reply; 12+ messages in thread

From: Brett Schwarz @ 2002-07-31 13:32 UTC (permalink / raw)
  To: jlt@wvinter.net; +Cc: pgsql-interfaces

On Wed, 2002-07-31 at 05:55, John L. Turner wrote:
> Andreas Kretzer, wanted me to know...
> > On 30.07.2002 at 17:45 John L. Turner wrote:
> > >Hi:
> > >
> > >Newbe trying to learn pgaccess' import / export of tables
> > >
> > >ERROR
> > >"Relative Path not allowed for servers side copy command"
> > >
> > >Version downloaded today (Tuesday 30 July 02) was 0.98.8
> > >( even though the/pgaccess/lib/mainlib.tcl says 0.98.7 )
> > >
> > >I opened a test database, created with the command
> > >psql mytestdb <  /pgaccess/demo/formdemo.sql
> > >
> > >Open Data base with no local host given,
> > >AND with my local host IP #
> > >
> > >I did start postmaster with -i
> > >
> > >Then From Main pgaccess Menu: Database | Export Table
> > >Tried to export the table phonebook, received above ERROR
> > >
> > >I entered the path /home/jlt/phonebook.txt
> > >ERROR received.
> >
> > Are you sure that the error was the same? It might have been
> > 'access denied'. Try /tmp/phonebook.txt
> >
> > >Also tested ~/phonebook.txt
> > >Also tested 192.168.110.42:~/phonebook.txt
> >
> > Hmm... It should have been possible (except it is explicitly
> > catched by pgaccess. But of course the home directory
> > would have been that of the postgres backend processes'
> > user.
> >
> > Hope this helps
> > Andreas
> _________________
> Seem to have found the answer ( at least ONE answer that worked)
> 
> Turns out that the only directory that I have permission to write to is:
> /var/lib/pgsql/
> 
> I started the postmaster -1  as user  postgres
> 
> 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.
 
> Thanks to anyone for a kick in pants to find the answer.
> 
> P.S. Why didn't the original message just say permissions not set for X user ?
> 

I just sent a patch in, so that it gives a decent error message. Not
sure if it will get applied or not...


> Regards to all that answered before,
> 
> John Turner
> 
> "Just because you do not know the answer
> does not mean that someone else does"
> Stephen J. Gould, {rip}
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
-- 
Brett Schwarz
brett_schwarz AT yahoo.com




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PGACCESS Error Relative Path @ export table
@ 2002-07-31 14:45  John L. Turner <jlt@wvinter.net>
  parent: Brett Schwarz <brett_schwarz@yahoo.com>
  0 siblings, 2 replies; 12+ messages in thread

From: John L. Turner @ 2002-07-31 14:45 UTC (permalink / raw)
  To: Brett Schwarz <brett_schwarz@yahoo.com>; +Cc: pgsql-interfaces

Brett Schwarz, wanted me to know...
> On Wed, 2002-07-31 at 05:55, John L. Turner wrote:
> > Andreas Kretzer, wanted me to know...
> >
> > > On 30.07.2002 at 17:45 John L. Turner wrote:
> > > >Hi:
> > > >
> > > >Newbe trying to learn pgaccess' import / export of tables
> > > >
> > > >ERROR
> > > >"Relative Path not allowed for servers side copy command"
> > > >
> > > >Version downloaded today (Tuesday 30 July 02) was 0.98.8
> > > >( even though the/pgaccess/lib/mainlib.tcl says 0.98.7 )
> > > >
> > > >I opened a test database, created with the command
> > > >psql mytestdb <  /pgaccess/demo/formdemo.sql
> > > >
> > > >Open Data base with no local host given,
> > > >AND with my local host IP #
> > > >
> > > >I did start postmaster with -i
> > > >
> > > >Then From Main pgaccess Menu: Database | Export Table
> > > >Tried to export the table phonebook, received above ERROR
> > > >
> > > >I entered the path /home/jlt/phonebook.txt
> > > >ERROR received.
> > >
> > > Are you sure that the error was the same? It might have been
> > > 'access denied'. Try /tmp/phonebook.txt
> > >
> > > >Also tested ~/phonebook.txt
> > > >Also tested 192.168.110.42:~/phonebook.txt
> > >
> > > Hmm... It should have been possible (except it is explicitly
> > > catched by pgaccess. But of course the home directory
> > > would have been that of the postgres backend processes'
> > > user.
> > >
> > > Hope this helps
> > > Andreas
> >
> > _________________
> > Seem to have found the answer ( at least ONE answer that worked)
> >
> > Turns out that the only directory that I have permission to write to is:
> > /var/lib/pgsql/
> >
> > I started the postmaster -1  as user  postgres
> >
> > 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.
>

1) My system is Linux SuSE 8.0 release with
 	postgresql-7.2-70
 	pgaccess 0.98.8

2) The database I opened, was created by user postgres as follows:
 >psql mytestdb < /usr/share/doc/packages/postgresql-tk/formdemo.sql
   exited from psql .

3) I started pgaccess as user jlt ( normal user me ). @  /home/jlt
   Within pgaccess, USERS tab, I added jlt (me) as a user. 

4) Tested import and exporting of a table:
     Can not get permission to read or write to anything
     other than directory:     /var/lib/pgsql
     Was able to import and export files from that one directory.

Is it a security issue that prevents me as a normal user from
accessing those other directories, if so, why do I have permission
to /var/lib/pgsql to copy the file to another directory ( I assume 
a fat32 mount could allow me to steal that data, because 
once there, anyone could read/write to it...
Seems like a tangle web has been woven ;-)

> > Thanks to anyone for a kick in pants to find the answer.
> >
> > P.S. Why didn't the original message just say permissions not set for X
> > user ?
>
> I just sent a patch in, so that it gives a decent error message. Not
> sure if it will get applied or not...
>

Would like to see a simular corrected message when trying to Create a NEW
database with pgaccess:

"Tcl error executing pg_exec create database mytestdb

is not a valid postgresq connection"

That type of message is not too helpful to newbies like me.

Best regards for quick replies!
John Turner



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PGACCESS Error Relative Path @ export table
@ 2002-07-31 17:27  John L. Turner <jlt@wvinter.net>
  parent: C. Maj <cmaj@freedomcorpse.info>
  1 sibling, 0 replies; 12+ messages in thread

From: John L. Turner @ 2002-07-31 17:27 UTC (permalink / raw)
  To: C. Maj <cmaj@freedomcorpse.info>; +Cc: pgsql-interfaces

C. Maj, wanted me to know...
> On Wed, 31 Jul 2002, John L. Turner waxed:
>
> <snip>
>
> > > > P.S. Why didn't the original message just say permissions not set for
> > > > X user ?
> > >
> > > I just sent a patch in, so that it gives a decent error message. Not
> > > sure if it will get applied or not...
>
> No, I just put some stuff in CVS to allow for import/export a la the
> psql \copy command, which is really COPY FROM stdin/stdout
> It's at pgaccess.org
>
> > Would like to see a simular corrected message when trying to Create a NEW
> > database with pgaccess:
> >
> > "Tcl error executing pg_exec create database mytestdb
> >
> > is not a valid postgresq connection"
> >
> > That type of message is not too helpful to newbies like me.
> >
> > Best regards for quick replies!
> > John Turner
>
> I didn't know you could make new databases with pgaccess.  Huh.  I tried
> it and it seems to work, but my pg_hba.conf is not permissive enough to
> let me connect to the new database.  Perhaps that is your problem?  Are
> you connecting as a user who has privilege enough to create databases?
>
> --Chris

Mine looks like this...

pg_hba.conf
# TYPE     DATABASE    IP_ADDRESS    MASK               AUTH_TYPE  AUTH_ARGUMENT

local      all                                          trust
host       all         127.0.0.1     255.255.255.255    trust
_________________________

I did not MAKE a new database in pgaccess.
I was able to ONLY add to an existing one,
created by user postgres as follows:
 
postgres@X:~>psql mytestdb <  /usr/share/doc/packages/postgresql-tk/formdemo.sql

Question:
What user were you when you created a NEW pgaccess database ?
You maybe on to something here.


-- 
John



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PGACCESS Error Relative Path @ export table
@ 2002-07-31 18:05  John L. Turner <jlt@wvinter.net>
  parent: C. Maj <cmaj@freedomcorpse.info>
  1 sibling, 0 replies; 12+ messages in thread

From: John L. Turner @ 2002-07-31 18:05 UTC (permalink / raw)
  To: C. Maj <cmaj@freedomcorpse.info>; +Cc: pgsql-interfaces

C. Maj, wanted me to know...

<snip>
> I didn't know you could make new databases with pgaccess.  Huh.  I tried
> it and it seems to work, but my pg_hba.conf is not permissive enough to
> let me connect to the new database.  Perhaps that is your problem?  Are
> you connecting as a user who has privilege enough to create databases?
>
> --Chris

_____________ WELL _____
I just discovered that Any user that can open any existing database, 
with  pgaccess, can (while that 1st db is still open!)
create another NEW empty database.

Then close the first one, open the New Empty one that was just created and 
create new tables.

New features or bugs ?
-- 
John



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PGACCESS Error Relative Path @ export table
@ 2002-07-31 18:19  Andreas Kretzer <andi@kretzer-berlin.de>
  parent: John L. Turner <jlt@wvinter.net>
  1 sibling, 0 replies; 12+ messages in thread

From: Andreas Kretzer @ 2002-07-31 18:19 UTC (permalink / raw)
  To: pgsql-interfaces

On 31.07.2002 at 12:55 John L. Turner wrote:

>Andreas Kretzer, wanted me to know...
>> On 30.07.2002 at 17:45 John L. Turner wrote:
>> >Hi:
>> >
>> >Newbe trying to learn pgaccess' import / export of tables
>> >
>> >ERROR
>> >"Relative Path not allowed for servers side copy command"
>> >
>> >Version downloaded today (Tuesday 30 July 02) was 0.98.8
>> >( even though the/pgaccess/lib/mainlib.tcl says 0.98.7 )
>> >
>> >I opened a test database, created with the command
>> >psql mytestdb <  /pgaccess/demo/formdemo.sql
>> >
>> >Open Data base with no local host given,
>> >AND with my local host IP #
>> >
>> >I did start postmaster with -i
>> >
>> >Then From Main pgaccess Menu: Database | Export Table
>> >Tried to export the table phonebook, received above ERROR
>> >
>> >I entered the path /home/jlt/phonebook.txt
>> >ERROR received.
>>
>> Are you sure that the error was the same? It might have been
>> 'access denied'. Try /tmp/phonebook.txt
>>
>> >Also tested ~/phonebook.txt
>> >Also tested 192.168.110.42:~/phonebook.txt
>>
>> Hmm... It should have been possible (except it is explicitly
>> catched by pgaccess. But of course the home directory
>> would have been that of the postgres backend processes'
>> user.
>>
>> Hope this helps
>> Andreas
>_________________
>Seem to have found the answer ( at least ONE answer that worked)
>
>Turns out that the only directory that I have permission to write to is:
>/var/lib/pgsql/
>
>I started the postmaster -1  as user  postgres
>

This is probably the home directory of the user postgres.
But you should have access to /tmp too! But be sure that
there is no file of the name you choose generated by another
user. Files in /tmp are usually protected by a bit in the
directory attributes of to prevent other users from deleting
or changing files even if the directory itself has write permissions
for everybody.

Greetings
Andreas

>SO that leads to the bottom line Question:
>How does a user in postgresql obtain permissions to other directories ?
>
>Thanks to anyone for a kick in pants to find the answer.
>
>P.S. Why didn't the original message just say permissions not set for X
>user ?
>
>Regards to all that answered before,
>
>John Turner
>
>"Just because you do not know the answer
>does not mean that someone else does"
>Stephen J. Gould, {rip}
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org






^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PGACCESS Error Relative Path @ export table
@ 2002-07-31 19:46  C. Maj <cmaj@freedomcorpse.info>
  parent: John L. Turner <jlt@wvinter.net>
  1 sibling, 2 replies; 12+ messages in thread

From: C. Maj @ 2002-07-31 19:46 UTC (permalink / raw)
  To: John L. Turner <jlt@wvinter.net>; +Cc: pgsql-interfaces@postgresql.org, pgaccess - developers <developers@pgaccess.org>

On Wed, 31 Jul 2002, John L. Turner waxed:

<snip>

> > > P.S. Why didn't the original message just say permissions not set for X
> > > user ?
> >
> > I just sent a patch in, so that it gives a decent error message. Not
> > sure if it will get applied or not...

No, I just put some stuff in CVS to allow for import/export a la the
psql \copy command, which is really COPY FROM stdin/stdout
It's at pgaccess.org

> Would like to see a simular corrected message when trying to Create a NEW
> database with pgaccess:
>
> "Tcl error executing pg_exec create database mytestdb
>
> is not a valid postgresq connection"
>
> That type of message is not too helpful to newbies like me.
>
> Best regards for quick replies!
> John Turner

I didn't know you could make new databases with pgaccess.  Huh.  I tried
it and it seems to work, but my pg_hba.conf is not permissive enough to
let me connect to the new database.  Perhaps that is your problem?  Are
you connecting as a user who has privilege enough to create databases?

--Chris


-- 

cmaj_at_freedomcorpse_dot_info
0xC0051F6A
5EB8 2035 F07B 3B09 5A31  7C09 196F 4126 C005 1F6A





^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PGACCESS Error Relative Path @ export table
@ 2002-07-31 23:51  Oliver Elphick <olly@lfix.co.uk>
  parent: John L. Turner <jlt@wvinter.net>
  1 sibling, 1 reply; 12+ messages in thread

From: Oliver Elphick @ 2002-07-31 23:51 UTC (permalink / raw)
  To: jlt@wvinter.net; +Cc: Brett Schwarz <brett_schwarz@yahoo.com>; pgsql-interfaces

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 




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PGACCESS Error Relative Path @ export table
@ 2002-08-01 08:35  John L. Turner <jlt@wvinter.net>
  parent: Oliver Elphick <olly@lfix.co.uk>
  0 siblings, 0 replies; 12+ messages in thread

From: John L. Turner @ 2002-08-01 08:35 UTC (permalink / raw)
  To: Oliver Elphick <olly@lfix.co.uk>; +Cc: 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 



^ permalink  raw  reply  [nested|flat] 12+ messages in thread


end of thread, other threads:[~2002-08-01 08:35 UTC | newest]

Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-30 17:45 PGACCESS Error Relative Path @ export table John L. Turner <jlt@wvinter.net>
2002-07-31 06:09 ` Andreas Kretzer <andi@kretzer-berlin.de>
2002-07-31 12:55   ` John L. Turner <jlt@wvinter.net>
2002-07-31 13:32     ` Brett Schwarz <brett_schwarz@yahoo.com>
2002-07-31 14:45       ` John L. Turner <jlt@wvinter.net>
2002-07-31 19:46         ` C. Maj <cmaj@freedomcorpse.info>
2002-07-31 17:27           ` John L. Turner <jlt@wvinter.net>
2002-07-31 18:05           ` John L. Turner <jlt@wvinter.net>
2002-07-31 23:51         ` Oliver Elphick <olly@lfix.co.uk>
2002-08-01 08:35           ` John L. Turner <jlt@wvinter.net>
2002-07-31 18:19     ` Andreas Kretzer <andi@kretzer-berlin.de>
2002-07-31 10:23 ` Nigel J. Andrews <nandrews@investsystems.co.uk>

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