On Thu, July 31, 2008 10:07 am, Chris wrote:
> Garg, Manjit wrote:
> Check out slony (http://slony.info/) - it's a master->multiple slave
> replication system and seems to work pretty well.
You can also try SkyTools (http://pgfoundry.org/projects/skytools/) - it's
far simpler to use and to manage
Garg, Manjit wrote:
> Hi ,
>
> Actually I was looking for some method / tool (utility) which keeps both
> the database on different servers in sync automatically.
>
> Looking for some features into postgres.conf file if possible.
There's no built in replication for postgres at the moment.
Che
ailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2008 8:22 PM
To: Garg, Manjit
Cc: [EMAIL PROTECTED]; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Clone a database to other machine
On 28/07/2008 18:32, Garg, Manjit wrote:
> But, actually I want to keep both the Databse in Sync. I want
On 30/07/2008 15:56, Garg, Manjit wrote:
Actually I was looking for some method / tool (utility) which keeps both
the database on different servers in sync automatically.
Ah, OK - I thought you meant that you needed a clone at specific
intervals. You can use Slony (www.slony.info) to do this.
On 28/07/2008 18:32, Garg, Manjit wrote:
But, actually I want to keep both the Databse in Sync. I want clone db
to get the data from Master in certain intervals.
DB dump size is 3 GB.
In that case, a cron job which dumps the data from the master and
reloads it on the other machine may be yo
ssage-
From: Francisco Reyes [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2008 10:42 PM
To: Garg, Manjit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Clone a database to other machine
On 12:44 pm 07/28/08 "Garg, Manjit" <[EMAIL PROTECTED]> wrote:
> I'm stuck t
Hi
And you can use Londiste from Skytools. It's simpler and better suited for
your task.
http://pgfoundry.org/projects/skytools/
Asko
On Mon, Jul 28, 2008 at 7:44 PM, Garg, Manjit <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I'm stuck to an issue while cloning the pgsql database, can you please
>
you can use slony-i
http://slony.info/
--- On Mon, 7/28/08, Garg, Manjit <[EMAIL PROTECTED]> wrote:
> From: Garg, Manjit <[EMAIL PROTECTED]>
> Subject: [GENERAL] Clone a database to other machine
> To: pgsql-general@postgresql.org
> Date: Monday, July 28, 2008, 4:44 PM
> Hi All,
>
> I'm stuck
On 1:32 pm 07/28/08 "Garg, Manjit" <[EMAIL PROTECTED]> wrote:
> But, actually I want to keep both the Databse in Sync. I want clone db
> to get the data from Master in certain intervals.
Sounds like you are looking for replication. Check
http://wiki.postgresql.org/wiki/Replication%2C_Clustering%
On 12:44 pm 07/28/08 "Garg, Manjit" <[EMAIL PROTECTED]> wrote:
> I'm stuck to an issue while cloning the pgsql database, can you
> please help, or give any docs to help out.
What is the issue?
> Query - Trying to have same database on two seprate linux servers.
Have you been able to pg_dump f
On Mon, Jul 28, 2003 at 01:38:34PM -0700, Terence Chang wrote:
> customized database and initial data load into server 1. Can I just
> copy all of the database files physically from server 1 to server 2
> and server 3? I assume this is one of the method to restore a
> database.
Not unless all the
On Mon, 28 Jul 2003, Terence Chang wrote:
> hi Scott:
>
> Would you be kind to tell me what commercial replication package out there?
> Thanks!
>
> Basically, my server will not be 24x7. So it is ok to shut down the machine.
> And we only want to clone the database for a brand new machine.
The
12 matches
Mail list logo
