| From: | nolan(at)celery(dot)tssi(dot)com |
|---|---|
| To: | dev(at)archonet(dot)com (Richard Huxton) |
| Cc: | kdeepa(at)midascomm(dot)com (Deepa K), pgsql-general(at)postgresql(dot)org |
| Subject: | Re: About Pgdump |
| Date: | 2003-09-19 13:16:54 |
| Message-ID: | 20030919131701.25689.qmail@celery.tssi.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Friday 19 September 2003 07:35, Deepa K wrote:
> > Hi all,
> > I want to take backup of our online system on daily basis using
> > crontab. But actually the pg_hba.conf is configured with password
> > security.
> > How I can take the backup without setting password. Or is their any
> > other
> > way to take backup.
>
> Look for the .pgpass entry in the document index. You can create a private
> file containing usernames/passwords for databases.
A second possibility is to create another system and postgres account with
sufficient permissions to run the backup and both 'local' and 'ident sameuser'
in pg_hba.conf. (That's how I have the postgres account set up.)
Then run the backup via cron. You can also use that account to run
periodic vacuums.
--
Mike Nolan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2003-09-19 13:18:39 | Re: 'order by' does "wrong" with unicode-chars (german umlauts) |
| Previous Message | Richard Huxton | 2003-09-19 13:11:16 | Re: Column defaults fail with rules on view |