How to load init.sql file to postgres service in gitlab ci?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I want to init my service in the test stage using a sql file.
test:
services:
- postgres:latest
variables:
POSTGRES_DB: test
stage: test
image: gliderlabs/herokuish:latest
script:
- setup_test_db
- cp -R . /tmp/app
- /bin/herokuish buildpack test
only:
- branches
except:
variables:
- $TEST_DISABLED
This is the test job as in auto devops.
I want to use the postgres image docker-entrypoint.
This is how I use it in docker-compose on my pc:
volumes:
- './src/sql:/docker-entrypoint-initdb.d'
This way, when the postres image starts up, I have my schema ready to use.
How can I manage to do it in gitlab-ci.yml?
postgresql docker gitlab gitlab-ci
asked Nov 23 '18 at 15:13
itaieditaied
2,27082952
add a comment |
I want to init my service in the test stage using a sql file.
test:
services:
- postgres:latest
variables:
POSTGRES_DB: test
stage: test
image: gliderlabs/herokuish:latest
script:
- setup_test_db
- cp -R . /tmp/app
- /bin/herokuish buildpack test
only:
- branches
except:
variables:
- $TEST_DISABLED
This is the test job as in auto devops.
I want to use the postgres image docker-entrypoint.
This is how I use it in docker-compose on my pc:
volumes:
- './src/sql:/docker-entrypoint-initdb.d'
This way, when the postres image starts up, I have my schema ready to use.
How can I manage to do it in gitlab-ci.yml?
postgresql docker gitlab gitlab-ci
asked Nov 23 '18 at 15:13
itaieditaied
2,27082952
add a comment |
I want to init my service in the test stage using a sql file.
test:
services:
- postgres:latest
variables:
POSTGRES_DB: test
stage: test
image: gliderlabs/herokuish:latest
script:
- setup_test_db
- cp -R . /tmp/app
- /bin/herokuish buildpack test
only:
- branches
except:
variables:
- $TEST_DISABLED
This is the test job as in auto devops.
I want to use the postgres image docker-entrypoint.
This is how I use it in docker-compose on my pc:
volumes:
- './src/sql:/docker-entrypoint-initdb.d'
This way, when the postres image starts up, I have my schema ready to use.
How can I manage to do it in gitlab-ci.yml?
postgresql docker gitlab gitlab-ci
asked Nov 23 '18 at 15:13
itaieditaied
2,27082952
I want to init my service in the test stage using a sql file.
test:
services:
- postgres:latest
variables:
POSTGRES_DB: test
stage: test
image: gliderlabs/herokuish:latest
script:
- setup_test_db
- cp -R . /tmp/app
- /bin/herokuish buildpack test
only:
- branches
except:
variables:
- $TEST_DISABLED
This is the test job as in auto devops.
I want to use the postgres image docker-entrypoint.
This is how I use it in docker-compose on my pc:
volumes:
- './src/sql:/docker-entrypoint-initdb.d'
This way, when the postres image starts up, I have my schema ready to use.
How can I manage to do it in gitlab-ci.yml?
postgresql docker gitlab gitlab-ci
postgresql docker gitlab gitlab-ci
asked Nov 23 '18 at 15:13
itaieditaied
2,27082952
asked Nov 23 '18 at 15:13
itaieditaied
2,27082952
asked Nov 23 '18 at 15:13
itaieditaied
2,27082952
asked Nov 23 '18 at 15:13
itaieditaied
2,27082952
asked Nov 23 '18 at 15:13
itaieditaied
2,27082952
2,27082952
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%2f53449106%2fhow-to-load-init-sql-file-to-postgres-service-in-gitlab-ci%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
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%2f53449106%2fhow-to-load-init-sql-file-to-postgres-service-in-gitlab-ci%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
