From: | <me(at)alternize(dot)com> |
---|---|
To: | <jessica(at)roefs(dot)be> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: howto to do an automated backup on windows xp? |
Date: | 2005-09-06 10:22:31 |
Message-ID: | 055c01c5b2cc$e58c5920$8d02a8c0@iwing |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
here's what i'm doing on a daily basis on our w2k3 server:
for each db:
"C:\Program Files\PostgreSQL\8.0\Bin\pg_dump" -Fc -Z 5 -U sa -f
e:\backup\somedbname.db somedbname
this works fine once you change localhost access in pg_hba.conf from "md5"
to "trust"
cheers,
thomas
----- Original Message -----
From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: <jessica(at)roefs(dot)be>
Cc: <pgsql-novice(at)postgresql(dot)org>
Sent: Tuesday, September 06, 2005 12:13 PM
Subject: Re: [NOVICE] howto to do an automated backup on windows xp?
> On Fri, 2005-09-02 at 10:47 +0200, Jessica Broomans/Ivo wrote:
>> Just a short question with hopefully a bit longer answer:
>>
>> how do I get around the password prompt?
>
> You don't say nearly enough about the circumstances, so this advice is
> very general.
>
> You need to look at the external file $PGDATA/pg_hba.conf, which defines
> the access rights for your databases. Here you can set what kind of
> authentication is required, according to how the user is accessing the
> server.
>
> If you need to supply a password to a script, you can create a .pgpass
> file in your home directory.
>
> Both these issues are described in the documentation.
>
> --
> Oliver Elphick olly(at)lfix(dot)co(dot)uk
> Isle of Wight http://www.lfix.co.uk/oliver
> GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
> ========================================
> Do you want to know God? http://www.lfix.co.uk/knowing_god.html
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-09-06 13:16:23 | Re: Inserting data in other db |
Previous Message | Oliver Elphick | 2005-09-06 10:13:19 | Re: howto to do an automated backup on windows xp? |