Re: pg_dump problems - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump problems
Date
Msg-id 23142.1167935951@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump problems  (JTyrrell <jtyrrell_@hotmail.com>)
Responses Re: pg_dump problems  (JTyrrell <jtyrrell_@hotmail.com>)
List pgsql-general
JTyrrell <jtyrrell_@hotmail.com> writes:
> 1. pg_dump -s doesn't work. I've tried using a load of other options and
> none at all but no luck.

> 2. I'm running as root so wont be a problem there, and the file im dumping
> to has full permissions for everyone.

> What makes this even more confusing is I tried pg_dump with a database name
> that doesnt exist and tried dumping from database root with a user that
> doesn't have permission to do that. Both gave the same results as before.
> Its basically creating the file i need, looking for the database and not
> finding it. When you dump an empty database the file at least has some info
> on session authorization and the schema. Im getting nothing!

It's really hard to believe that pg_dump would write nothing to either
the output file or stderr.  The only thought that comes to mind is that
if this machine has SELinux enabled, the SELinux policy might be
forbidding it from writing on the output file.  What's the platform,
exactly?

            regards, tom lane

pgsql-general by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: Dependency conflicts on CentOS 4.4
Next
From: Dimitri Fontaine
Date:
Subject: Re: Need help in PGSQL