Re: pg_dump problems

From: JTyrrell <jtyrrell_(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump problems
Date: 2007-01-05 09:16:14
Message-ID: 8175027.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Im using Red Hat Enterprise Linux 4. Thing is it worked before christmas but
doesn't now. I've just moved the data across by hand so its not too much of
a problem anymore. Might need to use dump again though so would be nice to
get the problem fixed

Tom Lane-2 wrote:
>
> JTyrrell <jtyrrell_(at)hotmail(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>
>

--
View this message in context: http://www.nabble.com/pg_dump-problems-tf2912789.html#a8175027
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-01-05 09:55:06 Re: Table inheritance implementation.
Previous Message Devrim GUNDUZ 2007-01-05 09:09:32 Re: Dependency conflicts on CentOS 4.4