t; [mailto:[EMAIL PROTECTED] *On Behalf Of *Yogvinder Singh
> *Sent:* Thursday, January 18, 2007 5:23 AM
> *To:* Shoaib Mir
> *Cc:* pgsql-admin@postgresql.org
> *Subject:* Re: [ADMIN] Incremental Backup of a particular database
>
> So it means there is no way i can take incremental
.
- Original Message -
From: "Yogvinder Singh" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 17, 2007 9:59 PM
Subject: Re: [ADMIN] Incremental Backup of a particular database
pg_dump is a utility for saving a PostgreSQL database into a script or an
archive file. The script fi
5:23 AM
To: Shoaib Mir
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Incremental Backup of a particular database
So it means there is no way i can take incremental backup of one of the
databases from a postgresql database server??
Regards,
Yogvinder Singh,
Software Engineer, E-WorkSty
On Thu, 2007-01-18 at 05:23, Yogvinder Singh wrote:
> So it means there is no way i can take incremental backup of one of
> the databases from a postgresql database server??
Correct. You could replicate its tables to another server with slony
and then use that to make incrementals with PITR.
Ma
Message -
From: Shoaib Mir
To: Yogvinder Singh
Cc: pgsql-admin@postgresql.org
Sent: Thursday, January 18, 2007 4:07 PM
Subject: Re: [ADMIN] Incremental Backup of a particular database
When the pg_dump process starts it takes one point and then makes a backup
for that specific
26815467 Ext 143
- Original Message -
From: "Yogvinder Singh" <[EMAIL PROTECTED]>
To: "Andy Shellam (Mailing Lists)" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, January 18, 2007 10:44 AM
Subject: Re: [ADMIN] Incremental Backup of a particular database
> I only wan
uot;Andy Shellam (Mailing Lists)" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, January 18, 2007 10:44 AM
Subject: Re: [ADMIN] Incremental Backup of a particular database
> I only want one of many databases to be restored to the other server
> incrementally.
> Is this possible?
> If y
AIL PROTECTED]>
To:
Sent: Thursday, January 18, 2007 9:39 AM
Subject: Re: [ADMIN] Incremental Backup of a particular database
> Not sure, but i think WAL based incremental backup is for the whole
database
> cluster, and not for an specific database, so don't think this is going to
>
Not sure, but i think WAL based incremental backup is for the whole database
cluster, and not for an specific database, so don't think this is going to
work for you. Is yoor database too large? If not, you could stick to the old
fashioned pg_dump output.
On Wednesday 17 January 2007 10:23, Shoa
Message -
From: "Andy Shellam (Mailing Lists)" <[EMAIL PROTECTED]>
To: "Yogvinder Singh" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 17, 2007 8:17 PM
Subject: Re: [ADMIN] Incremental Backup of a particular database
> I believe the option for a "war
Yes, I guess that is true with 8.2 but with a few configurations for WAL
copying scripts.
Saw the following in documentation that specifies a good flow for doing it
--> http://www.postgresql.org/docs/8.2/static/warm-standby.html
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On
Shoaib Mir wrote:
Even with ver 8.1 you can use WAL archive backups (PITR) to implement
an incremental backup strategy.
Yes, true, but it's harder with 8.1 as you always have to start from a
base backup and roll WAL logs forward - without a custom script you
cannot "wait" for new WAL logs to ar
Even with ver 8.1 you can use WAL archive backups (PITR) to implement an
incremental backup strategy.
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/17/07, Andy Shellam (Mailing Lists) <
[EMAIL PROTECTED]> wrote:
I believe the option for a "warm standby" (which sounds like i
I believe the option for a "warm standby" (which sounds like it is what
you need) was made available in 8.2.0.
You'd have to look at the manual though, I haven't had time to
investigate, and I'm not sure whether it's cluster-wide, or
database-specific.
Yogvinder Singh wrote:
Hi Ppl,
I have
Hi Ppl,
I have Two PostgreSQL Database Servers. The situation is like this:-
1) On first database server ball the operations (i.e live server) will be done.
This server may contain n number of databases.
2) On the second database server, i want to keep one particular database (from
the first d
15 matches
Mail list logo
