Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-15 Thread Andreas Joseph Krogh
På fredag 15. januar 2016 kl. 16:04:00, skrev Shulgin, Oleksandr < oleksandr.shul...@zalando.de >: On Fri, Jan 15, 2016 at 3:41 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På fredag 15. januar 2016 kl. 14:33:24, skrev Shulgin, Oleksandr mailto:o

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-15 Thread Shulgin, Oleksandr
On Fri, Jan 15, 2016 at 3:41 PM, Andreas Joseph Krogh wrote: > På fredag 15. januar 2016 kl. 14:33:24, skrev Shulgin, Oleksandr < > oleksandr.shul...@zalando.de>: > > On Fri, Jan 15, 2016 at 1:02 PM, Andreas Joseph Krogh > wrote: >> >> >> I see that wal_level = 'logical', and that is a problem f

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-15 Thread Andreas Joseph Krogh
På fredag 15. januar 2016 kl. 14:33:24, skrev Shulgin, Oleksandr < oleksandr.shul...@zalando.de >: On Fri, Jan 15, 2016 at 1:02 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På torsdag 14. januar 2016 kl. 00:34:51, skrev Jim Nasby mailto:jim.na...

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-15 Thread Shulgin, Oleksandr
On Fri, Jan 15, 2016 at 1:02 PM, Andreas Joseph Krogh wrote: > På torsdag 14. januar 2016 kl. 00:34:51, skrev Jim Nasby < > jim.na...@bluetreble.com>: > > On 1/13/16 2:39 PM, Andreas Joseph Krogh wrote: > > Where can I find more info about how to use and configure pg_logical to > > replicate a 9.

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-15 Thread Andreas Joseph Krogh
På torsdag 14. januar 2016 kl. 00:34:51, skrev Jim Nasby < jim.na...@bluetreble.com >: On 1/13/16 2:39 PM, Andreas Joseph Krogh wrote: > Where can I find more info about how to use and configure pg_logical to > replicate a 9.4 DB to 9.5? http://2ndquadrant.com/e

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-13 Thread Jim Nasby
On 1/13/16 2:39 PM, Andreas Joseph Krogh wrote: Where can I find more info about how to use and configure pg_logical to replicate a 9.4 DB to 9.5? http://2ndquadrant.com/en/resources/pglogical/ -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architectu

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-13 Thread Andreas Joseph Krogh
På onsdag 13. januar 2016 kl. 19:18:20, skrev Jim Nasby < jim.na...@bluetreble.com >: On 1/13/16 2:03 AM, Andreas Joseph Krogh wrote: > Seems like pglogical migth be better? > http://2ndquadrant.com/en/resources/pglogical/ > It's available for 9.4 also. It woul

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-13 Thread Jim Nasby
On 1/13/16 2:03 AM, Andreas Joseph Krogh wrote: Seems like pglogical migth be better? http://2ndquadrant.com/en/resources/pglogical/ It's available for 9.4 also. It would certainly be faster. It's also less tested than Slony is though, as it's fairly new. If it was me, I'd use pg_logical. --

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-13 Thread Vick Khera
On Wed, Jan 13, 2016 at 3:03 AM, Andreas Joseph Krogh wrote: > Seems like pglogical migth be better? > http://2ndquadrant.com/en/resources/pglogical/ > > I would have no idea. I never used it, nor do I run RHEL (or any linux for that matter) which seems to be the only supported OS for that softw

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-13 Thread Andreas Joseph Krogh
På onsdag 13. januar 2016 kl. 04:17:03, skrev Vick Khera mailto:vi...@khera.org>>:   On Tue, Jan 12, 2016 at 4:20 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: I'm moving a > 500GB DB to another server which is initdb'ed with a different locale (nb_NO.UTF-8 to get correct collation

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-13 Thread Andreas Joseph Krogh
På onsdag 13. januar 2016 kl. 03:58:27, skrev John McKown < john.archie.mck...@gmail.com >: On Tue, Jan 12, 2016 at 4:09 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På tirsdag 12. januar 2016 kl. 22:56:56, skrev John R Pierce < pie...@hogranch.co

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-12 Thread Vick Khera
On Tue, Jan 12, 2016 at 4:20 PM, Andreas Joseph Krogh wrote: > I'm moving a > 500GB DB to another server which is initdb'ed with a > different locale (nb_NO.UTF-8 to get correct collation when ORDER BY). > Is there another option than pg_dump/restore for doing this? > I recently used slony to mo

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-12 Thread John McKown
On Tue, Jan 12, 2016 at 4:09 PM, Andreas Joseph Krogh wrote: > På tirsdag 12. januar 2016 kl. 22:56:56, skrev John R Pierce < > pie...@hogranch.com>: > > On 1/12/2016 1:20 PM, Andreas Joseph Krogh wrote: > > I'm moving a > 500GB DB to another server which is initdb'ed with a > > different locale

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-12 Thread Andreas Joseph Krogh
På onsdag 13. januar 2016 kl. 00:03:18, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > What about ORDER BY on columns without an index, would they sort correctly? Sorting is sorting, it'll just use whatever collation is specified or implied. regards, tom lane   Ri

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-12 Thread Tom Lane
Andreas Joseph Krogh writes: > What about ORDER BY on columns without an index, would they sort correctly? Sorting is sorting, it'll just use whatever collation is specified or implied. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-12 Thread Andreas Joseph Krogh
På tirsdag 12. januar 2016 kl. 23:49:24, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > Are you saying that I don't have to re-initdb and can just change collation > somehow? If so, how? Collation is really pretty much a per-index property these days; the DB-level

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-12 Thread Tom Lane
Andreas Joseph Krogh writes: > Are you saying that I don't have to re-initdb and can just change collation > somehow? If so, how? Collation is really pretty much a per-index property these days; the DB-level setting only provides a default. You could imagine some process along the lines of: 1.

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-12 Thread Andreas Joseph Krogh
På tirsdag 12. januar 2016 kl. 23:28:55, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > P�� tirsdag 12. januar 2016 kl. 22:56:56, skrev John R Pierce < > pie...@hogranch.com >: >> On 1/12/2016 1:20 PM, Andreas Joseph Krogh wrote: >>> I'm

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-12 Thread Tom Lane
Andreas Joseph Krogh writes: > PÃ¥ tirsdag 12. januar 2016 kl. 22:56:56, skrev John R Pierce < > pie...@hogranch.com >: >> On 1/12/2016 1:20 PM, Andreas Joseph Krogh wrote: >>> I'm moving a > 500GB DB to another server which is initdb'ed with a >>> different locale (nb_

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-12 Thread Andreas Joseph Krogh
På tirsdag 12. januar 2016 kl. 22:56:56, skrev John R Pierce < pie...@hogranch.com >: On 1/12/2016 1:20 PM, Andreas Joseph Krogh wrote: > I'm moving a > 500GB DB to another server which is initdb'ed with a > different locale (nb_NO.UTF-8 to get correct collation when O

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-12 Thread John R Pierce
On 1/12/2016 1:20 PM, Andreas Joseph Krogh wrote: I'm moving a > 500GB DB to another server which is initdb'ed with a different locale (nb_NO.UTF-8 to get correct collation when ORDER BY). Is there another option than pg_dump/restore for doing this? nope, because the text data has to be conver

[GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-12 Thread Andreas Joseph Krogh
Hi all.   I'm moving a > 500GB DB to another server which is initdb'ed with a different locale (nb_NO.UTF-8 to get correct collation when ORDER BY). Is there another option than pg_dump/restore for doing this?   Thanks.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 and