Re: Problems with pg_dump

From: Mark Thomas <thomas(at)pbegames(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problems with pg_dump
Date: 2002-12-16 21:36:33
Message-ID: 5.1.0.14.2.20021216163534.02305070@pbegames.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

At 04:19 PM 12/16/02 -0500, Tom Lane wrote:
>papapep <papapep(at)gmx(dot)net> writes:
> >>> You mean you're doing
> >>> pg_dump ... >DATABASE.out
> >>> where DATABASE.out already exists and is marked read-only?
>
> > No. It exists after doing pg_dump....etc,etc.. Before I've removed it
> > to avoid these problems.
>
>That's odd.
>
> > But the question is, how is that pg_dump creates a file with
> > read-only permissions?....astonishing for me....is it the default
> > profile?? It isn't written in any of the docs I've read about it.
>
>Well, pg_dump is not creating the file in this situation --- your shell
>is. So it's got to have something to do with shell settings. May I
>inquire what you have "umask" set to? Also, just exactly what
>permissions is the file created with (ls -l output would be good).

ls -ld . would be useful too. Could have setuid on for someone other than
the user.

Mark Thomas
---
thomas(at)pbegames(dot)com ----> http://www.pbegames.com/~thomas
Play by Electron Games -> http://www.pbegames.com Free Trial Games

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-12-16 21:41:56 Re: Redhat Database ???
Previous Message Josh Berkus 2002-12-16 21:28:37 Re: Redhat Database ???