Re: pg_upgrade + Ubuntu - Mailing list pgsql-hackers

From Mike Blackwell
Subject Re: pg_upgrade + Ubuntu
Date
Msg-id CANPAkgtDxn+c_JCzHEFZwWoMyqgJjtRpCww42Kpn++c3DmGAxw@mail.gmail.com
Whole thread Raw
In response to pg_upgrade + Ubuntu  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: pg_upgrade + Ubuntu
List 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.Blackwell@rrd.com
http://www.rrdonnelley.com



On Fri, Jul 10, 2015 at 12:40 PM, Joshua D. Drake <jd@commandprompt.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_upgrade + Extensions
Next
From: Tomas Vondra
Date:
Subject: PATCH: index-only scans with partial indexes