From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Tomi N/A <hefest(at)gmail(dot)com> |
Cc: | George Weaver <gweaver(at)shaw(dot)ca>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: database backup trouble |
Date: | 2007-02-02 13:25:52 |
Message-ID: | 45C33BE0.6040604@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tomi N/A wrote:
> 2007/2/2, George Weaver <gweaver(at)shaw(dot)ca>:
>>
>> From: "Tomi N/A"
>>
>> > At this point, I decided to try a much more primitive approach: using
>> > a windows scheduled task running a .bat or .cmd script which in turn
>> > calls pg_dump.
>>
>> It might be helpful if you provided the exact pg_dump command you are
>> trying
>> to use, as well as the text of the .bat file you set up.
>
> I did exactly that a bit into my message (should have probably pointed
> it out at the beginning).
> Anyway, here it is again:
> pg_dump -h localhost -U myuser mydatabase -f outputfile.backup
Should work if the executing user has permission to write to the output
file. You've not specified a directory for the file though, so there's
no way to check.
> Oh, and I forgot to ask another question in the original message: why
> can a linux user with an invalid or non-existant .pgpass successfully
> use pg_dumpall (pg_dumpall -U existing_pg_role > dump.sql) and read
> any data he/she cares to read?
Can't. Not unless you've set pg_hba.conf to allow it. Not unless you've
found a gaping hole that no-one else has noticed.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | George Weaver | 2007-02-02 13:33:58 | Re: database backup trouble |
Previous Message | Richard Huxton | 2007-02-02 13:22:29 | Re: Query optimization problem |