Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??

From: Jeremy Schneider <schneider(at)ardentperf(dot)com>
To: Eugene Poole <etpoole60(at)comcast(dot)net>
Cc: Kevin Brannen <KBrannen(at)efji(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??
Date: 2017-12-06 22:28:15
Message-ID: 0dbb6760-c034-4c20-d0c5-8b1775d89bab@ardentperf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/5/17 12:07, Kevin Brannen wrote:
> 1. What version of PostgreSQL should I use?
>
> The latest that works for you. Some people don’t like .0 releases
> for various reasons and if that applies to you, then use the latest
> of 9.6.x (9.6.5 I think); else use 10.0.

In addition, 10.1 is available as of Nov 9th

> 2. I don't want to use a RPM because I like controlling where
> software is installed, so where can I locate the required tar ball?

I wonder if the PGDG rpms are relocatable packages? I haven't tried that
yet.

> You can download the source and build it yourself; there’s an arg
> for where you want to install it. The instructions are pretty easy
> to follow if you’ve ever built anything.

Agree you can run the build script easily enough, although personally
I'd prefer a package over doing my own builds. Maybe it's not a priority
to you, but if you're building stuff yourself and you really want to do
it right then you should be tracking a lot of stuff and making sure you
are using all the right configure options and making sure you can always
perfectly reproduce builds. Probably should be creating and archiving
your own packages... but depends on your requirements. :)

> 5. What additional information might be helpful?

Just last night we had a great talk at the Seattle PostgreSQL User Group
about moving from MSSQL to PG and many considerations apply equally. In
particular, you can find lots of code to make PostgreSQL act more like
your source DB... but you want to carefully consider whether this is the
right approach in your situation. (There be flame-wars here.)

And speaking of PUGs, you could check for a local one of those and get
connected up to ask future questions face-to-face too. :)

-J

--
http://about.me/jeremy_schneider

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2017-12-06 23:10:47 Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??
Previous Message Thomas Kellerer 2017-12-06 20:54:44 Re: Does Postgresql 10 query partitions in parallel?