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.

[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

Re: [GENERAL] sync structures

2009-09-28 Thread Filip Rembiałkowski
2009/9/28 John jfabi...@yolo.com 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

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 jfabi...@yolo.com 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

Re: [GENERAL] sync structures

2009-09-28 Thread Adrian Klaver
- John jfabi...@yolo.com wrote: On Monday 28 September 2009 09:06:25 am Filip Rembiałkowski wrote: 2009/9/28 John jfabi...@yolo.com 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

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 jfabi...@yolo.com 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

Re: [GENERAL] sync structures

2009-09-28 Thread Filip Rembiałkowski
2009/9/28 John jfabi...@yolo.com 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

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.

Re: [GENERAL] sync structures

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

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 jfabi...@yolo.com 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

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.