From: | Lukas Ertl <l(dot)ertl(at)univie(dot)ac(dot)at> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Backup question |
Date: | 2001-07-03 08:43:03 |
Message-ID: | Pine.BSF.4.33.0107031033160.188-100000@pcle2.cc.univie.ac.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I have a question concerning database backups. From what I've learned in
the Admin guide, simply letting our ADSM backup run over the files will
not provide a consistent backup of the databases, so I should use pg_dump
or pg_dumpall.
Ok, now since this is a multi-user box I've setup password authentication
in pg_hba.conf for all users. With this configuration I cannot run
pg_dumpall anymore, I tried to run it with "pg_dumpall -u" and I get:
[pgsql(at)gerda ~/data]$ pg_dumpall -u
--
-- pg_dumpall (7.1.2) -u
--
\connect template1
DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database
WHERE datname = 'template0');
Password:
psql: Password authentication failed for user 'pgsql'
DELETE FROM pg_group;
Password:
Password:
--
-- Database template1
--
\connect template1 pgsql
\connect template1 pgsql
Username: Password:
DELETE FROM pg_group;
Password:
Password:
--
-- Database template1
--
\connect template1 pgsql
\connect template1 pgsql
Username: Password:
Connection to database 'template1' failed.
ERROR: Missing '=' after 'pgsql' in conninfo
pg_dump failed on template1, exiting
It doesn't accept my password (although I'm sure I typed correctly), and
it doesn't dump anything. Using pg_dump works, but this is quite
inacceptable since I don't want to dump each database on its own.
Another question is how I should dump the db on a nightly cron job, since
it always asks for a password, and I found no way of supplying it except
by typing it in at the prompt (do I really have to work with expect?).
TIA,
regards,
le
--
Lukas Ertl eMail: l(dot)ertl(at)univie(dot)ac(dot)at
WWW-Redaktion Tel.: (+43 1) 4277-14073
Zentraler Informatikdienst (ZID) Fax.: (+43 1) 4277-9140
der Universität Wien
From | Date | Subject | |
---|---|---|---|
Next Message | tamsin | 2001-07-03 10:07:55 | RE: Backup question |
Previous Message | Tom Lane | 2001-07-03 01:56:48 | Re: Regression on 7.1.2 fails 17/76 - is it up to date? |