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.
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 |