Re: Automatic backup with Linux.

isn't there any faster method to backup data than pg_dump  ???

or is there a way to speed up pg_dump ???


----- Original Message -----
From: Oliver Elphick <olly@lfix.co.uk>
To: pginfo <pginfo@t1.unisoftbg.com>
Cc: <pgsql-admin@postgresql.org>
Sent: Saturday, July 20, 2002 3:38 PM
Subject: Re: [ADMIN] Automatic backup with Linux.


> On Sat, 2002-07-20 at 06:58, pginfo wrote:
> > My question:
> > 1. Ho to execute this script as user postgres under Linux. I will to use
> > crontab, but do not know how to execute pg_dump as another user.
>
> Become user postgres before you run "crontab -e".  On Debian you can
> instead use /etc/crontab, which has an extra field to define the user
> under whose uid the command will run.
>
> > 2. Is it possible to execute the backup script on working data base. I
> > haved problems with data integrity on oracle in this case and needet to
> > stop the oracle and then make backup.
>
> Yes it is possible.  pg_dump will not see any transaction that has not
> yet been committed at the time you start it, so its output will be
> consistent.  If you were using tar on the raw database files, you would
> probably need to stop the postmaster first.
>
> --
> Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> Isle of Wight, UK
> http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
>                  ========================================
>      "Behold, what manner of love the Father hath bestowed
>       upon us, that we should be called the sons of God..."
>                                 I John 3:1
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>