Re: [GENERAL] sync structures

2009-09-29 Thread Peter Eisentraut
On Mon, 2009-09-28 at 10:08 -0700, John wrote: > On Monday 28 September 2009 09:56:33 am Filip Rembiałkowski wrote: > > BTW, you did not specify what exactly did not work when you tried apgdiff. > > this would help others to help you. > > To be honest I could not determine how to start the app.

Re: [GENERAL] sync structures

2009-09-28 Thread John R Pierce
John wrote: Hi, I have a development DB and a production DB. I need a way to sync the changes I make to the stucture in the devel DB to the production DB. I found pgdiff but can't get it to work. I would like a solution that would work on windows and linux. But I'll take either alone.

Re: [GENERAL] sync structures

2009-09-28 Thread John
On Monday 28 September 2009 09:56:33 am Filip Rembiałkowski wrote: > 2009/9/28 John > > > After all this time I'm surprized that someone hasn't > > provide an easy way to get this done. It's has to be every developers > > problem. > > hmm, maybe because there's no easy way? db schemas can be co

Re: [GENERAL] sync structures

2009-09-28 Thread John
On Monday 28 September 2009 09:31:30 am Adrian Klaver wrote: > - "John" wrote: > > On Monday 28 September 2009 09:06:25 am Filip Rembiałkowski wrote: > > > 2009/9/28 John > > > > > > > Hi, > > > > I have a development DB and a production DB. I need a way to sync > > > > the > > > > > > chang

Re: [GENERAL] sync structures

2009-09-28 Thread Thomas Kellerer
John wrote on 28.09.2009 18:24: Thanks that will help. After all this time I'm surprized that someone hasn't provide an easy way to get this done. It's has to be every developers problem. Have a look at my SQL Workbench. It has a built-in command to generate a diff between two databases. T

Re: [GENERAL] sync structures

2009-09-28 Thread Filip Rembiałkowski
2009/9/28 John > After all this time I'm surprized that someone hasn't > provide an easy way to get this done. It's has to be every developers > problem. > > hmm, maybe because there's no easy way? db schemas can be complicated... there are some commercial tools for db comparing but they are n

Re: [GENERAL] sync structures

2009-09-28 Thread Steve Atkins
On Sep 28, 2009, at 9:24 AM, John wrote: On Monday 28 September 2009 09:06:25 am Filip Rembiałkowski wrote: 2009/9/28 John Hi, I have a development DB and a production DB. I need a way to sync the changes I make to the stucture in the devel DB to the production DB. I found pgdiff bu

Re: [GENERAL] sync structures

2009-09-28 Thread Adrian Klaver
- "John" wrote: > On Monday 28 September 2009 09:06:25 am Filip Rembiałkowski wrote: > > 2009/9/28 John > > > > > Hi, > > > I have a development DB and a production DB. I need a way to sync > the > > > changes > > > I make to the stucture in the devel DB to the production DB. I > found >

Re: [GENERAL] sync structures

2009-09-28 Thread John
On Monday 28 September 2009 09:06:25 am Filip Rembiałkowski wrote: > 2009/9/28 John > > > Hi, > > I have a development DB and a production DB. I need a way to sync the > > changes > > I make to the stucture in the devel DB to the production DB. I found > > pgdiff > > but can't get it to work. I

Re: [GENERAL] sync structures

2009-09-28 Thread Filip Rembiałkowski
2009/9/28 John > Hi, > I have a development DB and a production DB. I need a way to sync the > changes > I make to the stucture in the devel DB to the production DB. I found > pgdiff > but can't get it to work. I would like a solution that would work on > windows > and linux. But I'll take e

[GENERAL] sync structures

2009-09-28 Thread John
Hi, I have a development DB and a production DB. I need a way to sync the changes I make to the stucture in the devel DB to the production DB. I found pgdiff but can't get it to work. I would like a solution that would work on windows and linux. But I'll take either alone. postgres 8.3 o