anything. I've teetered back and forth for some time.
Tim Frank
Original Message dated 20/03/01, 6:48:08 AM
Author: Michael Ansley <[EMAIL PROTECTED]>
Re: RE: [ADMIN] Backing up postgresql databases:
Is there any reason why programs like this could not be given a simple
properties
;<<<<<<<<<<<<<<<<
On 20/03/01, 3:33:52 AM, Thierry Besancon <[EMAIL PROTECTED]>
wrote regarding Re: [ADMIN] Backing up postgresql databases:
> Dixit Tim Frank <[EMAIL PROTECTED]> (le Tue, 20 Mar 2001
00:14:11 GMT) :
> » H
Title: RE: [ADMIN] Backing up postgresql databases
Is there any reason why programs like this could not be given a simple properties file which contains the username and password. This file could then be passed on the command line, but nobody (other than, say, root, or postgres) would have
Dixit Tim Frank <[EMAIL PROTECTED]> (le Tue, 20 Mar 2001 00:14:11 GMT) :
» Have your shell script do
»
» export PGUSER=username
» export PGPASSWORD=password
»
» before you run pg_dumpall in the same script. The user/pass would most
» likely have to be a superuser to have access to all d
omething better.
Hope that helps.
Tim Frank
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 19/03/01, 5:06:16 AM, [EMAIL PROTECTED] ("Peter Schuller")
wrote regarding Re:
"Peter Schuller" <[EMAIL PROTECTED]> writes:
> I do have a question though. Contrary to Grant, I can't use a trust policy,
> even on the local machine. As a result, I need to use password
> authentication. However, pg_dumpall seems to generally screw up.
pg_dumpall is very unfriendly to password
Hello,
> From what I understand (and I'm still fairly new to Postgres) you won't get
> a perfect copy while Postmaster is running, but there is a way to backup the
> entire database while it's running: pg_dumpall.
Ah, perfekt! And thanks to Grant for that bash script :)
I do have a question tho
Peter,
>From what I understand (and I'm still fairly new to Postgres) you won't get
a perfect copy while Postmaster is running, but there is a way to backup the
entire database while it's running: pg_dumpall.
pg_dumpall by default is in the /usr/bin directory, and they usage is
simple: /usr/bin/
