From: John L. Turner <jlt@wvinter.net>
To: pgsql-interfaces@postgresql.org
Subject: Re: PGACCESS Error Relative Path @ export table
Date: Wed, 31 Jul 2002 12:55:19 +0000
Message-ID: <200207311255.19111.jlt@wvinter.net> (raw)
In-Reply-To: <200207310809460620.0004FEBD@radove.kretzer.local>
References: <HKEIIDPFPDBMOMDLIEEGAEMNCKAA.iavor.raytchev@verysmall.org>
<200207301745.26472.jlt@wvinter.net>
<200207310809460620.0004FEBD@radove.kretzer.local>
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}
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: jlt@wvinter.net
Subject: Re: PGACCESS Error Relative Path @ export table
In-Reply-To: <200207311255.19111.jlt@wvinter.net>
* 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