Skip site navigation (1) Skip section navigation (2)

RE: Backup question

From: "tamsin" <tg_mail(at)bryncadfan(dot)co(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: RE: Backup question
Date: 2001-07-03 10:07:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
to do our nightly cron jobs we have a script like this:

pg_dump databasename | gzip > databasename.bak.gz


-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Lukas Ertl
Sent: 03 July 2001 09:43
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Backup question


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');

psql: Password authentication failed for user 'pgsql'

DELETE FROM pg_group;


-- Database template1
\connect template1 pgsql
\connect template1 pgsql
Username: Password:
DELETE FROM pg_group;


-- 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?).


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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

In response to


pgsql-novice by date

Next:From: Lukas ErtlDate: 2001-07-03 10:16:25
Subject: RE: Backup question
Previous:From: Lukas ErtlDate: 2001-07-03 08:43:03
Subject: Backup question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group