On Thu, May 16, 2013 at 02:21:16PM -0400, AI Rumman wrote:
> I told you I would never go for a production with link mode. However, I was
> working with pg_upgrade copy mode and in the middle I got an error saying
> missing some extensions. I rollback and start the operation after setting
> everythi
As usual, you are totally right Tom.
But thanks everybody for the debate. Only I have to add, is near a "must"
to run with --check before actually run the command.
2013/5/16 Tom Lane
> Fabio Rueda Carrascosa writes:
> > Hello, I have a 9.1 cluster with 50 databases, only one table per db wi
Fabio Rueda Carrascosa writes:
> Hello, I have a 9.1 cluster with 50 databases, only one table per db with
> 2000 rows only, but a lot of schema around each one (postgis databases)
> The old cluster size is 1GB
> du -chs /var/lib/postgresql/9.1/main/
> 1.1G
> now I run a pg_upgrade to 9.2 with
Fabio Rueda Carrascosa
> > Cc: pgsql-general
> > Subject: Re: [GENERAL] pg_upgrade link mode
> >
> > I always think its a bit risky to use link instead of copying.
> However, I'd suggest to try the --check at first of pg_upgrade.
> >
> > --
ent: Thursday, May 16, 2013 1:56 PM
> > To: Fabio Rueda Carrascosa
> > Cc: pgsql-general
> > Subject: Re: [GENERAL] pg_upgrade link mode
> >
> > I always think its a bit risky to use link instead of copying. However,
On Thu, May 16, 2013 at 11:03 AM, Igor Neyman wrote:
>
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of AI Rumman
> Sent: Thursday, May 16, 2013 1:56 PM
> To: Fabio Rueda Carrascosa
> Cc: pgsql-general
> Subject: Re: [GEN
> Subject: Re: [GENERAL] pg_upgrade link mode
>
> I always think its a bit risky to use link instead of copying. However,
> I'd suggest to try the --check at first of pg_upgrade.
>
> --
>
> Why?
> Do you have
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of AI Rumman
Sent: Thursday, May 16, 2013 1:56 PM
To: Fabio Rueda Carrascosa
Cc: pgsql-general
Subject: Re: [GENERAL] pg_upgrade link mode
I always think its a bit risky to use link instead of copying
I always think its a bit risky to use link instead of copying. However, I'd
suggest to try the --check at first of pg_upgrade.
On Thu, May 16, 2013 at 1:42 PM, Fabio Rueda Carrascosa <
avances...@gmail.com> wrote:
> Hello, I have a 9.1 cluster with 50 databases, only one table per db with
> 200
Hello, I have a 9.1 cluster with 50 databases, only one table per db with
2000 rows only, but a lot of schema around each one (postgis databases)
The old cluster size is 1GB
du -chs /var/lib/postgresql/9.1/main/
1.1G
now I run a pg_upgrade to 9.2 with hard link mode,
pg_upgrade --link \
--
10 matches
Mail list logo
