Postgresql 11.1: “Problem running post-install step. Installation may not complete correctly. Error with configuration or permissions.”









up vote
0
down vote

favorite












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.










share|improve this question





















  • 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














up vote
0
down vote

favorite












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.










share|improve this question





















  • 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












up vote
0
down vote

favorite









up vote
0
down vote

favorite











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.










share|improve this question













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






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 11 at 20:57









Daly John

1




1











  • 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
















  • 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















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

















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',
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
);



);













draft saved

draft discarded


















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















draft saved

draft discarded
















































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.




draft saved


draft discarded














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





















































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







這個網誌中的熱門文章

How to read a connectionString WITH PROVIDER in .NET Core?

In R, how to develop a multiplot heatmap.2 figure showing key labels successfully

Museum of Modern and Contemporary Art of Trento and Rovereto