Mixing
pgbouncer: FATAL cannot load config file
1
I'm trying to start pgbouncer on a Windows server but I'm getting the error:
FATAL cannot load config file
I downloaded the install from:
https://winpg.jp/~saito/pgbouncer/
I have registered the DLL.
My config file, as per the instructions is:
[databases]
template1 = host=127.0.0.1 port=5432 dbname=template1
[pgbouncer]
listen_port = 6543
listen_addr = 127.0.0.1
auth_type = md5
auth_file = users.txt
logfile = pgbouncer.log
pidfile = pgbouncer.pid
admin_users = postgres
And my users.txt is:
"postgres" "md52789c829ed005483db36bec2438f82674"
Is there any way to see what the problem is?
The error message is not very helpful :)
Thanks.
postgresql pgbouncer
asked Oct 3 '18 at 11:59
Daniel GeeDaniel Gee
296416
|
show 2 more comments
1
I'm trying to start pgbouncer on a Windows server but I'm getting the error:
FATAL cannot load config file
I downloaded the install from:
https://winpg.jp/~saito/pgbouncer/
I have registered the DLL.
My config file, as per the instructions is:
[databases]
template1 = host=127.0.0.1 port=5432 dbname=template1
[pgbouncer]
listen_port = 6543
listen_addr = 127.0.0.1
auth_type = md5
auth_file = users.txt
logfile = pgbouncer.log
pidfile = pgbouncer.pid
admin_users = postgres
And my users.txt is:
"postgres" "md52789c829ed005483db36bec2438f82674"
Is there any way to see what the problem is?
The error message is not very helpful :)
Thanks.
postgresql pgbouncer
asked Oct 3 '18 at 11:59
Daniel GeeDaniel Gee
296416
there can be some strange white char maybe
– Pavel Stehule
Oct 3 '18 at 12:41
@PavelStehule, I just checked. No extra chars.
– Daniel Gee
Oct 3 '18 at 13:12
maybe access rights? Windows are strange sometimes
– Pavel Stehule
Oct 3 '18 at 14:32
Are you using win32 or 64? may be the app is 64 and you have the 32 bit version or vice versa.
– Frank N Stein
Oct 4 '18 at 13:16
1
What I found was that the end of the pgbouncer.ini there is a line %include /var/opt/gitlab/consul/databases.ini and there was no such file present on my system and hence i was getting the problem. Remember mine is a linux system so the path names might change for you.
– singh
Feb 4 at 8:21
|
show 2 more comments
1
1
1
I'm trying to start pgbouncer on a Windows server but I'm getting the error:
FATAL cannot load config file
I downloaded the install from:
https://winpg.jp/~saito/pgbouncer/
I have registered the DLL.
My config file, as per the instructions is:
[databases]
template1 = host=127.0.0.1 port=5432 dbname=template1
[pgbouncer]
listen_port = 6543
listen_addr = 127.0.0.1
auth_type = md5
auth_file = users.txt
logfile = pgbouncer.log
pidfile = pgbouncer.pid
admin_users = postgres
And my users.txt is:
"postgres" "md52789c829ed005483db36bec2438f82674"
Is there any way to see what the problem is?
The error message is not very helpful :)
Thanks.
postgresql pgbouncer
asked Oct 3 '18 at 11:59
Daniel GeeDaniel Gee
296416
I'm trying to start pgbouncer on a Windows server but I'm getting the error:
FATAL cannot load config file
I downloaded the install from:
https://winpg.jp/~saito/pgbouncer/
I have registered the DLL.
My config file, as per the instructions is:
[databases]
template1 = host=127.0.0.1 port=5432 dbname=template1
[pgbouncer]
listen_port = 6543
listen_addr = 127.0.0.1
auth_type = md5
auth_file = users.txt
logfile = pgbouncer.log
pidfile = pgbouncer.pid
admin_users = postgres
And my users.txt is:
"postgres" "md52789c829ed005483db36bec2438f82674"
Is there any way to see what the problem is?
The error message is not very helpful :)
Thanks.
postgresql pgbouncer
postgresql pgbouncer
asked Oct 3 '18 at 11:59
Daniel GeeDaniel Gee
296416
asked Oct 3 '18 at 11:59
Daniel GeeDaniel Gee
296416
asked Oct 3 '18 at 11:59
Daniel GeeDaniel Gee
296416
asked Oct 3 '18 at 11:59
Daniel GeeDaniel Gee
296416
asked Oct 3 '18 at 11:59
Daniel GeeDaniel Gee
296416
296416
there can be some strange white char maybe
– Pavel Stehule
Oct 3 '18 at 12:41
@PavelStehule, I just checked. No extra chars.
– Daniel Gee
Oct 3 '18 at 13:12
maybe access rights? Windows are strange sometimes
– Pavel Stehule
Oct 3 '18 at 14:32
Are you using win32 or 64? may be the app is 64 and you have the 32 bit version or vice versa.
– Frank N Stein
Oct 4 '18 at 13:16
1
What I found was that the end of the pgbouncer.ini there is a line %include /var/opt/gitlab/consul/databases.ini and there was no such file present on my system and hence i was getting the problem. Remember mine is a linux system so the path names might change for you.
– singh
Feb 4 at 8:21
|
show 2 more comments
there can be some strange white char maybe
– Pavel Stehule
Oct 3 '18 at 12:41
@PavelStehule, I just checked. No extra chars.
– Daniel Gee
Oct 3 '18 at 13:12
maybe access rights? Windows are strange sometimes
– Pavel Stehule
Oct 3 '18 at 14:32
Are you using win32 or 64? may be the app is 64 and you have the 32 bit version or vice versa.
– Frank N Stein
Oct 4 '18 at 13:16
1
What I found was that the end of the pgbouncer.ini there is a line %include /var/opt/gitlab/consul/databases.ini and there was no such file present on my system and hence i was getting the problem. Remember mine is a linux system so the path names might change for you.
– singh
Feb 4 at 8:21
there can be some strange white char maybe
– Pavel Stehule
Oct 3 '18 at 12:41
there can be some strange white char maybe
– Pavel Stehule
Oct 3 '18 at 12:41
@PavelStehule, I just checked. No extra chars.
– Daniel Gee
Oct 3 '18 at 13:12
@PavelStehule, I just checked. No extra chars.
– Daniel Gee
Oct 3 '18 at 13:12
maybe access rights? Windows are strange sometimes
– Pavel Stehule
Oct 3 '18 at 14:32
maybe access rights? Windows are strange sometimes
– Pavel Stehule
Oct 3 '18 at 14:32
Are you using win32 or 64? may be the app is 64 and you have the 32 bit version or vice versa.
– Frank N Stein
Oct 4 '18 at 13:16
Are you using win32 or 64? may be the app is 64 and you have the 32 bit version or vice versa.
– Frank N Stein
Oct 4 '18 at 13:16
1
1
What I found was that the end of the pgbouncer.ini there is a line %include /var/opt/gitlab/consul/databases.ini and there was no such file present on my system and hence i was getting the problem. Remember mine is a linux system so the path names might change for you.
– singh
Feb 4 at 8:21
What I found was that the end of the pgbouncer.ini there is a line %include /var/opt/gitlab/consul/databases.ini and there was no such file present on my system and hence i was getting the problem. Remember mine is a linux system so the path names might change for you.
– singh
Feb 4 at 8:21
|
show 2 more comments
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
});
}
});
draft saved
draft discarded
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%2f52626578%2fpgbouncer-fatal-cannot-load-config-file%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
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.
draft saved
draft discarded
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%2f52626578%2fpgbouncer-fatal-cannot-load-config-file%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
there can be some strange white char maybe
– Pavel Stehule
Oct 3 '18 at 12:41
@PavelStehule, I just checked. No extra chars.
– Daniel Gee
Oct 3 '18 at 13:12
maybe access rights? Windows are strange sometimes
– Pavel Stehule
Oct 3 '18 at 14:32
Are you using win32 or 64? may be the app is 64 and you have the 32 bit version or vice versa.
– Frank N Stein
Oct 4 '18 at 13:16
1
What I found was that the end of the pgbouncer.ini there is a line %include /var/opt/gitlab/consul/databases.ini and there was no such file present on my system and hence i was getting the problem. Remember mine is a linux system so the path names might change for you.
– singh
Feb 4 at 8:21