Re: regular backups - super user

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: info(at)bignose(dot)ca
Cc: "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: regular backups - super user
Date: 2003-11-01 12:13:37
Message-ID: 20031101121336.A9460@bacon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 30/10/2003 15:29 Jeff MacDonald wrote:
> Hi,
>
> WHen i run pg_dumpall as the super user [postgres in my case] it asks
> for a password for every database. I don't know my users passwords. Is
> there a way to make the super user able to backup without passwords ?

What version of PG are you using? I've just tried this on my 7.3.4 box and
I don't get asked for user passwords.

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex 2003-11-01 13:20:42 Re: PG_RESTORE/DUMP Question
Previous Message Dann Corbit 2003-11-01 06:19:01 Re: How to set up a table where 2 columns together must be unique?