On Wed, Sep 06, 2017 at 08:22:14AM -0700, Steve Atkins wrote:
> > On Sep 6, 2017, at 6:00 AM, Marcin Giedz wrote:
> >
> > Hi, is there any way (3rd party software) to replicate particular
> > schema/table not the whole database with streaming replication built-in
> > mechanism ?
>
> I don't be
> On Sep 6, 2017, at 8:48 AM, Marcin Giedz wrote:
>
> Does pglogical support views replication as I can't find it in any
> restrictions ?
There's no need to replicate the contents of a view, as it doesn't contain any
data.
pglogical can replicate the initial schema, including any views, but
Does pglogical support views replication as I can't find it in any restrictions
?
Thx
Marcin
Od: "Steve Atkins"
Do: pgsql-general@postgresql.org
Wysłane: środa, 6 wrzesień 2017 17:22:14
Temat: Re: [GENERAL] Schema/table replication
> On Sep 6, 2017, at 6:00 AM, M
> On Sep 6, 2017, at 6:00 AM, Marcin Giedz wrote:
>
> Hi, is there any way (3rd party software) to replicate particular
> schema/table not the whole database with streaming replication built-in
> mechanism ?
I don't believe so. You can do that with logical replication in v10 -
https://www.po
Hi, is there any way (3rd party software) to replicate particular schema/table
not the whole database with streaming replication built-in mechanism ?
Thx
Marcin
On 16/08/2016 15:10, Ilya Kazakevich wrote:
An event is a row with a primary key along the lines of (colo, host,
category) and an associated set of tags, where each tag has a type
and a value
(eg: {"color": "red", "owner": "fred", "status": "open"...}).
What about simple table with several col
On Tue, Aug 16, 2016 at 6:38 PM, Chris Withers
wrote:
> Hi All,
>
> What would be the best schema to use when looking to implement an event
> stream with tagging and filtering?
>
> An event is a row with a primary key along the lines of (colo, host,
> category) and an associated set of tags, wher
Hi All,
What would be the best schema to use when looking to implement an event
stream with tagging and filtering?
An event is a row with a primary key along the lines of (colo, host,
category) and an associated set of tags, where each tag has a type and a
value (eg: {"color": "red", "owner"
>>> An event is a row with a primary key along the lines of (colo, host,
>>> category) and an associated set of tags, where each tag has a type
>>> and a value
>>> (eg: {"color": "red", "owner": "fred", "status": "open"...}).
>>
>> What about simple table with several columns and hstore field for
On 16/08/2016 14:29, Ilya Kazakevich wrote:
Hi,
An event is a row with a primary key along the lines of (colo, host,
category) and an associated set of tags, where each tag has a type and a value
(eg: {"color": "red", "owner": "fred", "status": "open"...}).
What about simple table with sever
Hi,
>An event is a row with a primary key along the lines of (colo, host,
>category) and an associated set of tags, where each tag has a type and a value
>(eg: {"color": "red", "owner": "fred", "status": "open"...}).
What about simple table with several columns and hstore field for tags?
You ma
Hi All,
What would be the best schema to use when looking to implement an event
stream with tagging and filtering?
An event is a row with a primary key along the lines of (colo, host,
category) and an associated set of tags, where each tag has a type and a
value (eg: {"color": "red", "owner"
On Thu, Mar 17, 2016 at 4:45 PM, Karsten Hilbert
wrote:
> On Fri, Mar 18, 2016 at 09:38:30AM +1300, drum.lu...@gmail.com wrote:
>
> > Can you please provide me a Query that tells me how much space is a
> Schema
> > in my DB?
>
> There's been a discussion on that recently (like last month)
> which
On Fri, Mar 18, 2016 at 09:38:30AM +1300, drum.lu...@gmail.com wrote:
> Can you please provide me a Query that tells me how much space is a Schema
> in my DB?
There's been a discussion on that recently (like last month)
which can be found in the archive.
Karsten
--
GPG key ID E4071346 @ eu.pool
Hi all,
Can you please provide me a Query that tells me how much space is a Schema
in my DB?
I'm using one but don't think it's right
>
> SELECT schema_name,
>pg_size_pretty(sum(table_size)::bigint),
>(sum(table_size) / pg_database_size(current_database())) * 100 as a
> FROM
On 2 March 2016 at 12:23, Scott Mead wrote:
>
> On Tue, Mar 1, 2016 at 6:07 PM, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
>> You should read the definitions for the functions you are using to
>> retrieve the sizes.
>>
>> http://www.postgresql.org/docs/current/static/functions-ad
On Tue, Mar 1, 2016 at 6:07 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> You should read the definitions for the functions you are using to
> retrieve the sizes.
>
> http://www.postgresql.org/docs/current/static/functions-admin.html
>
> +1, you've gotta be careful with each of th
You should read the definitions for the functions you are using to retrieve
the sizes.
http://www.postgresql.org/docs/current/static/functions-admin.html
On Tue, Mar 1, 2016 at 3:48 PM, drum.lu...@gmail.com
wrote:
> Hi there
>
> Wanna see how size a schema is in my PostgreSQL 9.2
>
> Got two
Hi there
Wanna see how size a schema is in my PostgreSQL 9.2
Got two queries - they return different values... can u please check?
cheers;
Query 1:
SELECT schema_name,
pg_size_pretty(sum(table_size)::bigint) as "disk space",
(sum(table_size) / pg_database_size(current_database())) * 100
On Thu, 23 Jul 2015, Melvin Davidson wrote:
Does this help?
Melvin,
Yep.
After pondering David's response I recognized my error: I had the permit
table as the center of the relationships when it should be the conditions
table. As you wrote, permits, parameters, and locations all feed the
Does this help?
CREATE TABLE permits
(
permit_number bigint,
...,
other_columns ,
...,
CONSTRAINT permits_pk PRIMARY KEY (permit_number)
);
CREATE TABLE parameters
(
permit_number bigint,
parameter varchar(50),
...,
other_columns ,
...,
CONSTRAINT parameters_pk PRIMARY KEY (permit_number, paramet
On Thu, 23 Jul 2015, David G. Johnston wrote:
Conditions <- (Permit + Location + Parameter + Frequency + Temporal (from,
until))
Monitoring <- (Condition + Event)
While you may require additional modelling tables to support your user
interface (i.e., picking valid combinations of PeLoPa when cr
On Thu, Jul 23, 2015 at 3:06 PM, Rich Shepard
wrote:
> While designing the schema for a new application have become
> high-centered
> and stuck relating some many-to-many tables. Fresh eyes and suggestions are
> needed on how to create many-to-many association tables among these five.
>
> Tab
While designing the schema for a new application have become high-centered
and stuck relating some many-to-many tables. Fresh eyes and suggestions are
needed on how to create many-to-many association tables among these five.
Table 'Permits': Contains information about each permit, PK is permi
While designing the schema for a new application have become high-centered
and stuck relating some many-to-many tables. Fresh eyes and suggestions are
needed on how to create many-to-many association tables among these five.
Table 'Permits': Contains information about each permit, PK is permi
On 4/13/15 6:21 AM, Anil Menon wrote:
In addition to all these comments
- If you use multiple databases, if you want to keep some "common"
tables (example counties_Table, My_company_details), its going to be a pain
- if you want to access tables across databases - you might need to
start using F
In addition to all these comments
- If you use multiple databases, if you want to keep some "common" tables
(example counties_Table, My_company_details), its going to be a pain
- if you want to access tables across databases - you might need to start
using FDWs (which is going to be a administrati
2015-04-13 10:43 GMT+02:00 Albe Laurenz :
> Michael Cheung wrote:
> > I have many similar database to store data for every customer.
> > Structure of database is almost the same.
> > As I use same application to control all these data, so I can only use
> > one database user to connect to these da
Michael Cheung wrote:
> I have many similar database to store data for every customer.
> Structure of database is almost the same.
> As I use same application to control all these data, so I can only use
> one database user to connect to these database.
> And I have no needs to query table for diff
On 4/13/2015 12:07 AM, Alban Hertroys wrote:
That's easier to backup, sure, but you can't restore a single customer's schema
easily that way. So if one customer messes up their data big time, you'll need
to restore a backup for all customers in the DB.
if you use pg_dump -Fc, then you can spe
> On 13 Apr 2015, at 4:20, Ian Barwick wrote:
>
> On 13/04/15 11:08, Michael Cheung wrote:
>> hi, all;
>>
>> I am new here. And I need some suggestion.
>>
>> I have many similar database to store data for every customer.
>> Structure of database is almost the same.
>> As I use same application
Thanks for your additional comment.
It is more clear, I'd better to using schema more than using database.
yours, michael
On Sun, 12 Apr 2015 19:24:30 -0700
John R Pierce wrote:
> On 4/12/2015 7:20 PM, Ian Barwick wrote:
> > If as you say access to the database is via a single application dat
Thanks for your suggestion.
I'd like to use schema as you suggest.
yours, michael
On Mon, 13 Apr 2015 11:20:59 +0900
Ian Barwick wrote:
> On 13/04/15 11:08, Michael Cheung wrote:
> > hi, all;
> >
> > I am new here. And I need some suggestion.
> >
> > I have many similar database to store data
On 4/12/2015 7:20 PM, Ian Barwick wrote:
If as you say access to the database is via a single application database
user, it will probably make more sense to use multiple schemas rather than
multiple databases. Keeping everything in one database will simplify
administration (e.g. making backups -
On 13/04/15 11:08, Michael Cheung wrote:
> hi, all;
>
> I am new here. And I need some suggestion.
>
> I have many similar database to store data for every customer.
> Structure of database is almost the same.
> As I use same application to control all these data, so I can only use
> one database
hi, all;
I am new here. And I need some suggestion.
I have many similar database to store data for every customer.
Structure of database is almost the same.
As I use same application to control all these data, so I can only use
one database user to connect to these database.
And I have no needs t
Hello
2013/10/10 Kalai R
> Hi,
>
> I am developing .Net application using PSQL. I am using npgsql to connect
> PSQL database. In single database I have more than one schemas. After I
> connect database I set search path using "Set Searchpath command" for the
> required schema. It works perfectl
Hi,
I am developing .Net application using PSQL. I am using npgsql to connect
PSQL database. In single database I have more than one schemas. After I
connect database I set search path using "Set Searchpath command" for the
required schema. It works perfectly.
But after sometime, I need to change
chiru r writes:
> Is there any schema(set search_path) behaviour changes from PostgreSQL9.1
> to PostgreSQL9.2 ?
Please read the release notes when updating to a new major version.
The first item under "Server Settings" in the 9.2 release notes is:
Silently ignore nonexistent schemas sp
> postgres=# select version();
> version
>
>
> ---
> PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
> 20080704
Hi All,
I have seen strange behaviour in PostgreSQL9.2 version,it has been allowing
to set search path any name,even the name is not created as a schema in
database.
Please find the below case between PostgreSQL9.1 and PostgreSQL9.2.
*PostgreSQL9.2:*
+
postgres=# select version();
Hi,
Dnia 28 lipca 2012 1:10 Adrian Klaver napisał(a):
> What where the deleted files?
>WAL, Logs, other?
> What type of WAL replication are you doing?
>Streaming, log shipping, etc?
> What are your settings for the WAL replication?
>In particular wal_keep_segments ?
> Is the WAL rep
On 07/27/2012 09:32 AM, Marek Kielar wrote:
Hi, again,
I'm sorry about the lack of version information - I concentrated so much on
describing the problem correctly, that I forgot to provide basic information.
The version at locations is 9.1.4 (though this is irrelevant now), the server
is 9.0
Hi, again,
I'm sorry about the lack of version information - I concentrated so much on
describing the problem correctly, that I forgot to provide basic information.
The version at locations is 9.1.4 (though this is irrelevant now), the server
is 9.0.4.
We found what the problem was. Another pr
On 07/26/2012 04:09 PM, Marek Kielar wrote:
Hi,
we are using "pg_dump -s" (schema-only) to copy the structure of a
template/prototype database as a set-up for several dozen Fedora boxes. The dump used to
work alright until very recently. Now, across new machines that are to be introduced into
Hi,
we are using "pg_dump -s" (schema-only) to copy the structure of a
template/prototype database as a set-up for several dozen Fedora boxes. The
dump used to work alright until very recently. Now, across new machines that
are to be introduced into the network it consistently refuses to dump
In response to Roger Leigh :
> On Thu, Feb 10, 2011 at 02:58:15PM -0700, Rob Sargent wrote:
> > On 02/10/2011 02:38 PM, Royce Ausburn wrote:
> > > My company is having trouble managing how we upgrade schema changes across
> > > many versions of our software. I imagine this is a common problem and
On Thu, Feb 10, 2011 at 02:58:15PM -0700, Rob Sargent wrote:
> On 02/10/2011 02:38 PM, Royce Ausburn wrote:
> > My company is having trouble managing how we upgrade schema changes across
> > many versions of our software. I imagine this is a common problem and
> > there're probably some neat solut
On 19/01/2012 20:14, Heine Ferreira wrote:
> Hi
>
> I saw with PGAdmin that there is a public schema in the default postgres
> database.
> Does every database have a public schema?
Yes.
> What is a schema and can you create your own?
A schema is a means of making logical divisions within your d
Hi
I saw with PGAdmin that there is a public schema in the default postgres
database.
Does every database have a public schema?
What is a schema and can you create your own?
Thanks
H.F.
On Jul 12, 2011, at 7:54 PM, Prabhat Kumar wrote:
> Today I need to create a schema for my application website that allows user
> comments too.
> I think we have to maintain hierarchical data and it is very common as all
> sites are supporting this feature.
> Can somebody suggest me some guidel
http://www.ferdychristant.com/blog//archive/DOMM-7QJPM7
On Sun, Jul 10, 2011 at 10:14 PM, Adarsh Sharma wrote:
> Dear all,
>
> Today I need to create a schema for my application website that allows user
> comments too.
>
> I think we have to maintain hierarchical data and it is very common as all
On Sun, Jul 10, 2011 at 10:14 PM, Adarsh Sharma
wrote:
> Dear all,
>
> Today I need to create a schema for my application website that allows user
> comments too.
>
> I think we have to maintain hierarchical data and it is very common as all
> sites are supporting this feature.
>
> Can somebody su
Dear all,
Today I need to create a schema for my application website that allows
user comments too.
I think we have to maintain hierarchical data and it is very common as
all sites are supporting this feature.
Can somebody suggest me some guidelines to follow and some links too.
Thanks
-
On Tue, Apr 05, 2011 at 06:33:46PM +0530, Vibhor Kumar wrote:
>
> On Apr 5, 2011, at 6:07 PM, Ray Stell wrote:
>
> > On Tue, Apr 05, 2011 at 03:58:46PM +0530, Vibhor Kumar wrote:
> >>
> >> Following are details:
> >> postgres=UC/postgres+
> >> [user] [privs] /[ ROLE who granted privs.
> >
> >
On Apr 5, 2011, at 6:07 PM, Ray Stell wrote:
> On Tue, Apr 05, 2011 at 03:58:46PM +0530, Vibhor Kumar wrote:
>>
>> Following are details:
>> postgres=UC/postgres+
>> [user] [privs] /[ ROLE who granted privs.
>
> What's the logic for reporting the U priv twice?
If you are talking about fol
On Tue, Apr 05, 2011 at 03:58:46PM +0530, Vibhor Kumar wrote:
>
> Following are details:
> postgres=UC/postgres+
> [user] [privs] /[ ROLE who granted privs.
What's the logic for reporting the U priv twice?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
[ Please don't overpost the list. Adding PG General List]
On Apr 5, 2011, at 3:30 AM, Ray Stell wrote:
> On Tue, Apr 05, 2011 at 02:42:30AM +0530, Vibhor Kumar wrote:
>>
>> On Apr 5, 2011, at 2:31 AM, Ray Stell wrote:
>>
>>> What does the results in col 'List of schemas Access privileges'
>>> i
On Apr 5, 2011, at 2:31 AM, Ray Stell wrote:
> What does the results in col 'List of schemas Access privileges'
> indicate? Are those three results split by the '/' char? What
> are the three sections? What is 'postgres+'
>
> Can't find this explained in the docs.
>
> template1-# \dn+ pg_ca
What does the results in col 'List of schemas Access privileges'
indicate? Are those three results split by the '/' char? What
are the three sections? What is 'postgres+'
Can't find this explained in the docs.
template1-# \dn+ pg_catalog
List of schemas
Name
...@yahoo.com
Sent: Wed, February 23, 2011 11:57:01 PM
Subject: RE: [GENERAL] schema Cleanning
I do not know what your criteria is for dropping things. But I would be very
sure that something is no longer used. For example, some tables are not used
but once a quarter or once a year. And the same is
Le 23/02/2011 09:10, salah jubeh a écrit :
> [...]
> This is a simple way to check if there is no activity on the table,
>
> SELECT relname,seq_tup_read,idx_tup_fetch FROM pg_stat_user_tables
> WHERE (idx_tup_fetch + seq_tup_read)= 0;
>
>
> Is there is any way to make similar checks on views
From: salah jubeh
To: pgsql-general@postgresql.org
Sent: Mon, February 21, 2011 4:53:41 PM
Subject: [GENERAL] schema Cleanning
Hello,
I am trying to drop deprecated tables, views, procedures from an existing
database, I am checking the pg_stat_user_tables view to check if the tables are
On Fri, 2011-02-11 at 08:35 -0500, Daniel Popowich wrote:
> think no software process can make anyone happy. It's a human
> process: declare someone the owner of the database schema, let them
> own the long term development of the schema, and if anyone needs a
> change, they have to communicat
> What about upgrades that can't be derived directly from an inspection
> of the schema? Some examples:
>
> - Adding a NOT NULL constraint (without adding a DEFAULT). You often
> want to precede this with filling in any existing NULL values, so the
> new constraint doesn't fail.
This is an imp
Hello,
I am trying to drop deprecated tables, views, procedures from an existing
database, I am checking the pg_stat_user_tables view to check if the tables are
accessed recently also to check live tuples. For deprecated views and
procedures, I am wondering How can I do that, for example suppos
On Feb 18, 2011, at 9:10 PM, trex005 wrote:
> I am trying to archive a schema, however there is a certain table that
> gets skipped with pd_dump
>
> The table's name is 'servers'. I checked to see if it is a reserved
> word, and it does not appear to be...
>
> Thinking I was missing something
On Friday, February 18, 2011 7:40:59 am trex005 wrote:
> I am trying to archive a schema, however there is a certain table that
> gets skipped with pd_dump
What does the log file show when you do the dump?
Any output to the screen when the dump is being run?
If not maybe run with -v switch to get
On 02/19/2011 08:03 AM, Raymond O'Donnell wrote:
On 18/02/2011 15:40, trex005 wrote:
I am trying to archive a schema, however there is a certain table that
gets skipped with pd_dump
The table's name is 'servers'. I checked to see if it is a reserved
word, and it does not appear to be...
Thinki
On 18/02/2011 15:40, trex005 wrote:
I am trying to archive a schema, however there is a certain table that
gets skipped with pd_dump
The table's name is 'servers'. I checked to see if it is a reserved
word, and it does not appear to be...
Thinking I was missing something I tried using -t serve
I am trying to archive a schema, however there is a certain table that
gets skipped with pd_dump
The table's name is 'servers'. I checked to see if it is a reserved
word, and it does not appear to be...
Thinking I was missing something I tried using -t servers, and I get :
pg_dump: No matching t
On Fri, Feb 11, 2011 at 8:35 AM, Daniel Popowich
wrote:
> FWIW, this is what I do:
>
> 1. I have a table in my database, meta, that contains exactly one
> row, and holds configuration information. A minimal version of this
> table:
>
>CREATE TABLE meta (
>id integer DEFAULT 1 NOT
In response to Alban Hertroys :
> On 10 Feb 2011, at 23:59, Bill Moran wrote:
>
> > The overview:
> > You store your schema and data as XML (this is easy to migrate to, because
> > it includes a tool that makes the XML from a live database)
> > Keep your XML schema files in some RCS.
>
> That re
Glenn Maynard writes:
> - Adding a NOT NULL constraint (without adding a DEFAULT). You often want
> to precede this with filling in any existing NULL values, so the new
> constraint doesn't fail.
> - Updating triggers, functions and their effects. For example, when I have
> an FTS index with a t
In response to Andre Lopes :
> Hi,
>
> Where can we donwload dbsteward?
You can't yet. We're still in the process of getting everything lined up
to release it.
We've registerd dbsteward.org, so when we have things ready, that'll be
where you can go. Expect it to come live in the next few mont
Hi,
Where can we donwload dbsteward?
Best Regards,
On Fri, Feb 11, 2011 at 5:16 AM, Bill Moran wrote:
> In response to Glenn Maynard :
>
>> On Thu, Feb 10, 2011 at 6:44 PM, Bill Moran wrote:
>>
>> > dbsteward can do downgrades ... you just feed it the old schema and
>> > the new schema in rev
On 10 Feb 2011, at 23:59, Bill Moran wrote:
> The overview:
> You store your schema and data as XML (this is easy to migrate to, because
> it includes a tool that makes the XML from a live database)
> Keep your XML schema files in some RCS.
That reminds me of something I've been wondering about -
On Fri, Feb 11, 2011 at 12:16 AM, Bill Moran wrote:
> The big caveat is that 99.9% of the database changes don't fall into those
> "nontrivial" categories, and dbsteward makes those 99.9% of the changes
> easy to do, reliable to reproduce, and easy to track.
>
My experience is maybe more like 95%
In response to Glenn Maynard :
> On Thu, Feb 10, 2011 at 6:44 PM, Bill Moran wrote:
>
> > dbsteward can do downgrades ... you just feed it the old schema and
> > the new schema in reverse of how you'd do an upgrade ;)
> >
> > Oh, also, it allows us to do installation-specific overrides. We use
>
On Thu, Feb 10, 2011 at 6:44 PM, Bill Moran wrote:
> dbsteward can do downgrades ... you just feed it the old schema and
> the new schema in reverse of how you'd do an upgrade ;)
>
> Oh, also, it allows us to do installation-specific overrides. We use
> this ONLY for DML for lookup lists where so
>
> Don't the bash scripts get checked in to .../perforce/cvs/svn/git/...?
> Aren't they part of the resources of the project(s)?
Yep - they absolutely are. The issue is that there're multiple branches
*potentially* having new scripts committed. Fortunately it's rare as the
release branches
>
> So, 10.0 at 10057.
> 11.0 at 11023.
>
> then 10.1 needs some fixes so db is bumped to 10058.
>
> Then, later, you can upgrade 10057 to 11023, but you cant get 10058 to 11023.
>
> Humm... maybe you need smarter upgrade scripts? Would having logic in the
> script help? Something like:
>
>
On 11/02/2011, at 9:59 AM, Thomas Kellerer wrote:
> Royce Ausburn wrote on 10.02.2011 22:38:
>> I'm really interested to hear how you guys manage schema upgrades in
>> the face of branches and upgrading from many different versions of
>> the database.
>
> We are quite happy with Liquibase. You c
On 02/10/2011 04:44 PM, Bill Moran wrote:
> In response to Rob Sargent :
>>
>> On 02/10/2011 03:59 PM, Bill Moran wrote:
>>> In response to Rob Sargent :
I for one will be waiting to see your dbsteward. How does it compare
functionally or stylistically with Ruby's migration tools (whic
On 02/10/2011 02:38 PM, Royce Ausburn wrote:
> Hi all,
>
> My company is having trouble managing how we upgrade schema changes across
> many versions of our software. I imagine this is a common problem and
> there're probably some neat solutions that we don't know about.
>
> For the last 1
Bill Moran wrote on 11.02.2011 00:37:
Anyway ... based on nothing more than a quick scan of their quickstart
page, here are the differences I see:
* Liquibase is dependent on you creating "changesets". I'm sure this
works, but we took a different approach with dbsteward. dbsteward
expects
In response to Rob Sargent :
>
> On 02/10/2011 03:59 PM, Bill Moran wrote:
> > In response to Rob Sargent :
> >> I for one will be waiting to see your dbsteward. How does it compare
> >> functionally or stylistically with Ruby's migration tools (which I found
> >> to be pretty cool and frustratin
In response to Thomas Kellerer :
> Bill Moran wrote on 10.02.2011 23:59:
> > The overview:
> > You store your schema and data as XML (this is easy to migrate to, because
> > it includes a tool that makes the XML from a live database)
> > Keep your XML schema files in some RCS.
> > When it's time f
On Thu, 10 Feb 2011 17:59:30 -0500, Bill Moran
wrote:
The overview:
You store your schema and data as XML (this is easy to migrate to,
because
it includes a tool that makes the XML from a live database)
We're doing a similar thing here except we're a Lisp shop so our
schema is defined as
On 02/10/2011 03:59 PM, Bill Moran wrote:
> In response to Rob Sargent :
>
>> Top-posting is frowned upon by some (not me), but since Bill started it...
>
> Oops ... the weird thing is that I'm usually really anal about not top-
> posting ...
>
>> I for one will be waiting to see your dbstewar
Bill Moran wrote on 10.02.2011 23:59:
The overview:
You store your schema and data as XML (this is easy to migrate to, because
it includes a tool that makes the XML from a live database)
Keep your XML schema files in some RCS.
When it's time for a new deployment, you run the dbsteward tool agains
In response to Rob Sargent :
> Top-posting is frowned upon by some (not me), but since Bill started it...
Oops ... the weird thing is that I'm usually really anal about not top-
posting ...
> I for one will be waiting to see your dbsteward. How does it compare
> functionally or stylistically wi
Royce Ausburn wrote on 10.02.2011 22:38:
I'm really interested to hear how you guys manage schema upgrades in
the face of branches and upgrading from many different versions of
the database.
We are quite happy with Liquibase. You can simply run it against a database and tell it
to migrate it t
In response to Andy Colson :
> On 2/10/2011 4:18 PM, Bill Moran wrote:
> >
> > We have this kickass solution we built at work called dbsteward that
> > just takes care of all of this for us, automatically. You just give
> > it the new version and the old version and it generates update statements
Top-posting is frowned upon by some (not me), but since Bill started it...
I for one will be waiting to see your dbsteward. How does it compare
functionally or stylistically with Ruby's migration tools (which I found
to be pretty cool and frustrating all in one go).
On 02/10/2011 03:18 PM, Bill
On 2/10/2011 4:18 PM, Bill Moran wrote:
We have this kickass solution we built at work called dbsteward that
just takes care of all of this for us, automatically. You just give
it the new version and the old version and it generates update statements
to feed into PG.
The reason I'm bringing th
We have this kickass solution we built at work called dbsteward that
just takes care of all of this for us, automatically. You just give
it the new version and the old version and it generates update statements
to feed into PG.
The reason I'm bringing this up is that we're working to release
dbs
On 2/10/2011 4:14 PM, Andy Colson wrote:
On 2/10/2011 3:38 PM, Royce Ausburn wrote:
Hi all,
My company is having trouble managing how we upgrade schema changes
across many versions of our software. I imagine this is a common
problem and there're probably some neat solutions that we don't know
a
On 2/10/2011 3:38 PM, Royce Ausburn wrote:
Hi all,
My company is having trouble managing how we upgrade schema changes across many
versions of our software. I imagine this is a common problem and there're
probably some neat solutions that we don't know about.
For the last 10 years we have be
Hi all,
My company is having trouble managing how we upgrade schema changes across many
versions of our software. I imagine this is a common problem and there're
probably some neat solutions that we don't know about.
For the last 10 years we have been writing bash shell scripts essentially
1 - 100 of 298 matches
Mail list logo
