From owner-freebsd-questions@freebsd.org Thu Dec 8 17:05:50 2016 Return-Path: Delivered-To: freebsd-questions@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 7D7D5C6DB91 for ; Thu, 8 Dec 2016 17:05:50 +0000 (UTC) (envelope-from amitabhkant@gmail.com) Received: from mail-oi0-x236.google.com (mail-oi0-x236.google.com [IPv6:2607:f8b0:4003:c06::236]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4341E11A4; Thu, 8 Dec 2016 17:05:50 +0000 (UTC) (envelope-from amitabhkant@gmail.com) Received: by mail-oi0-x236.google.com with SMTP id b126so458589958oia.2; Thu, 08 Dec 2016 09:05:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=7tEW4FkSpPMtGGVDbSQ/ygNZcinOAtiugBHTvqsSAw8=; b=FGdLEkjRItcQcg0WSXtvMcZ4kDQRBrSXMBIJJMqlxaoRWhWbsYqzD6qGnHguxxG6M7 zqo8QRYKtB7lt8M4a5h61/tyBXpp57DtZFopytlOMV/ugGiP+4O4w0Gk5FITyTKFVHLb nH8R4qZjCl8nNS1cBvW8Ucwr+goL0CEehYzZ53H/jheNVBiKEpRy+0rzG7V1qtNwMnFQ nvFhz7cWq2eh0y3p9Nlbf06BXYY81ZlJ2xfp/P+X9BTkiIbCzSXss3MEGe8hMg4YhRR8 Wy5LbJqWt8Du8mlM0nxy/xCHAqhUwLPnhd2BJTC/6ZadyGj6GQEKwKNrdkv7WZIXZLUA uDqw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=7tEW4FkSpPMtGGVDbSQ/ygNZcinOAtiugBHTvqsSAw8=; b=YGDgRx6Grin7T1GtMUSBYjJR9YGGKHj4Gbi+sD0l/VPjAbLho6evigyv3bM6kJW0Wg WI4fu89IM++6kx/FUcq5Dak7gaNuaRjrp2MxlWhEgGco6EDHmvlIUXUWi4HsNJUOFocy +cJMzFlvQz6ZSE3RKv/FwLfRTwzwCcnqfaxPinV8ZXx/bxLRdNshBjDXIj6IaiK7pN/t u/mAZO6LZwe1+k+qysxCwqFJQqLPpyyBYgFKCbjFfg2fKtr6H2aF3zlznwiasuRHXsDX qKaC/qVA7hmi8lpSbLO1ZGLLPDNqkn+3pJ33/k5HhdZfP7gpFr4GFX/ziJSuiXHRCgiG a9Dg== X-Gm-Message-State: AKaTC039UjV5qyJXj/b/MvUMb5YD+nWbSo6+kLVoYB9SVF2DiwGuHuHMSsOba2Erb9iqfnoxWNii9HpH1vcYdQ== X-Received: by 10.202.96.197 with SMTP id u188mr35123202oib.30.1481216749192; Thu, 08 Dec 2016 09:05:49 -0800 (PST) MIME-Version: 1.0 Received: by 10.182.110.35 with HTTP; Thu, 8 Dec 2016 09:05:28 -0800 (PST) In-Reply-To: <626b6aa7-d1db-2b73-4280-3c41aeb3c86a@FreeBSD.org> References: <9b0c2c966e0d071e3419fee21dd23d0f.squirrel@webmail.harte-lyne.ca> <626b6aa7-d1db-2b73-4280-3c41aeb3c86a@FreeBSD.org> From: Amitabh Kant Date: Thu, 8 Dec 2016 22:35:28 +0530 Message-ID: Subject: Re: Pkg artefacts To: Matthew Seaman Cc: "freebsd-questions@freebsd.org" Content-Type: text/plain; charset=UTF-8 X-Content-Filtered-By: Mailman/MimeDel 2.1.23 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 08 Dec 2016 17:05:50 -0000 Mathew Does this mean that installing through ports/packages will now support multiple versions of postgresql (post 9.6) with different data directories? If yes, this removes a lot of pain for using pg_upgrade. Amitabh On Tue, Dec 6, 2016 at 11:00 PM, Matthew Seaman wrote: > On 2016/12/06 17:20, James B. Byrne via freebsd-questions wrote: > > We find this on a FreeBSD-11p0 system: > > > > ll /usr/local/pgsql > > total 17 > > drwx------ 19 pgsql pgsql 25 Nov 24 12:52 data > > > > > > ll /var/lib/pgsql > > total 17 > > drwx------ 19 postgres postgres 27 Dec 1 12:44 9.6 > > > > Checking the contents of both directories reveals a remarkable > > congruence. So, why do two virtually identical directory trees, > > albeit with different owners, exist on this system? > > > > You previously had a version of postgresql earler than 9.6 installed. > These older versions use the userid 'pgsql' and the default location for > the data store is /usr/local/pgsql/data > > With postgresql 9.6 that changed. The userid is now 'postgres' and the > datastore location should be /var/db/postgres/data96 > > See the 20160905 entry in UPDATING > > If you've got a postgresql data area as /var/lib/pgsql/9.6, you must > have configured that locally. (Looks like a too-strict copy of the > usual Linux layout, perhaps.) This is most likely to contain a more > recent copy of your databases. > > Check /etc/rc.conf -- most of these settings can be overridden in the > database startup > > Cheers, > > Matthew > > > >