Sat Dec 15 07:04:58 PST 2007
- Previous message: [Slony1-general] shortcut for telling slony to simply replicate everything?
- Next message: [Slony1-general] compile errors
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On 12/13/2007 9:42 AM, Josh Harrison wrote: > > > On Wed, Dec 12, 2007 at 02:22:58PM -0500, Geoffrey wrote: > >> I was afraid that would be the answer, thanks. > > > > This is an easy script to write, though. You can get every table > name out > > of postgres quite easily. > > > How do you write this script? I have a database with 100 tables and i > have to replicate them all. And if tey dont have a PK then you have to > generate a slony serial key...right!!!! > josh Note that the slony serial key feature is considered depricated and will be removed in Slony-I version 2.0. So if you are in the process of setting up a new cluster, do yourself a favor and create your own PK's for all tables and don't use TABLE ADD KEY. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck at Yahoo.com #
- Previous message: [Slony1-general] shortcut for telling slony to simply replicate everything?
- Next message: [Slony1-general] compile errors
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list