Thread: can't read - permissions error (13)

Greetings,

My office installation, Mandrake 7.1 /  python 1.5.2 / pq 7.0.2 works great.

At home, Mandrake 7.2 / same python and pg gives a permissions error  of backend cannot  COPY
due to permissions error (13).

I tried all combinations of adding postgres to my group / adding me to postgres group and setting my /home ... to group
postgres.

Still no joy.  If I cp the files I want to import to /home/postgres/data, it will read them.

The only differences that I can find between the two machines is that  in the office, all appropriate processes run as
postgreswith UID = 28. 

At home there is one process "dip" that runs as UID 40, other postgres related processes run as postgres with uid=40.

Does any one know what "dip'" is and why it had the same uid as postgres?

When I  "\i"  in psql, the file that contains my sql creates, grants,  etc. works fine from my home directory until it
hitsthe COPY ... FROM instruction. 

The sql and text data files are identical home and work as are the directory structures.

Please ... any other things to try?





Timothy D. Morris, MS
Department of Family Medicine
tdmorris@med.umich.edu
voice 734 998-7120 x 339
page 734 670-1366
Linux is like a TeePee -  No Windows, No Gates, Apache Inside.

I have used Mandrake 7.2 for while too. I found it is much less stable
and reliable 7.0. I found there were some seriously messup in the
filesystem and the compiler did not work properly somethimes, though
much better the Rhat 7.0

I would used mandrake 7.0 or Rhat 6.2 for anything serious. I myself use
Mandrake 7.0 and Rhat 6.2 with KDE2.1 on top of them. So far so good.
Better than any other options i have tryed.


Philip


-----Original Message-----
From:    Timothy Morris
Sent:    Wed 3/28/2001 10:43 AM
To:    Pgsql-admin@postgresql.org
Cc:
Subject:    [ADMIN] can't read - permissions error (13)

Greetings,

My office installation, Mandrake 7.1 /  python 1.5.2 / pq 7.0.2 works
great.

At home, Mandrake 7.2 / same python and pg gives a permissions error  of
backend cannot  COPY
due to permissions error (13).

I tried all combinations of adding postgres to my group / adding me to
postgres group and setting my /home ... to group postgres.

Still no joy.  If I cp the files I want to import to
/home/postgres/data, it will read them.

The only differences that I can find between the two machines is that
in the office, all appropriate processes run as postgres with UID = 28.

At home there is one process "dip" that runs as UID 40, other postgres
related processes run as postgres with uid=40.

Does any one know what "dip'" is and why it had the same uid as
postgres?

When I  "\i"  in psql, the file that contains my sql creates, grants,
etc. works fine from my home directory until it hits the COPY ... FROM
instruction.

The sql and text data files are identical home and work as are the
directory structures.

Please ... any other things to try?





Timothy D. Morris, MS
Department of Family Medicine
tdmorris@med.umich.edu
voice 734 998-7120 x 339
page 734 670-1366
Linux is like a TeePee -  No Windows, No Gates, Apache Inside.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly