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:4
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
Hi All,
I'm stuck to an issue while cloning the pgsql database, can you please
help, or give any docs to help out.
Query - Trying to have same database on two seprate linux servers. One
will be used to upport Applications and other will be used for Report
generation only.
Want to keep both th
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
Hi there:
I am just wondering if this is a doable method to
clone a database to other machine. I have three identical linux serves with
postgresql server installed at the same location. I have a new customized
database and initial data load into server 1. Can I just copy all of the
databas
14 matches
Mail list logo