dbTalk Databases Forums  

Simple asynchronous replication - anything?

Go Back dbTalk Databases Forums Databases comp.databases.postgresql Simple asynchronous replication - anything?

comp.databases.postgresql comp.databases.postgresql


Discuss Simple asynchronous replication - anything? in the comp.databases.postgresql forum.



Reply
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
Marcin Kasperski
 
Posts: n/a

Default 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
  #12  
Old   
Marcin Kasperski
 
Posts: n/a

Default 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
  #13  
Old   
Marcin Kasperski
 
Posts: n/a

Default 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
  #14  
Old   
Marcin Kasperski
 
Posts: n/a

Default 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
  #15  
Old   
Marcin Kasperski
 
Posts: n/a

Default 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
  #16  
Old   
Marcin Kasperski
 
Posts: n/a

Default 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
  #17  
Old   
Marcin Kasperski
 
Posts: n/a

Default 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 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear 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.


Contact Us - dbTalk Databases Forums - Archive - Top