Postgresql 11.1: “Problem running post-install step. Installation may not complete correctly. Error with...
I checked the log file and I think this is the part that caused the problem:
Setting up database
[15:30:54] Configuring pg11 to point to existing data dir D:John's FilesMy DocumentsCodeDatabasesPostgreSQLdatapg11
Setting PostgreSQL port
= 5432
Executing C:Installed SoftwareDeveloper SoftwarePostgreSQLv11.1/pgc config pg11 --datadir "D:John's FilesMy DocumentsCodeDatabasesPostgreSQLdatapg11"
Script exit code: 1
Script output: ################################################
# FATAL SQL Error in check_release
# SQL Message = near "s": syntax error
# SQL Statement = SELECT r.component FROM releases r, versions v
WHERE r.component = v.component
AND r.component LIKE '%D:John's FilesMy DocumentsCodeDatabasesPostgreSQLdatapg11%' AND v.is_current = 1
################################################
Script stderr: Program ended with an error exit code
Error with configuration or permissions. Please see log file for more information.
Problem running post-install step. Installation may not complete correctly
Error with configuration or permissions. Please see log file for more information.
I think the problem is the apostrophe in "John's". Does anyone know if that's right? Is there a fix to this problem? I don't want to rename my directory because Postgresql can't handle apostrophes.
postgresql
add a comment |
I checked the log file and I think this is the part that caused the problem:
Setting up database
[15:30:54] Configuring pg11 to point to existing data dir D:John's FilesMy DocumentsCodeDatabasesPostgreSQLdatapg11
Setting PostgreSQL port
= 5432
Executing C:Installed SoftwareDeveloper SoftwarePostgreSQLv11.1/pgc config pg11 --datadir "D:John's FilesMy DocumentsCodeDatabasesPostgreSQLdatapg11"
Script exit code: 1
Script output: ################################################
# FATAL SQL Error in check_release
# SQL Message = near "s": syntax error
# SQL Statement = SELECT r.component FROM releases r, versions v
WHERE r.component = v.component
AND r.component LIKE '%D:John's FilesMy DocumentsCodeDatabasesPostgreSQLdatapg11%' AND v.is_current = 1
################################################
Script stderr: Program ended with an error exit code
Error with configuration or permissions. Please see log file for more information.
Problem running post-install step. Installation may not complete correctly
Error with configuration or permissions. Please see log file for more information.
I think the problem is the apostrophe in "John's". Does anyone know if that's right? Is there a fix to this problem? I don't want to rename my directory because Postgresql can't handle apostrophes.
postgresql
Try to install it in a folder without any special char egJohn' <--- s
– Jorge Campos
Nov 11 at 21:00
And yes. You will probably have to rename your folder or find a workaround to escape that.
– Jorge Campos
Nov 11 at 21:01
Jorge, thanks for confirming that.
– Daly John
Nov 11 at 21:16
That's a bug in OpenSCG's bi aries. You should report it to them.
– Laurenz Albe
Nov 12 at 11:34
add a comment |
I checked the log file and I think this is the part that caused the problem:
Setting up database
[15:30:54] Configuring pg11 to point to existing data dir D:John's FilesMy DocumentsCodeDatabasesPostgreSQLdatapg11
Setting PostgreSQL port
= 5432
Executing C:Installed SoftwareDeveloper SoftwarePostgreSQLv11.1/pgc config pg11 --datadir "D:John's FilesMy DocumentsCodeDatabasesPostgreSQLdatapg11"
Script exit code: 1
Script output: ################################################
# FATAL SQL Error in check_release
# SQL Message = near "s": syntax error
# SQL Statement = SELECT r.component FROM releases r, versions v
WHERE r.component = v.component
AND r.component LIKE '%D:John's FilesMy DocumentsCodeDatabasesPostgreSQLdatapg11%' AND v.is_current = 1
################################################
Script stderr: Program ended with an error exit code
Error with configuration or permissions. Please see log file for more information.
Problem running post-install step. Installation may not complete correctly
Error with configuration or permissions. Please see log file for more information.
I think the problem is the apostrophe in "John's". Does anyone know if that's right? Is there a fix to this problem? I don't want to rename my directory because Postgresql can't handle apostrophes.
postgresql
I checked the log file and I think this is the part that caused the problem:
Setting up database
[15:30:54] Configuring pg11 to point to existing data dir D:John's FilesMy DocumentsCodeDatabasesPostgreSQLdatapg11
Setting PostgreSQL port
= 5432
Executing C:Installed SoftwareDeveloper SoftwarePostgreSQLv11.1/pgc config pg11 --datadir "D:John's FilesMy DocumentsCodeDatabasesPostgreSQLdatapg11"
Script exit code: 1
Script output: ################################################
# FATAL SQL Error in check_release
# SQL Message = near "s": syntax error
# SQL Statement = SELECT r.component FROM releases r, versions v
WHERE r.component = v.component
AND r.component LIKE '%D:John's FilesMy DocumentsCodeDatabasesPostgreSQLdatapg11%' AND v.is_current = 1
################################################
Script stderr: Program ended with an error exit code
Error with configuration or permissions. Please see log file for more information.
Problem running post-install step. Installation may not complete correctly
Error with configuration or permissions. Please see log file for more information.
I think the problem is the apostrophe in "John's". Does anyone know if that's right? Is there a fix to this problem? I don't want to rename my directory because Postgresql can't handle apostrophes.
postgresql
postgresql
asked Nov 11 at 20:57
Daly John
61
61
Try to install it in a folder without any special char egJohn' <--- s
– Jorge Campos
Nov 11 at 21:00
And yes. You will probably have to rename your folder or find a workaround to escape that.
– Jorge Campos
Nov 11 at 21:01
Jorge, thanks for confirming that.
– Daly John
Nov 11 at 21:16
That's a bug in OpenSCG's bi aries. You should report it to them.
– Laurenz Albe
Nov 12 at 11:34
add a comment |
Try to install it in a folder without any special char egJohn' <--- s
– Jorge Campos
Nov 11 at 21:00
And yes. You will probably have to rename your folder or find a workaround to escape that.
– Jorge Campos
Nov 11 at 21:01
Jorge, thanks for confirming that.
– Daly John
Nov 11 at 21:16
That's a bug in OpenSCG's bi aries. You should report it to them.
– Laurenz Albe
Nov 12 at 11:34
Try to install it in a folder without any special char eg
John' <--- s
– Jorge Campos
Nov 11 at 21:00
Try to install it in a folder without any special char eg
John' <--- s
– Jorge Campos
Nov 11 at 21:00
And yes. You will probably have to rename your folder or find a workaround to escape that.
– Jorge Campos
Nov 11 at 21:01
And yes. You will probably have to rename your folder or find a workaround to escape that.
– Jorge Campos
Nov 11 at 21:01
Jorge, thanks for confirming that.
– Daly John
Nov 11 at 21:16
Jorge, thanks for confirming that.
– Daly John
Nov 11 at 21:16
That's a bug in OpenSCG's bi aries. You should report it to them.
– Laurenz Albe
Nov 12 at 11:34
That's a bug in OpenSCG's bi aries. You should report it to them.
– Laurenz Albe
Nov 12 at 11:34
add a comment |
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%2f53253162%2fpostgresql-11-1-problem-running-post-install-step-installation-may-not-comple%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53253162%2fpostgresql-11-1-problem-running-post-install-step-installation-may-not-comple%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
Try to install it in a folder without any special char eg
John' <--- s
– Jorge Campos
Nov 11 at 21:00
And yes. You will probably have to rename your folder or find a workaround to escape that.
– Jorge Campos
Nov 11 at 21:01
Jorge, thanks for confirming that.
– Daly John
Nov 11 at 21:16
That's a bug in OpenSCG's bi aries. You should report it to them.
– Laurenz Albe
Nov 12 at 11:34