Re: [GENERAL] Running pg_upgrade under Debian

2015-04-24 Thread Christoph Berg
Re: Peter Eisentraut 2015-04-24 <553a3b85.1070...@gmx.net> > On 4/20/15 6:09 PM, Bruce Momjian wrote: > > On Mon, Apr 20, 2015 at 07:06:37PM -0300, Alvaro Herrera wrote: > >> ISTM there's a documentation bug here: in the code, the "dump" method > >> checks for tablespaces and raises an error if the

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-24 Thread Peter Eisentraut
On 4/20/15 6:09 PM, Bruce Momjian wrote: > On Mon, Apr 20, 2015 at 07:06:37PM -0300, Alvaro Herrera wrote: >> ISTM there's a documentation bug here: in the code, the "dump" method >> checks for tablespaces and raises an error if they are found, but the >> "upgrade" method does not check. I think t

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-20 Thread rob stone
On Mon, 2015-04-20 at 18:05 -0400, Bruce Momjian wrote: > On Mon, Apr 20, 2015 at 03:02:48PM -0700, Adrian Klaver wrote: > > >But pg_upgrade supports tablespaces, and I assume pg_dump/pg_restore do > > >as well. > > > > > > > I don't think it is about the underlying programs, it is about > > te

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-20 Thread Adrian Klaver
On 04/20/2015 03:18 PM, Alvaro Herrera wrote: Bruce Momjian wrote: On Mon, Apr 20, 2015 at 07:06:37PM -0300, Alvaro Herrera wrote: ISTM there's a documentation bug here: in the code, the "dump" method checks for tablespaces and raises an error if they are found, but the "upgrade" method does no

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-20 Thread Alvaro Herrera
Bruce Momjian wrote: > On Mon, Apr 20, 2015 at 07:06:37PM -0300, Alvaro Herrera wrote: > > ISTM there's a documentation bug here: in the code, the "dump" method > > checks for tablespaces and raises an error if they are found, but the > > "upgrade" method does not check. I think the documentation

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-20 Thread Bruce Momjian
On Mon, Apr 20, 2015 at 07:06:37PM -0300, Alvaro Herrera wrote: > ISTM there's a documentation bug here: in the code, the "dump" method > checks for tablespaces and raises an error if they are found, but the > "upgrade" method does not check. I think the documentation should state > that only the

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-20 Thread Alvaro Herrera
ISTM there's a documentation bug here: in the code, the "dump" method checks for tablespaces and raises an error if they are found, but the "upgrade" method does not check. I think the documentation should state that only the dump method does not support tablespaces. Bruce Momjian wrote: > On Mo

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-20 Thread Bruce Momjian
On Mon, Apr 20, 2015 at 03:02:48PM -0700, Adrian Klaver wrote: > >But pg_upgrade supports tablespaces, and I assume pg_dump/pg_restore do > >as well. > > > > I don't think it is about the underlying programs, it is about > teaching the wrapper script what do with the choices. Sort of like > pgAdmi

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-20 Thread Adrian Klaver
On 04/20/2015 02:42 PM, Bruce Momjian wrote: On Mon, Apr 20, 2015 at 02:41:09PM -0700, Adrian Klaver wrote: On 04/20/2015 12:49 PM, Bruce Momjian wrote: On Sat, Apr 18, 2015 at 09:08:20AM +1000, rob stone wrote: For what it's worth: Debian provides a pg_upgradecluster tailored to its

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-20 Thread Bruce Momjian
On Mon, Apr 20, 2015 at 02:41:09PM -0700, Adrian Klaver wrote: > On 04/20/2015 12:49 PM, Bruce Momjian wrote: > >On Sat, Apr 18, 2015 at 09:08:20AM +1000, rob stone wrote: > >>>For what it's worth: Debian provides a > >>> > >>> pg_upgradecluster > >>> > >>>tailored to its specific setup of Postgr

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-20 Thread Adrian Klaver
On 04/20/2015 12:49 PM, Bruce Momjian wrote: On Sat, Apr 18, 2015 at 09:08:20AM +1000, rob stone wrote: For what it's worth: Debian provides a pg_upgradecluster tailored to its specific setup of PostgreSQL clusters. That has worked well for me across several major version bumps. Karst

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-20 Thread Bruce Momjian
On Sat, Apr 18, 2015 at 09:08:20AM +1000, rob stone wrote: > > For what it's worth: Debian provides a > > > > pg_upgradecluster > > > > tailored to its specific setup of PostgreSQL clusters. That > > has worked well for me across several major version bumps. > > > > Karsten > > > > Indeed

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-19 Thread Jeff Janes
On Sun, Apr 19, 2015 at 9:34 AM, rob stone wrote: > > > > On Fri, 2015-04-17 at 16:16 -0700, Adrian Klaver wrote: > > On 04/17/2015 03:09 PM, rob stone wrote: > > > Hello, > > > > > > I'm trying to upgrade from 9.3 to 9.4 on my laptop and encountering > this > > > error:- > > > > > > > > > postgr

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-19 Thread rob stone
On Fri, 2015-04-17 at 16:16 -0700, Adrian Klaver wrote: > On 04/17/2015 03:09 PM, rob stone wrote: > > Hello, > > > > I'm trying to upgrade from 9.3 to 9.4 on my laptop and encountering this > > error:- > > > > > > postgres@roblaptop:/usr/lib/postgresql/9.4/bin$ ./pg_upgrade > > -b /usr/lib/post

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-17 Thread Adrian Klaver
On 04/17/2015 03:09 PM, rob stone wrote: Hello, I'm trying to upgrade from 9.3 to 9.4 on my laptop and encountering this error:- postgres@roblaptop:/usr/lib/postgresql/9.4/bin$ ./pg_upgrade -b /usr/lib/postgresql/9.3/bin -B /usr/lib/postgresql/9.4/bin -d /home/postgres/data93/userqueries -D /h

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-17 Thread rob stone
On Sat, 2015-04-18 at 00:25 +0200, Karsten Hilbert wrote: > On Sat, Apr 18, 2015 at 08:09:43AM +1000, rob stone wrote: > > > I'm trying to upgrade from 9.3 to 9.4 on my laptop and encountering this > > error:- > > > > > > postgres@roblaptop:/usr/lib/postgresql/9.4/bin$ ./pg_upgrade > > -b /us

Re: [GENERAL] Running pg_upgrade under Debian

2015-04-17 Thread Karsten Hilbert
On Sat, Apr 18, 2015 at 08:09:43AM +1000, rob stone wrote: > I'm trying to upgrade from 9.3 to 9.4 on my laptop and encountering this > error:- > > > postgres@roblaptop:/usr/lib/postgresql/9.4/bin$ ./pg_upgrade > -b /usr/lib/postgresql/9.3/bin -B /usr/lib/postgresql/9.4/bin > -d /home/postgres/d

[GENERAL] Running pg_upgrade under Debian

2015-04-17 Thread rob stone
Hello, I'm trying to upgrade from 9.3 to 9.4 on my laptop and encountering this error:- postgres@roblaptop:/usr/lib/postgresql/9.4/bin$ ./pg_upgrade -b /usr/lib/postgresql/9.3/bin -B /usr/lib/postgresql/9.4/bin -d /home/postgres/data93/userqueries -D /home/postgres/data94/userqueries -U pguserqu