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: (view raw, whole thread or download thread mbox)
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 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 ---->
Play by Electron Games -> 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-2017 The PostgreSQL Global Development Group