Re: pg_upgrade + Ubuntu

From: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_upgrade + Ubuntu
Date: 2015-07-10 18:01:17
Message-ID: CANPAkgtDxn+c_JCzHEFZwWoMyqgJjtRpCww42Kpn++c3DmGAxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Does pg_config show the correct location? If so, perhaps pg_upgrade could
get the .conf location the same way rather than requiring a command line
option.

__________________________________________________________________________________
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike(dot)Blackwell(at)rrd(dot)com
http://www.rrdonnelley.com

<http://www.rrdonnelley.com/>
* <Mike(dot)Blackwell(at)rrd(dot)com>*

On Fri, Jul 10, 2015 at 12:40 PM, Joshua D. Drake <jd(at)commandprompt(dot)com>
wrote:

>
> Hackers,
>
> Simple problem (I think):
>
> 9.4 version of pg_upgrade said:
>
> "/usr/lib/postgresql/9.4/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D
> "/var/lib/postgresql/9.4/main" -o "-p 9400 -b -c synchronous_commit=off -c
> fsync=off -c full_page_writes=off -c listen_addresses='' -c
> unix_socket_permissions=0700 -c
> unix_socket_directories='/var/lib/postgresql'" start
>
> postgres cannot access the server configuration file
> "/var/lib/postgresql/9.4/main/postgresql.conf": No such file or directory
>
> The issue is Debian/Ubuntu etc... don't have a postgresql.conf in the
> cluster. They keep it separately in /etc/postgresql.
>
> Could we get a flag that allows us to specifically point to where the conf
> filesare?
>
> JD
> --
> Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
> PostgreSQL Centered full stack support, consulting and development.
> Announcing "I'm offended" is basically telling the world you can't
> control your own emotions, so everyone else should do it for you.
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2015-07-10 18:29:43 PATCH: index-only scans with partial indexes
Previous Message Tom Lane 2015-07-10 17:59:40 Re: pg_upgrade + Extensions