Thread: BUG #13586: Repository/Distribution issues

BUG #13586: Repository/Distribution issues

From
dmt.shvedov@gmail.com
Date:
The following bug has been logged on the website:

Bug reference:      13586
Logged by:          Dmitry Shvedov
Email address:      dmt.shvedov@gmail.com
PostgreSQL version: 9.4.4
Operating system:   Linux Mint
Description:

Hi,
Installing from the Repository provided here and following all instructions
as for Ubuntu 14.04 (that my Mint 17.02 is based on):
http://www.postgresql.org/download/linux/ubuntu/

After installing all packages, cannot launch postgres:

$ postgres -D /usr/local/pgsql/data
The program 'postgres' is currently not installed. You can install it by
typing:
sudo apt-get install postgres-xc

$ sudo apt-get install postgres-xc
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help resolve the situation:

The following packages have unmet dependencies:
 postgres-xc : Depends: postgres-xc-client but it is not going to be
installed
E: Unable to correct problems, you have held broken packages.

$ sudo apt-get install postgres-xc-9.4
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package postgres-xc-9.4
E: Couldn't find any package by regex 'postgres-xc-9.4'



I assume I need postgres-xc, but that package is not in your repo, I only
have the one from Ubuntu - for older version of Postgres.

Am I doing something wrong here?
Thanks.

Re: BUG #13586: Repository/Distribution issues

From
Michael Paquier
Date:
On Wed, Aug 26, 2015 at 1:06 AM,  <dmt.shvedov@gmail.com> wrote:
> Operating system:   Linux Mint
> After installing all packages, cannot launch postgres:
>
> $ postgres -D /usr/local/pgsql/data
> The program 'postgres' is currently not installed. You can install it by
> typing:
> sudo apt-get install postgres-xc
> [...]
> I assume I need postgres-xc, but that package is not in your repo, I only
> have the one from Ubuntu - for older version of Postgres.

No, Postgres-XC is a fork of Postgres. You don't need XC when
attempting to use only Postgres.

> Am I doing something wrong here?

So, you are trying to use Postgres and not Postgres-XC here, right?
Postgres-XC uses the same binary names as Postgres, so perhaps you
have in your PATH some left garbage of an ancient Postgres-XC
installation? In any case, this is not a PostgreSQL bug, this is
either an issue with the packaging of the distribution you are using
or your environment.
--
Michael

Re: BUG #13586: Repository/Distribution issues

From
Dmitry Shvedov
Date:
Michael, thanks for your response.
You're right about the PATH. However, it's a fresh linux install and
postgres has not been installed here before. What happened was that the
installation from this repo:
deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main
did not add the executable to the PATH automatically as any installation on
Debian derivatives always does. Perhaps there's a valid reason for this,
but it's not a behavior that I expected. If it makes sense maybe the
installation packages should be modified to do that? Thanks.

On Tue, Aug 25, 2015 at 8:39 PM, Michael Paquier <michael.paquier@gmail.com>
wrote:

> On Wed, Aug 26, 2015 at 1:06 AM,  <dmt.shvedov@gmail.com> wrote:
> > Operating system:   Linux Mint
> > After installing all packages, cannot launch postgres:
> >
> > $ postgres -D /usr/local/pgsql/data
> > The program 'postgres' is currently not installed. You can install it by
> > typing:
> > sudo apt-get install postgres-xc
> > [...]
> > I assume I need postgres-xc, but that package is not in your repo, I only
> > have the one from Ubuntu - for older version of Postgres.
>
> No, Postgres-XC is a fork of Postgres. You don't need XC when
> attempting to use only Postgres.
>
> > Am I doing something wrong here?
>
> So, you are trying to use Postgres and not Postgres-XC here, right?
> Postgres-XC uses the same binary names as Postgres, so perhaps you
> have in your PATH some left garbage of an ancient Postgres-XC
> installation? In any case, this is not a PostgreSQL bug, this is
> either an issue with the packaging of the distribution you are using
> or your environment.
> --
> Michael
>

Re: BUG #13586: Repository/Distribution issues

From
"David G. Johnston"
Date:
On Tue, Aug 25, 2015 at 11:48 PM, Dmitry Shvedov <dmt.shvedov@gmail.com>
wrote:

> Michael, thanks for your response.
> You're right about the PATH. However, it's a fresh linux install and
> postgres has not been installed here before. What happened was that the
> installation from this repo:
> deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main
> did not add the executable to the PATH automatically as any installation
> on Debian derivatives always does. Perhaps there's a valid reason for thi=
s,
> but it's not a behavior that I expected. If it makes sense maybe the
> installation packages should be modified to do that? Thanks.
>
> On Tue, Aug 25, 2015 at 8:39 PM, Michael Paquier <
> michael.paquier@gmail.com> wrote:
>
>> On Wed, Aug 26, 2015 at 1:06 AM,  <dmt.shvedov@gmail.com> wrote:
>> > Operating system:   Linux Mint
>> > After installing all packages, cannot launch postgres:
>> >
>> > $ postgres -D /usr/local/pgsql/data
>> > The program 'postgres' is currently not installed. You can install it =
by
>> > typing:
>> > sudo apt-get install postgres-xc
>> > [...]
>> > I assume I need postgres-xc, but that package is not in your repo, I
>> only
>> > have the one from Ubuntu - for older version of Postgres.
>>
>
=E2=80=8BI am reasonably certain that the reason "postgres" is not on the p=
ath is
because the package supplies various "cluster-managing" versions (wrappers)
of (over) the executables that are intended to be run instead.  If you
choose to forgo those wrappers and do things directly you are expected to
be able to manage the necessary changes to make that work.

David J.
=E2=80=8B