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
s
simple: /usr/bin/pg_dumpall > filename - this will create a backup that
restores using SQL statements.
regards,
-John
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Peter Schuller
Sent: Saturday, March 17, 2001 9:39 PM
To: [EMAIL PROTECTED]
Subjec
Hello,
How do people normally backup up postgresql databases? The obviously safe
solution is to shut down the database during backup, but is Postgresql
storage such that it's safe to backup a running DB? I.e., is the database
guaranteed to be in a consistent state after restoration?
I'm talking
