backup: pg_dumpall and full backups in general

From: Dado Feigenblatt <dado(at)wildbrain(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: backup: pg_dumpall and full backups in general
Date: 2001-11-22 01:32:06
Message-ID: 3BFC5596.2030309@wildbrain.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

user "dado" is me, with full powers.

#: pg_dumpall
--
-- pg_dumpall (7.1.3)
--
\connect template1
DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database
WHERE datname = 'template0');

Password:
psql: Password authentication failed for user 'dado'

DELETE FROM pg_group;

Password:
<- here I typed the pw
CREATE GROUP "adminGroup" WITH SYSID 1;
Password:
psql: fe_sendauth: no password supplied
ALTER GROUP "adminGroup" ADD USER "";
Password:
psql: fe_sendauth: no password supplied
ALTER GROUP "adminGroup" ADD USER "";
Password:
psql: fe_sendauth: no password supplied
ALTER GROUP "adminGroup" ADD USER "";
Password:
<- here I typed the pw

--
-- Database template1
--
\connect template1 postgres
\connect template1 postgres
Connection to database 'template1' failed.
fe_sendauth: no password supplied

pg_dump failed on template1, exiting

It keeps asking for a password but won't take one.
It seems pg_dumpall won't pass it to psql.
Any idea?

BTW, I wrote my own pg_dumpall in Python with added functionality.
I think I need to move back to the original pg_dumpall just in case
things change and mine script stops working.
But wrapping around pg_dump, pg_dumpall, and psql isn't very easy
because of the prompts.
Any advice here? Is it ok for me to keep rely on my backup utility?

Also, I want to know what I need to make backups of in order to recreate
a full install of PostgreSQL.
Does pg_dump take care of everything? If I reload my backups, will I
have an exact copy of the original install?
I mean, not considering OIDs and such.

Thanks.

--
Dado Feigenblatt Wild Brain, Inc.
Technical Director (415) 216-2053
dado(at)wildbrain(dot)com San Francisco, CA.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dado Feigenblatt 2001-11-22 01:32:32 backup: restoring, problems with permissions
Previous Message Martijn van Oosterhout 2001-11-22 01:21:12 Re: Determining which index to create