On 11/8/2013 11:44 AM, zach cruise wrote:
my response hasn't shown up on
http://postgresql.1045698.n5.nabble.com/upgrading-to-9-3-td5777291.html so
trying again. sorry if both show up.
anyway, on database reorganization - is it recommended to group all
sequences and domains under one public schema? or is a sequence tied
to a table as its counter?
I would keep sequences in the same schema as the related table. anything
else is chaotic. if a domain is used by all the schemas, then putting
it in public makes sense, otherwise, if its just used by one schema, it
should logically be part of that schema.
what are some replication choices for x64 systems since slony is not
an option?
the built in streaming replication is the usual first choice.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
