Mark Forums Read

Simple asynchronous replication - anything?

Go Back

comp.databases.postgresql comp.databases.postgresql

Reply

Page 1 of 2

1

#1

Old

Marcin Kasperski

Posts: n/a

Simple asynchronous replication - anything? - 05-31-2008 , 11:11 AM

Hello...

I spent some time looking for - what I thought - simple and frequently
used thing: some solution to asynchronously pull changes from one
database to another database, which would connect from time to time
to grab updates. Plain old idea of copying data from the hosted
machine to home one for backup and offline reporting.

Bad luck. There are a few tools clearly oriented for online (or
semi-online) work, but permanent connection between machines seems
to be non-negotiated restriction.

Did I miss sth?

I started to consider writing myself some scripts (around the idea
of enabling WAL archiving, copying WAL files and simulating restore),
but I am unlucky enough to cross architecture boundaries (i386 on
source, amd64 on destination). Is it possible to convert backups
and WALs for another architecture somehow?

--
----------------------------------------------------------------------

Quote:

Marcin Kasperski | A process that is too complex will fail.
http://mekk.waw.pl | (Booch)
|
----------------------------------------------------------------------

Reply With Quote

#2

Old

Peter Jones

Posts: n/a

Re: Simple asynchronous replication - anything? - 06-02-2008 , 07:36 PM

Marcin Kasperski <Marcin.Kasperski (AT) softax (DOT) com.pl> writes:

Quote:

I started to consider writing myself some scripts (around the idea
of enabling WAL archiving, copying WAL files and simulating restore),
but I am unlucky enough to cross architecture boundaries (i386 on
source, amd64 on destination). Is it possible to convert backups
and WALs for another architecture somehow?

Why not use pg_dump and pg_restore with the plain text formats? With
the plain text format, pg_dump will generate a compressed ASCII dump
(using SQL IIRC) that will work no matter what the byte ordering is.

--
Peter Jones [pjones at domain below]
pmade inc. - http://pmade.com

Reply With Quote

#3

Old

Peter Jones

Posts: n/a

Re: Simple asynchronous replication - anything? - 06-02-2008 , 07:36 PM

Marcin Kasperski <Marcin.Kasperski (AT) softax (DOT) com.pl> writes:

Quote:

I started to consider writing myself some scripts (around the idea
of enabling WAL archiving, copying WAL files and simulating restore),
but I am unlucky enough to cross architecture boundaries (i386 on
source, amd64 on destination). Is it possible to convert backups
and WALs for another architecture somehow?

Why not use pg_dump and pg_restore with the plain text formats? With
the plain text format, pg_dump will generate a compressed ASCII dump
(using SQL IIRC) that will work no matter what the byte ordering is.

--
Peter Jones [pjones at domain below]
pmade inc. - http://pmade.com

Reply With Quote

#4

Old

Peter Jones

Posts: n/a

Re: Simple asynchronous replication - anything? - 06-02-2008 , 07:36 PM

Marcin Kasperski <Marcin.Kasperski (AT) softax (DOT) com.pl> writes:

Quote:

I started to consider writing myself some scripts (around the idea
of enabling WAL archiving, copying WAL files and simulating restore),
but I am unlucky enough to cross architecture boundaries (i386 on
source, amd64 on destination). Is it possible to convert backups
and WALs for another architecture somehow?

Why not use pg_dump and pg_restore with the plain text formats? With
the plain text format, pg_dump will generate a compressed ASCII dump
(using SQL IIRC) that will work no matter what the byte ordering is.

--
Peter Jones [pjones at domain below]
pmade inc. - http://pmade.com

Reply With Quote

#5

Old

Peter Jones

Posts: n/a

Re: Simple asynchronous replication - anything? - 06-02-2008 , 07:36 PM

Marcin Kasperski <Marcin.Kasperski (AT) softax (DOT) com.pl> writes:

Quote:

I started to consider writing myself some scripts (around the idea
of enabling WAL archiving, copying WAL files and simulating restore),
but I am unlucky enough to cross architecture boundaries (i386 on
source, amd64 on destination). Is it possible to convert backups
and WALs for another architecture somehow?

Why not use pg_dump and pg_restore with the plain text formats? With
the plain text format, pg_dump will generate a compressed ASCII dump
(using SQL IIRC) that will work no matter what the byte ordering is.

--
Peter Jones [pjones at domain below]
pmade inc. - http://pmade.com

Reply With Quote

#6

Old

Peter Jones

Posts: n/a

Re: Simple asynchronous replication - anything? - 06-02-2008 , 07:36 PM

Marcin Kasperski <Marcin.Kasperski (AT) softax (DOT) com.pl> writes:

Quote:

I started to consider writing myself some scripts (around the idea
of enabling WAL archiving, copying WAL files and simulating restore),
but I am unlucky enough to cross architecture boundaries (i386 on
source, amd64 on destination). Is it possible to convert backups
and WALs for another architecture somehow?

Why not use pg_dump and pg_restore with the plain text formats? With
the plain text format, pg_dump will generate a compressed ASCII dump
(using SQL IIRC) that will work no matter what the byte ordering is.

--
Peter Jones [pjones at domain below]
pmade inc. - http://pmade.com

Reply With Quote

#7

Old

Peter Jones

Posts: n/a

Re: Simple asynchronous replication - anything? - 06-02-2008 , 07:36 PM

Marcin Kasperski <Marcin.Kasperski (AT) softax (DOT) com.pl> writes:

Quote:

I started to consider writing myself some scripts (around the idea
of enabling WAL archiving, copying WAL files and simulating restore),
but I am unlucky enough to cross architecture boundaries (i386 on
source, amd64 on destination). Is it possible to convert backups
and WALs for another architecture somehow?

Why not use pg_dump and pg_restore with the plain text formats? With
the plain text format, pg_dump will generate a compressed ASCII dump
(using SQL IIRC) that will work no matter what the byte ordering is.

--
Peter Jones [pjones at domain below]
pmade inc. - http://pmade.com

Reply With Quote

#8

Old

Peter Jones

Posts: n/a

Re: Simple asynchronous replication - anything? - 06-02-2008 , 07:36 PM

Marcin Kasperski <Marcin.Kasperski (AT) softax (DOT) com.pl> writes:

Quote:

I started to consider writing myself some scripts (around the idea
of enabling WAL archiving, copying WAL files and simulating restore),
but I am unlucky enough to cross architecture boundaries (i386 on
source, amd64 on destination). Is it possible to convert backups
and WALs for another architecture somehow?

Why not use pg_dump and pg_restore with the plain text formats? With
the plain text format, pg_dump will generate a compressed ASCII dump
(using SQL IIRC) that will work no matter what the byte ordering is.

--
Peter Jones [pjones at domain below]
pmade inc. - http://pmade.com

Reply With Quote

#9

Old

Peter Jones

Posts: n/a

Re: Simple asynchronous replication - anything? - 06-02-2008 , 07:36 PM

Marcin Kasperski <Marcin.Kasperski (AT) softax (DOT) com.pl> writes:

Quote:

I started to consider writing myself some scripts (around the idea
of enabling WAL archiving, copying WAL files and simulating restore),
but I am unlucky enough to cross architecture boundaries (i386 on
source, amd64 on destination). Is it possible to convert backups
and WALs for another architecture somehow?

Why not use pg_dump and pg_restore with the plain text formats? With
the plain text format, pg_dump will generate a compressed ASCII dump
(using SQL IIRC) that will work no matter what the byte ordering is.

--
Peter Jones [pjones at domain below]
pmade inc. - http://pmade.com

Reply With Quote

#10

Old

Marcin Kasperski

Posts: n/a

Re: Simple asynchronous replication - anything? - 06-06-2008 , 05:51 PM

Peter Jones <dev-null (AT) pmade (DOT) com> writes:

Quote:

Marcin Kasperski <Marcin.Kasperski (AT) softax (DOT) com.pl> writes:
I started to consider writing myself some scripts (around the idea
of enabling WAL archiving, copying WAL files and simulating restore),
but I am unlucky enough to cross architecture boundaries (i386 on
source, amd64 on destination). Is it possible to convert backups
and WALs for another architecture somehow?

Why not use pg_dump and pg_restore with the plain text formats? With
the plain text format, pg_dump will generate a compressed ASCII dump
(using SQL IIRC) that will work no matter what the byte ordering is.

Once pg_dump starts taking 3 hours to finish, one starts looking for
alternatives ;-)

PS Finally I managed to learn and configure Slony-I, it was less
painful than I expected after first looks at the docs.

--
----------------------------------------------------------------------

Quote:

Marcin Kasperski | If Staff, Scope and Schedule are all fixed,
http://mekk.waw.pl | managers will have no options, other than
| prayer. (Martin)
----------------------------------------------------------------------

Reply With Quote

Reply

Page 1 of 2

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.