What's the best way to copy a dev PostGIS table to a prod environment?postgresql/postgis backup strategy to restore after geos/postgis recompile?Efficient way of insert millions of rows, convert data and deal with it, on PostgreSQL+PostGISQuery by coordinates takes too long - options to optimize?Extract individual lines from a gps track that runs in a loopCreating Postgres/PostGIS function to update table values based on spatial queryPostgres: How to group a very large table and insert the results into a new table?Best way to convert gis data from one postgis table to another for simplificationUpdate table data from view in PostgreSQL/PostGISWhat is the best way to multiply a column of 1500 items by itself?Migrate postgresql schema AWS RDS
Is there any way to keep a player from killing an NPC?
Algorithms vs LP or MIP
What happens when Polymorph is cast on a creature already affected by Polymorph?
Redacting URLs as an email-phishing preventative?
Ghidra: Prepend memory segment in assembly listing view
Why do banks “park” their money at the European Central Bank?
Why doesn't 'd /= d' throw a division by zero exception?
What is the right path to be followed on Chess.com for learning Chess?
How to gently end involvement with an online community?
Read file lines into shell line separated by space
If the Shillelagh cantrip is applied to a club with non-standard damage dice, what is the resulting damage dice?
If someone uses the Command spell and says "drop", what happens?
How many birds in the bush?
Prevent use of CNAME record for untrusted domain
Filling a listlineplot with a texture
Do Bayesian credible intervals treat the estimated parameter as a random variable?
Very slow boot time and poor perfomance
Are the players on the same team as the DM?
What is the coil voltage of this contactor?
Are there any elected officials in the U.S. who are not legislators, judges, or constitutional officers?
Discussing work with supervisor in an invited dinner with his family
What is the loud noise of a helicopter when the rotors are not yet moving?
Billiard balls collision
Can $! cause race conditions when used in scripts running in parallel?
What's the best way to copy a dev PostGIS table to a prod environment?
postgresql/postgis backup strategy to restore after geos/postgis recompile?Efficient way of insert millions of rows, convert data and deal with it, on PostgreSQL+PostGISQuery by coordinates takes too long - options to optimize?Extract individual lines from a gps track that runs in a loopCreating Postgres/PostGIS function to update table values based on spatial queryPostgres: How to group a very large table and insert the results into a new table?Best way to convert gis data from one postgis table to another for simplificationUpdate table data from view in PostgreSQL/PostGISWhat is the best way to multiply a column of 1500 items by itself?Migrate postgresql schema AWS RDS
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I'm using a PostGIS database hosted in AWS for the backend of a mobile application. Currently there is a dev and prod environment - both separate Ec2 instances - and I'm wondering what the best way to update dev and prod may be.
Update process
Every n days, most of the tables in dev are updated with some scripts. It takes ~ 10 hours for these tables to be updated completely. Since the prod server needs to be up 100% of the time for the mobile product, I can't directly update prod.
Migration
What I'm doing currently is updating the tables in dev, and then using QGIS to literally drag the tables from dev into prod (in the GUI), so the old prod tables are overwritten by the new dev tables.
Obviously this is a noob, temporary way to do it.
What is the best way to do this programmatically?
postgresql postgis qgis
asked Mar 27 at 18:55
beavertrapper07beavertrapper07
55 bronze badges
add a comment |
I'm using a PostGIS database hosted in AWS for the backend of a mobile application. Currently there is a dev and prod environment - both separate Ec2 instances - and I'm wondering what the best way to update dev and prod may be.
Update process
Every n days, most of the tables in dev are updated with some scripts. It takes ~ 10 hours for these tables to be updated completely. Since the prod server needs to be up 100% of the time for the mobile product, I can't directly update prod.
Migration
What I'm doing currently is updating the tables in dev, and then using QGIS to literally drag the tables from dev into prod (in the GUI), so the old prod tables are overwritten by the new dev tables.
Obviously this is a noob, temporary way to do it.
What is the best way to do this programmatically?
postgresql postgis qgis
asked Mar 27 at 18:55
beavertrapper07beavertrapper07
55 bronze badges
add a comment |
I'm using a PostGIS database hosted in AWS for the backend of a mobile application. Currently there is a dev and prod environment - both separate Ec2 instances - and I'm wondering what the best way to update dev and prod may be.
Update process
Every n days, most of the tables in dev are updated with some scripts. It takes ~ 10 hours for these tables to be updated completely. Since the prod server needs to be up 100% of the time for the mobile product, I can't directly update prod.
Migration
What I'm doing currently is updating the tables in dev, and then using QGIS to literally drag the tables from dev into prod (in the GUI), so the old prod tables are overwritten by the new dev tables.
Obviously this is a noob, temporary way to do it.
What is the best way to do this programmatically?
postgresql postgis qgis
asked Mar 27 at 18:55
beavertrapper07beavertrapper07
55 bronze badges
I'm using a PostGIS database hosted in AWS for the backend of a mobile application. Currently there is a dev and prod environment - both separate Ec2 instances - and I'm wondering what the best way to update dev and prod may be.
Update process
Every n days, most of the tables in dev are updated with some scripts. It takes ~ 10 hours for these tables to be updated completely. Since the prod server needs to be up 100% of the time for the mobile product, I can't directly update prod.
Migration
What I'm doing currently is updating the tables in dev, and then using QGIS to literally drag the tables from dev into prod (in the GUI), so the old prod tables are overwritten by the new dev tables.
Obviously this is a noob, temporary way to do it.
What is the best way to do this programmatically?
postgresql postgis qgis
postgresql postgis qgis
asked Mar 27 at 18:55
beavertrapper07beavertrapper07
55 bronze badges
asked Mar 27 at 18:55
beavertrapper07beavertrapper07
55 bronze badges
asked Mar 27 at 18:55
beavertrapper07beavertrapper07
55 bronze badges
asked Mar 27 at 18:55
beavertrapper07beavertrapper07
55 bronze badges
asked Mar 27 at 18:55
beavertrapper07beavertrapper07
55 bronze badges
55 bronze badges
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55384602%2fwhats-the-best-way-to-copy-a-dev-postgis-table-to-a-prod-environment%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55384602%2fwhats-the-best-way-to-copy-a-dev-postgis-table-to-a-prod-environment%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
