You can use pg_dump while the application(s) that use the database are
active. pg_dump saves that database at a point in time. If the
application(s)
continue to modify the database after you use pg_dump, the script/archive
file created by pg_dump will not contain those modifications.

----- Original Message -----
From: "Yogvinder Singh" newgen.co.in>
To: postgresql.org>
Sent: Wednesday, January 17, 2007 9:59 PM
Subject: Re: [ADMIN] Incremental Backup of a particular database

Hi,

Does anyone know how to get the libpq++.so library added to a current
build? One of the developers wants to know where to find this library.
Is there a way to download or get that? We just have libpq.so, which is
the C library.

Thanks,
~Dan
=20
=20
--------------------------------------------------------

Information in this e-mail may be confidential. It is intended only for the=
addressee(s) identified above. If you are not the addressee(s), or an empl=
oyee or agent of the addressee(s), please note that any dissemination, dist=
ribution, or copying of this communication is strictly prohibited. If you h=
ave received this e-mail in error, please notify the sender of the error.

This is a multi-part message in MIME format.

------_=_NextPart_001_01C73B19.BFA2B551
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

There is no incremental backup process that focuses on an individual
database for PostgreSQL. Anything that has to do with PITR on a
PostgreSQL installation is system-wide, and cannot be configured to...

On Thu, 2007-01-18 at 05:23, Yogvinder Singh wrote:

Correct. You could replicate its tables to another server with slony
and then use that to make incrementals with PITR.

Maybe a better definition of what you're trying to do from a higher
level would help.

Ray Stell cns.vt.edu> writes:

Just call the new version --- you might need to give it an explicit -P
switch if you compiled it with a different default port number, but
that's about it.

regards, tom lane

On Wed, Jan 17, 2007 at 01:31:50PM -0800, Jeff Frost wrote:

Please, a couple of more questions about this upgrade process (never been through it, obviously).

1. I am backing up some of the config files that I know that I have touched:

postgresql.conf, pg_hba.conf

Are there other files down in there that I will need later that you tend to want to keep?

2. When you prepare to pg_dumpall using the new version, do you need to change all the
path vars to point to the new install such as LD_LIBRARY_PATH and PATH, or does just
an explicit call of the new pg_dumpall ok?

Thanks.

pg_dump is a utility for saving a PostgreSQL database into a script or an
archive file. The script files are in plain-text format and contain the SQL
commands required to reconstruct the database to the state it was in
at the time it was saved.

"At the time it was saved" What is the meaning of this statement?

Regards,
Yogvinder Singh,
Software Engineer, E-WorkStyle Group,
Newgen Software Technologies Ltd.
D-152, Okhla Phase - 1
New Delhi
Tel no 26815467 Ext 143

----- Original Message -----
From: "Yogvinder Singh" newgen.co.in>
To: "Andy Shellam (Mailing Lists)" mailnetwork.co.uk>
Cc: postgresql.org>
Sent: Thursday, January 18, 2007 10:44 AM
Subject: Re: [ADMIN] Incremental Backup of a particular database

Yes Database size is going to grow very large over time. The situation is
going to be like this that ther is one central server where n nr of
databases are there.
I want one of these databases to be restored to the Other database Server.
What i have found so far implies tht the whole of database server will be
restored not one particular database.

Any light on this ??

Regards,
Yogvinder Singh,
Software Engineer, E-WorkStyle Group,
Newgen Software Technologies Ltd.
D-152, Okhla Phase - 1
Tel no 26815467 Ext 143

----- Original Message -----
From: "Eduardo J. Ortega" cable.net.co>
To: postgresql.org>
Sent: Thursday, January 18, 2007 9:39 AM
Subject: Re: [ADMIN] Incremental Backup of a particular database

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
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, Shoaib Mir wrote:

I only want one of many databases to be restored to the other server
incrementally.
Is this possible?
If yes, Wht are the steps??

Regards,
Yogvinder Singh,
Software Engineer, E-WorkStyle Group,
Newgen Software Technologies Ltd.
D-152, Okhla Phase - 1
Tel no 26815467 Ext 143

----- Original Message -----
From: "Andy Shellam (Mailing Lists)" mailnetwork.co.uk>
To: "Yogvinder Singh" newgen.co.in>
Cc: postgresql.org>
Sent: Wednesday, January 17, 2007 8:17 PM
Subject: Re: [ADMIN] Incremental Backup of a particular database