Thread: About Pgdump

About Pgdump

From
Deepa K
Date:
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.

TIA

regards,
Deepa K


Re: About Pgdump

From
Richard Huxton
Date:
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.

--
  Richard Huxton
  Archonet Ltd

Re: About Pgdump

From
Paul Thomas
Date:
On 19/09/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.

You could su to the postgres superuser to do the backup or maybe use a
.pgpass file (needs at least 7.3 IIRC).

HTH

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

Re: About Pgdump

From
nolan@celery.tssi.com
Date:
> 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

Re: About Pgdump

From
"Edwin Quijada"
Date:
Where can I find that file .pgpass??
Can I create ?
How ate the entry in this file???


>From: Richard Huxton <dev@archonet.com>
>To: Deepa K <kdeepa@midascomm.com>, pgsql-general@postgresql.org
>Subject: Re: [GENERAL] About Pgdump
>Date: Fri, 19 Sep 2003 10:13:19 +0100
>
>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.
>
>--
>   Richard Huxton
>   Archonet Ltd
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.yupimsn.com/


Re: About Pgdump

From
"Nigel J. Andrews"
Date:
On Fri, 19 Sep 2003, Edwin Quijada wrote:

>
> Where can I find that file .pgpass??
> Can I create ?
> How ate the entry in this file???

Not for <7.3:

touch ~/.pgpass
chmod 0600 ~/.pgpass
echo '*:*:*:username:password' > ~/.pgpass

Note that this presumes you are logged in as the user who will be dumping the
database(s).


>
> >From: Richard Huxton <dev@archonet.com>
> >To: Deepa K <kdeepa@midascomm.com>, pgsql-general@postgresql.org
> >Subject: Re: [GENERAL] About Pgdump
> >Date: Fri, 19 Sep 2003 10:13:19 +0100
> >
> >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.
> >
> >--
> >   Richard Huxton
> >   Archonet Ltd


--
Nigel J. Andrews