[gentoo-user] How do you upgrade postgresql?

[Mick]

Hi All,

How would you suggest I upgrade dev-db/postgresql-9.4.5-r2 to 9.5.1?

I read here that dump and restore is probably a cleaner way to upgrade gentoo 
based installations, rather than using the pg_dump and pg_restore commands:

http://michael.orlitzky.com/articles/upgrading_postgresql-9.x_on_gentoo.php

-- 
Regards,
Mick

signature.asc
Description: This is a digitally signed message part.

[gentoo-user] Re: How do you upgrade postgresql?

[Mick]

On Saturday 13 Feb 2016 14:04:05 Mick wrote:
> Hi All,
> 
> How would you suggest I upgrade dev-db/postgresql-9.4.5-r2 to 9.5.1?
> 
> I read here that dump and restore is probably a cleaner way to upgrade
> gentoo based installations, rather than using the pg_dump and pg_restore
> commands:

Oops! I meant rather than the pg_upgrade command!


> http://michael.orlitzky.com/articles/upgrading_postgresql-9.x_on_gentoo.php

-- 
Regards,
Mick

signature.asc
Description: This is a digitally signed message part.

[gentoo-user] On a KDE Plasma machine should vlc be pulling in Qt4?

[Andrew Lowe]

Hi all,
Just wondering if the latest vlc, 2.2.2 should be pulling in KDE4/Qt4
components when the machine is supposedly running Plasma/Qt5? A sync and
then a -NuD world shows vlc wanting to pull in kdelibs-4.14.16,
qtsql-4.8.7-r1 & qtcore-4.8.7-r1.

Any thoughts?

Regards,
Andrew

Re: [gentoo-user] How do you upgrade postgresql?

[Michael Orlitzky]

On 02/13/2016 09:04 AM, Mick wrote:
> Hi All,
> 
> How would you suggest I upgrade dev-db/postgresql-9.4.5-r2 to 9.5.1?
> 
> I read here that dump and restore is probably a cleaner way to upgrade gentoo 
> based installations, rather than using the pg_dump and pg_restore commands:
> 
> http://michael.orlitzky.com/articles/upgrading_postgresql-9.x_on_gentoo.php
> 

Haha, yes, I remember that. I stand by the note at the top.

You can install 9.5 side-by-side with 9.4. That gives you time to look
over the configuration for 9.5 while 9.4 is still running. Then when
you're ready, run pg_dump/pg_dumpall to back everything up. Stop 9.4,
eselect 9.5, start 9.5, and then run pg_restore or psql < backup.sql to
load all of the data. It's fast, conceptually simple, and minimizes the
downtime.

When you're sure it works, don't forget to remove 9.4 from the default
runlevel and add 9.5 so that you're not surprised on a reboot.

Re: [gentoo-user] How do you upgrade postgresql?

[J. Roeleveld]

On 13 February 2016 15:40:33 CET, Michael Orlitzky  wrote:
>On 02/13/2016 09:04 AM, Mick wrote:
>> Hi All,
>> 
>> How would you suggest I upgrade dev-db/postgresql-9.4.5-r2 to 9.5.1?
>> 
>> I read here that dump and restore is probably a cleaner way to
>upgrade gentoo 
>> based installations, rather than using the pg_dump and pg_restore
>commands:
>> 
>>
>http://michael.orlitzky.com/articles/upgrading_postgresql-9.x_on_gentoo.php
>> 
>
>Haha, yes, I remember that. I stand by the note at the top.
>
>You can install 9.5 side-by-side with 9.4. That gives you time to look
>over the configuration for 9.5 while 9.4 is still running. Then when
>you're ready, run pg_dump/pg_dumpall to back everything up. Stop 9.4,
>eselect 9.5, start 9.5, and then run pg_restore or psql < backup.sql to
>load all of the data. It's fast, conceptually simple, and minimizes the
>downtime.
>
>When you're sure it works, don't forget to remove 9.4 from the default
>runlevel and add 9.5 so that you're not surprised on a reboot.

Or run both simultaneously on different ports and migrate one 
database/application at a time.

That will also allow you to dump/restore directly without requiring additional 
diskspace.

--
Joost 
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: [gentoo-user] How do you upgrade postgresql?

[Mick]

On Saturday 13 Feb 2016 17:12:27 J. Roeleveld wrote:
> On 13 February 2016 15:40:33 CET, Michael Orlitzky  wrote:
> >On 02/13/2016 09:04 AM, Mick wrote:
> >> Hi All,
> >> 
> >> How would you suggest I upgrade dev-db/postgresql-9.4.5-r2 to 9.5.1?
> >> 
> >> I read here that dump and restore is probably a cleaner way to
> >
> >upgrade gentoo
> >
> >> based installations, rather than using the pg_dump and pg_restore
> >
> >commands:
> >
> >
> >http://michael.orlitzky.com/articles/upgrading_postgresql-9.x_on_gentoo.php
> >
> >
> >Haha, yes, I remember that. I stand by the note at the top.
> >
> >You can install 9.5 side-by-side with 9.4. That gives you time to look
> >over the configuration for 9.5 while 9.4 is still running. Then when
> >you're ready, run pg_dump/pg_dumpall to back everything up. Stop 9.4,
> >eselect 9.5, start 9.5, and then run pg_restore or psql < backup.sql to
> >load all of the data. It's fast, conceptually simple, and minimizes the
> >downtime.
> >
> >When you're sure it works, don't forget to remove 9.4 from the default
> >runlevel and add 9.5 so that you're not surprised on a reboot.
> 
> Or run both simultaneously on different ports and migrate one
> database/application at a time.
> 
> That will also allow you to dump/restore directly without requiring
> additional diskspace.
> 
> --
> Joost

Thank you both, I used pg_dumpall, but when I tried to restore it with

psql -f postgress_20160213 postgres

it complained that user 'michael' doesn't exist.  Then tried logged in as 
root, whereby it complained that user 'root' doesn't exist.  Then I 'su - 
postgres' and it restored the database.  Is this how I am supposed to restore 
from a backup?

I only run postgres for KDEPIM's akonadi, which seems to work fine post-
upgrade.  :-)

-- 
Regards,
Mick

signature.asc
Description: This is a digitally signed message part.

Re: [gentoo-user] How do you upgrade postgresql?

[Michael Orlitzky]

On 02/13/2016 12:16 PM, Mick wrote:
> 
> Thank you both, I used pg_dumpall, but when I tried to restore it with
> 
> psql -f postgress_20160213 postgres
> 
> it complained that user 'michael' doesn't exist.  Then tried logged in as 
> root, whereby it complained that user 'root' doesn't exist.  Then I 'su - 
> postgres' and it restored the database.  Is this how I am supposed to restore 
> from a backup?
> 
> I only run postgres for KDEPIM's akonadi, which seems to work fine post-
> upgrade.  :-)
> 

That works sort of by accident. If you don't specify a username on the
command-line, psql will try to log you in to postgresql using your
system username -- "michael", for you. When you ran psql as root, it
tried to log you into postgresql as the "root" postgresql user, and he
doesn't exist.

The default admin user built-in to postgresql is called "postgres", so
if you just happen to run psql as the system "postgres" user, it will
try to log you in as "postgres" and it will work.

If you run "psql -U postgres" it should achieve the same thing. And if
you don't want to have to remember that, you can create a ~/.pgpass file
that says to always use the "postgres" database user:

  http://www.postgresql.org/docs/current/static/libpq-pgpass.html

Re: [gentoo-user] How do you upgrade postgresql?

[Mick]

On Saturday 13 Feb 2016 12:27:54 Michael Orlitzky wrote:
> On 02/13/2016 12:16 PM, Mick wrote:
> > Thank you both, I used pg_dumpall, but when I tried to restore it with
> > 
> > psql -f postgress_20160213 postgres
> > 
> > it complained that user 'michael' doesn't exist.  Then tried logged in as
> > root, whereby it complained that user 'root' doesn't exist.  Then I 'su -
> > postgres' and it restored the database.  Is this how I am supposed to
> > restore from a backup?
> > 
> > I only run postgres for KDEPIM's akonadi, which seems to work fine post-
> > upgrade.  :-)
> 
> That works sort of by accident. If you don't specify a username on the
> command-line, psql will try to log you in to postgresql using your
> system username -- "michael", for you. When you ran psql as root, it
> tried to log you into postgresql as the "root" postgresql user, and he
> doesn't exist.
> 
> The default admin user built-in to postgresql is called "postgres", so
> if you just happen to run psql as the system "postgres" user, it will
> try to log you in as "postgres" and it will work.
> 
> If you run "psql -U postgres" it should achieve the same thing. And if
> you don't want to have to remember that, you can create a ~/.pgpass file
> that says to always use the "postgres" database user:
> 
>   http://www.postgresql.org/docs/current/static/libpq-pgpass.html

Thank you Michael.  It was pretty painless TBH, almost as easy as upgrading 
mysql.  ;-)  Your page also nicely details the alternative, which I did not 
try out.
-- 
Regards,
Mick

signature.asc
Description: This is a digitally signed message part.

Re: [gentoo-user] TOR-Browser Bundle: And the rest was silence...

[Pavel Volkov]

On вторник, 9 февраля 2016 г. 10:38:08 MSK, Andrew Savchenko wrote:

While such background traffic can be redirected to tor using tsocks
and iptables, this is not very trivial task. That is why tor browser
is useful: it does such stuff for you by ensuring that all browser
traffic is going via tor. You may use torbrowser overlay to use
this package in Gentoo.


I'd put the browser into a separate network namespace just to be sure they 
don't access the regular eth0. I've done it with both Chromium and Firefox 
in the past.


Still, Tor is mostly about anonimity and a user can't anonymize their 
browser fingerprints to sufficient level with such setup.
A website owner can also disclose your location through JavaScript 
(namespacing should prevent this, though).
I also vote for using Tor browser and do a research on their web resources 
why video stopped working (it definetely was OK in the past).

Re: [gentoo-user] How do you upgrade postgresql?

[Michael Orlitzky]

On 02/13/2016 12:43 PM, Mick wrote:
> 
> Thank you Michael.  It was pretty painless TBH, almost as easy as upgrading 
> mysql.  ;-)  Your page also nicely details the alternative, which I did not 
> try out.
> 

I wrote that when postgresql-9.0 was released and was the first version
that had pg_upgrade. It sounds great at first... I guess it feels
dangerous to dump/restore your entire database cluster to a text file
(even though I've never had a problem doing it).

But, I kept running into problems, even following my own instructions
step-by-step. For example, pg_upgrade will refuse to upgrade clusters
with different encodings. A dump/restore works just fine there. Plus, it
became annoying to have to follow a list every time I needed to do an
upgrade (I have more than one postgres server). The pg_upgrade route is
extremely sensitive to the order in which you do things. Meanwhile, the
dump/restore route I know off the top of my head:

  1. make sure the new version works
  2. dump everything
  3. switch to the new version
  4. load the dump

There are details at each step, but the order can be fudged and it's
easy to fix if you forget something. As long as there are no known
problems with the dump/restore method, I don't see any reason to bother
with the "new" way.

Re: [gentoo-user] On a KDE Plasma machine should vlc be pulling in Qt4?

[Alan McKinnon]

On 13/02/2016 16:36, Andrew Lowe wrote:
> Hi all,
>   Just wondering if the latest vlc, 2.2.2 should be pulling in KDE4/Qt4
> components when the machine is supposedly running Plasma/Qt5? A sync and
> then a -NuD world shows vlc wanting to pull in kdelibs-4.14.16,
> qtsql-4.8.7-r1 & qtcore-4.8.7-r1.
> 
>   Any thoughts?
> 
>   Regards,
>   Andrew
> 


It's not that vlc must use whatever KDE "the machine uses" (a 100%
completely undefined concept), it's what vlc has been coded against.

And it seems to be largely KDE4 based at this point. If you read through
the ebuild you'll see that USE=kde pulls in kdelibs-4.14.16 as you noted
above (which wants many things with USE=qt4)

However vlc also supports building against qt4 or 5. It looks like you
can have Qt5 support as long as vlc does not build against KDE - that
gives Qt4 only. I'm not sure what you'll get with USE="-kde" for vlc, I
suspect tight integration like vlc being the default video player will
go away.

I suggest running emerge -p vlc with various combinations disabling and
enabling qt4, qt5 and kde till you find one that suits you.


-- 
Alan McKinnon
alan.mckin...@gmail.com