Welcome!
Important information
-- Spectre and Meltdown vulnerabilities
-- Change in MX sources

News
-- MX Linux on social media: here
-- Mepis support still here

Current releases
-- MX-17.1 Final release info here
-- antiX-17 release info here

New users
-- Please read this first, and don't forget to add system and hardware information to posts!
-- Here are the Forum Rules

Are PostgreSQL APT repos safe?

Post Reply
Message
Author
User avatar
jetimms
Forum Novice
Forum  Novice
Posts: 49
Joined: Mon Jul 05, 2010 10:28 am

Are PostgreSQL APT repos safe?

#1 Post by jetimms » Tue Jun 03, 2014 10:29 pm

Hello.

I'm in need PostgreSQL 9.2 or later (I think the latest is 9.3).

Is it in on of the MEPIS repos? I didn't see it in the CRs (either of them.)

If not, I'm looking at installing it manually or using the Postgre APT repository detail here: http://www.postgresql.org/download/linux/debian/.

The manual part, I'm comfortable with (in general), but the APT repo sounds easier, frankly. Is it safe to use with Mepis 12b2?

Thanks.

User avatar
timkb4cq
Forum Veteran
Forum Veteran
Posts: 4416
Joined: Wed Jul 12, 2006 4:05 pm

Re: Are PostgreSQL APT repos safe?

#2 Post by timkb4cq » Tue Jun 03, 2014 10:39 pm

The postgresql apt repositories are safer to use than building from source. Make sure to use the Wheezy (7.x) repository for MEPIS 12 beta or MX-14. The Squeeze (6.x) repo should be used for MEPIS 11.
MSI 970A-G43 MB, AMD FX-6300 (six core), 16GB RAM, GeForce 730, Samsung 850 EVO 250GB SSD, Seagate Barracuda XT 3TB

User avatar
jetimms
Forum Novice
Forum  Novice
Posts: 49
Joined: Mon Jul 05, 2010 10:28 am

Re: Are PostgreSQL APT repos safe?

#3 Post by jetimms » Tue Jun 03, 2014 11:02 pm

That's what I wanted to here! Thanks for the info, Tim.

User avatar
jetimms
Forum Novice
Forum  Novice
Posts: 49
Joined: Mon Jul 05, 2010 10:28 am

Re: Are PostgreSQL APT repos safe?

#4 Post by jetimms » Tue Jun 03, 2014 11:51 pm

Hmm. The 9.2 and 9.3 packages of postgresql from PostgreSQL APT repo are showing up as Broken.

Does Broken mean something on my end or the packagers?

update:
I ran the following to see it in the terminal (I was using Synaptic before):

Code: Select all

$ su -c 'apt-get install postgresql-9.3 pgadmin3'
Password: 
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 to resolve the situation:

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

$ su -c 'apt-get install postgresql-client-9.3'
Password: 
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 to resolve the situation:

The following packages have unmet dependencies:
 postgresql-client-9.3 : Depends: libpq5 (>= 9.3.4) but 9.1.12-0wheezy1 is to be installed
E: Unable to correct problems, you have held broken packages.
$ 

User avatar
lucky9
Forum Veteran
Forum Veteran
Posts: 11380
Joined: Wed Jul 12, 2006 5:54 am

Re: Are PostgreSQL APT repos safe?

#5 Post by lucky9 » Wed Jun 04, 2014 12:20 am

I'd suggest doing an apt-get -f install
to see if anything gets fixed.
Yes, even I am dishonest. Not in many ways, but in some. Forty-one, I think it is.
--Mark Twain

User avatar
timkb4cq
Forum Veteran
Forum Veteran
Posts: 4416
Joined: Wed Jul 12, 2006 4:05 pm

Re: Are PostgreSQL APT repos safe?

#6 Post by timkb4cq » Wed Jun 04, 2014 2:37 am

Try

Code: Select all

 su -c 'apt-get install -t wheezy-pgdg postgresql-9.3 pgadmin3' 
The problem is that the standard wheezy repos are pinned higher than the one you just added, so apt tries to pull any dependencies from them first. The -t <distribution> switch overrides that behavior.
MSI 970A-G43 MB, AMD FX-6300 (six core), 16GB RAM, GeForce 730, Samsung 850 EVO 250GB SSD, Seagate Barracuda XT 3TB

User avatar
jetimms
Forum Novice
Forum  Novice
Posts: 49
Joined: Mon Jul 05, 2010 10:28 am

Re: Are PostgreSQL APT repos safe?

#7 Post by jetimms » Wed Jun 04, 2014 6:53 am

lucky9 wrote:I'd suggest doing an apt-get -f install
to see if anything gets fixed.
I gave that a shot, but it looks to be okay:

Code: Select all

$ su -c 'apt-get -f install'
Password: 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 16 not upgraded.
$ 

User avatar
jetimms
Forum Novice
Forum  Novice
Posts: 49
Joined: Mon Jul 05, 2010 10:28 am

Re: Are PostgreSQL APT repos safe?

#8 Post by jetimms » Wed Jun 04, 2014 6:59 am

timkb4cq wrote:Try

Code: Select all

 su -c 'apt-get install -t wheezy-pgdg postgresql-9.3 pgadmin3' 
The problem is that the standard wheezy repos are pinned higher than the one you just added, so apt tries to pull any dependencies from them first. The -t <distribution> switch overrides that behavior.
Fantastic! It worked.

I was trying in vain to get Synaptic to do something similar. I really need to read up on apt-get, though, because I use Synaptic as a crutch just to see the descriptions and such.

Code: Select all

$ su -c 'apt-get install -t wheezy-pgdg postgresql-9.3 pgadmin3'
Password: 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libpq5 pgadmin3-data postgresql-client-9.3
Suggested packages:
  postgresql-contrib oidentd ident-server locales-all postgresql-doc-9.3
Recommended packages:
  pgagent postgresql-client
The following NEW packages will be installed:
  pgadmin3 pgadmin3-data postgresql-9.3 postgresql-client-9.3
The following packages will be upgraded:
  libpq5
1 upgraded, 4 newly installed, 0 to remove and 16 not upgraded.
Need to get 12.3 MB of archives.
After this operation, 39.6 MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Get:1 http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main libpq5 amd64 9.3.4-1.pgdg70+1 [125 kB]
Get:2 http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main pgadmin3-data all 1.18.1-3.pgdg70+1 [4,834 kB]
Get:3 http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main pgadmin3 amd64 1.18.1-3.pgdg70+1 [2,839 kB]
Get:4 http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main postgresql-client-9.3 amd64 9.3.4-1.pgdg70+1 [1,035 kB]
Get:5 http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main postgresql-9.3 amd64 9.3.4-1.pgdg70+1 [3,443 kB]
Fetched 12.3 MB in 1min 45s (117 kB/s)                                         
dpkg-preconfigure: unable to re-open stdin: No such file or directory
(Reading database ... 135589 files and directories currently installed.)
Preparing to replace libpq5 9.1.12-0wheezy1 (using .../libpq5_9.3.4-1.pgdg70+1_amd64.deb) ...
Unpacking replacement libpq5 ...
Selecting previously unselected package pgadmin3-data.
Unpacking pgadmin3-data (from .../pgadmin3-data_1.18.1-3.pgdg70+1_all.deb) ...
Selecting previously unselected package pgadmin3.
Unpacking pgadmin3 (from .../pgadmin3_1.18.1-3.pgdg70+1_amd64.deb) ...
Selecting previously unselected package postgresql-client-9.3.
Unpacking postgresql-client-9.3 (from .../postgresql-client-9.3_9.3.4-1.pgdg70+1_amd64.deb) ...
Selecting previously unselected package postgresql-9.3.
Unpacking postgresql-9.3 (from .../postgresql-9.3_9.3.4-1.pgdg70+1_amd64.deb) ...
Processing triggers for desktop-file-utils ...
Processing triggers for man-db ...
Processing triggers for menu ...
Processing triggers for postgresql-common ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
  en_us
Removing obsolete dictionary files:
Setting up libpq5 (9.3.4-1.pgdg70+1) ...
Setting up pgadmin3-data (1.18.1-3.pgdg70+1) ...
Setting up pgadmin3 (1.18.1-3.pgdg70+1) ...
Setting up postgresql-client-9.3 (9.3.4-1.pgdg70+1) ...
update-alternatives: using /usr/share/postgresql/9.3/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up postgresql-9.3 (9.3.4-1.pgdg70+1) ...
Creating new cluster 9.3/main ...
  config /etc/postgresql/9.3/main
  data   /var/lib/postgresql/9.3/main
  locale en_US.utf8
  port   5432
update-alternatives: using /usr/share/postgresql/9.3/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
[ ok ] Starting PostgreSQL 9.3 database server: main.
Processing triggers for menu ...
$ 

User avatar
lucky9
Forum Veteran
Forum Veteran
Posts: 11380
Joined: Wed Jul 12, 2006 5:54 am

Re: Are PostgreSQL APT repos safe?

#9 Post by lucky9 » Wed Jun 04, 2014 2:07 pm

A quick look at man apt-get (or aptitude) will help refresh my lousy memory.

(the apt-get -f install showed that you did not have any broken packages)
Yes, even I am dishonest. Not in many ways, but in some. Forty-one, I think it is.
--Mark Twain

Post Reply

Return to “Software / Configuration”