Re: transferring data between Postgres databases

2016-10-24 Thread Mike Dewhirst
On 25/10/2016 7:09 AM, Erik Cederstrand wrote: Den 24. okt. 2016 kl. 06.04 skrev Mike Dewhirst: I have a user who has done a lot of work (instead of playing) in the staging server and now wants to get that work into the production database. I'm about to research

Re: transferring data between Postgres databases

2016-10-24 Thread Erik Cederstrand
> Den 24. okt. 2016 kl. 06.04 skrev Mike Dewhirst : > > I have a user who has done a lot of work (instead of playing) in the staging > server and now wants to get that work into the production database. > > I'm about to research selective dump and load capabilities of

Re: transferring data between Postgres databases

2016-10-24 Thread Vineet Kothari
You will have to dump the back up file for that you can either use GUI based tool as other friends has suggested or you can use command line .There may be more ways please read two scoops of Django book On Oct 24, 2016 9:39 AM, "'Aaron C. de Bruyn' via Django users" <

Re: transferring data between Postgres databases

2016-10-23 Thread Mike Dewhirst
On 24/10/2016 3:08 PM, 'Aaron C. de Bruyn' via Django users wrote: If you're talking about migrating data using tools outside of django, I've used SQLWorkbench[0] in the past. I currently use it to selectively sync a handful of tables out of a ~900 table database *in* to my Django app. Aaron,

Re: transferring data between Postgres databases

2016-10-23 Thread 'Aaron C. de Bruyn' via Django users
If you're talking about migrating data using tools outside of django, I've used SQLWorkbench[0] in the past. I currently use it to selectively sync a handful of tables out of a ~900 table database *in* to my Django app. [0] - http://www.sql-workbench.net/ -A On Sun, Oct 23, 2016 at 9:04 PM,

transferring data between Postgres databases

2016-10-23 Thread Mike Dewhirst
I have a user who has done a lot of work (instead of playing) in the staging server and now wants to get that work into the production database. I'm about to research selective dump and load capabilities of Postgres but in the meantime can anyone suggest any shortcuts? Thanks Mike -- You