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

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Tom LaneDate: 2002-12-16 21:41:56
Subject: Re: Redhat Database ???
Previous:From: Josh BerkusDate: 2002-12-16 21:28:37
Subject: Re: Redhat Database ???

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