From: | "Moray McConnachie" <moray(dot)mcconnachie(at)computing-services(dot)oxford(dot)ac(dot)uk> |
---|---|
To: | "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Jeff MacDonald" <jeff(at)pgsql(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: doing backups |
Date: | 2000-04-03 12:09:29 |
Message-ID: | 000201bf9d9e$5968d7a0$01c8a8c0@malthouse.private.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>> Now if you make pgsql user and postgresql analgous to
>> root and unix, the postgres user shouldn't need a passwd.
>My root users always have passwords. *shrug* But you're right, automated
>backup on password protected databases is next to impossible right now,
>especially when using pg_dump. If those users want to enable you to do
>backups for them perhaps they should give you (and only you) some sort of
>ident controlled access.
I missed the first half of this, but, if I have understood correctly, I
don't think this is the case: you can do automated backups by doing
echo -e 'username\npassword\n' | pg_dump -u databasename
Yours,
Moray
From | Date | Subject | |
---|---|---|---|
Next Message | Rafal Slubowski | 2000-04-03 12:54:16 | Re: How do I change the default editor in psql |
Previous Message | Michael Ansley | 2000-04-03 11:29:50 | RE: Embedded SQL -- ecpg |