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(at)lfix(dot)co(dot)uk>
To: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)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(dot)Elphick(at)lfix(dot)co(dot)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
>