[gentoo-user] How do you upgrade postgresql?

2016-02-13 Thread 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:

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

2016-02-13 Thread 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: > >

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

2016-02-13 Thread 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

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

2016-02-13 Thread 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

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

2016-02-13 Thread 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.

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

2016-02-13 Thread 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

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

2016-02-13 Thread 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