On Fri, Jun 17, 2005 at 01:45:34PM -0400, Berend Tober wrote:
> Gavin Love wrote:
> >Here is the script I use for my daily backups nothing special but it
> >works well. Just run it as a user with admin privs on the database.
> >It will pull the list of all your databases except templates and dump
ighty modified with some
extra features useful to me and maybe to you, too:
pg_backup.sh:
#!/bin/bash
# Subject:Re: [GENERAL] Backing up multiple databases
# From: Gavin Love <[EMAIL PROTECTED]>
# Date: Fri, 17 Jun 2005 15:52:34 +0100
# To: Jacob Atzen <[EMAIL PROTECTED]>
I'd use pg_dump anyway - unless you have hundreds of databases, it makes
it easier to keep by backups separate.
I will do that then. Thanks.
Here is the script I use for my daily backups nothing special but it
works well. Just run it as a user with admin privs on the database. It
will pull
Jacob Atzen <[EMAIL PROTECTED]> writes:
> On Fri, Jun 17, 2005 at 01:21:13PM +0100, Richard Huxton wrote:
>> I'd use pg_dump anyway - unless you have hundreds of databases, it makes
>> it easier to keep by backups separate.
> I will do that then. Thanks.
Note that you probably also want to run "
On Fri, Jun 17, 2005 at 08:43:21AM -0400, Christopher Browne wrote:
> >> There is an option to pg_dumpall, -O, which makes it dump stuff
> >> without owners. See the following:
> > Ah yes, I should have told you that the server is running 7.4.5,
> > sorry. I will consider upgrading if there's no
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Jacob Atzen)
wrote:
> On Fri, Jun 17, 2005 at 01:13:16PM +0100, Raymond O'Donnell wrote:
>> On 17 Jun 2005 at 13:52, Jacob Atzen wrote:
>
>> > The second problem is a matter of database ownership. Apparently
>> > pg_dumpall will dump th
On Fri, Jun 17, 2005 at 01:21:13PM +0100, Richard Huxton wrote:
> What's the problem with creating a superuser called "postgres" on both
> machines? Or you could choose not to dump (or restore) ownership
> information (--no-owner). The section of the manuals you want is
> "PostgreSQL Client Appl
Jacob Atzen wrote:
Hello list,
I have a setup with multiple databases running on one Postgres. Say,
db1, db2 and db3.
I have two problems with this setup, the first is how to restore one of
the databases and leave the other two intact. If for example somebody
accidentally deletes data from db1
On Fri, Jun 17, 2005 at 01:13:16PM +0100, Raymond O'Donnell wrote:
> On 17 Jun 2005 at 13:52, Jacob Atzen wrote:
> > The second problem is a matter of database ownership. Apparently
> > pg_dumpall will dump the owners of the database along with the data.
> > This is causing trouble when I try to r
On 17 Jun 2005 at 13:52, Jacob Atzen wrote:
> The second problem is a matter of database ownership. Apparently
> pg_dumpall will dump the owners of the database along with the data.
> This is causing trouble when I try to restore the dump on a server where
There is an option to pg_dumpall, -O, wh
Hello list,
I have a setup with multiple databases running on one Postgres. Say,
db1, db2 and db3.
I have two problems with this setup, the first is how to restore one of
the databases and leave the other two intact. If for example somebody
accidentally deletes data from db1 which needs to be res
11 matches
Mail list logo
