pg.ddx.io pgsql-pkg-debian@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_upgradecluster fails if port is not specified in postgresql.conf
3+ messages / 2 participants
[nested] [flat]
* pg_upgradecluster fails if port is not specified in postgresql.conf
@ 2018-05-14 08:43 Yuriy Chernyshov <georgthegreat@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Yuriy Chernyshov @ 2018-05-14 08:43 UTC (permalink / raw)
To: pgsql-pkg-debian
It looks like postgres falls back to default port (5432) if port is not
specified in postgresql.conf.
The probles is actual in postgresql-common=191.pgdg14.04+1
Unfortunately, pg_upgradecluster does not handle this situation. It fails
with "Error: could not get cluster locales" and such message hardly helps
to debug the problem.
Could you, please, take a look?
Best regards,
Yuriy.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_upgradecluster fails if port is not specified in postgresql.conf
@ 2018-05-15 08:29 Christoph Berg <myon@debian.org>
parent: Yuriy Chernyshov <georgthegreat@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Christoph Berg @ 2018-05-15 08:29 UTC (permalink / raw)
To: Yuriy Chernyshov <georgthegreat@gmail.com>; +Cc: pgsql-pkg-debian
Re: Yuriy Chernyshov 2018-05-14 <CAPHLbgMZdoMkWe6wAMQn2By-9d95T6QKPDBGF5x6nTkAcK4ExA@mail.gmail.com>
> It looks like postgres falls back to default port (5432) if port is not
> specified in postgresql.conf.
> The probles is actual in postgresql-common=191.pgdg14.04+1
>
> Unfortunately, pg_upgradecluster does not handle this situation. It fails
> with "Error: could not get cluster locales" and such message hardly helps
> to debug the problem.
Hi,
where did you specify the port if not in postgresql.conf?
Christoph
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_upgradecluster fails if port is not specified in postgresql.conf
@ 2018-05-15 08:36 Yuriy Chernyshov <georgthegreat@gmail.com>
parent: Christoph Berg <myon@debian.org>
0 siblings, 0 replies; 3+ messages in thread
From: Yuriy Chernyshov @ 2018-05-15 08:36 UTC (permalink / raw)
To: myon@debian.org; pgsql-pkg-debian
Hi,
it looks like postgres defaults to port 5432 if nothing is specified in
config.
This was my configuration.
postgresql also supports conf.d folder which can contain additional
setting. It looks like pg_upgradecluster does not support this folder
either (yet it was not my case).
On Tue, 15 May 2018 at 11:29, Christoph Berg <myon@debian.org> wrote:
> Re: Yuriy Chernyshov 2018-05-14 <
> CAPHLbgMZdoMkWe6wAMQn2By-9d95T6QKPDBGF5x6nTkAcK4ExA@mail.gmail.com>
> > It looks like postgres falls back to default port (5432) if port is not
> > specified in postgresql.conf.
> > The probles is actual in postgresql-common=191.pgdg14.04+1
> >
> > Unfortunately, pg_upgradecluster does not handle this situation. It fails
> > with "Error: could not get cluster locales" and such message hardly helps
> > to debug the problem.
>
> Hi,
>
> where did you specify the port if not in postgresql.conf?
>
> Christoph
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2018-05-15 08:36 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-05-14 08:43 pg_upgradecluster fails if port is not specified in postgresql.conf Yuriy Chernyshov <georgthegreat@gmail.com>
2018-05-15 08:29 ` Christoph Berg <myon@debian.org>
2018-05-15 08:36 ` Yuriy Chernyshov <georgthegreat@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox