Jan Wieck JanWieck at Yahoo.com
Sat Dec 15 07:04:58 PST 2007
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 #



More information about the Slony1-general mailing list