pg.ddx.io  pgsql-pkg-debian@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_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