Обсуждение: About Pgdump
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
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
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 | +------------------------------+---------------------------------------------+
> 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
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/
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