public inbox for [email protected]
help / color / mirror / Atom feedRe: old OS
5+ messages / 4 participants
[nested] [flat]
* Re: old OS
@ 2025-02-04 18:00 Tom Lane <[email protected]>
2025-02-04 20:27 ` Re: old OS Marc Millas <[email protected]>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2025-02-04 18:00 UTC (permalink / raw)
To: Christophe Pettus <[email protected]>; +Cc: Marc Millas <[email protected]>; [email protected] <[email protected]>
Christophe Pettus <[email protected]> writes:
> On Feb 4, 2025, at 09:49, Marc Millas <[email protected]> wrote:
>> My question is: is there any possibility to find something ?
>> and/or what is the latest psql available on a redhat 6.5 ?
> Although I've not done so, it should be possible to build from source even on a system that old.
Another workaround is to connect from a remote instance of psql.
You'd probably need to modify the server's pg_hba.conf and perhaps
poke a hole in its firewall, but that's still easier than installing
new software.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: old OS
2025-02-04 18:00 Re: old OS Tom Lane <[email protected]>
@ 2025-02-04 20:27 ` Marc Millas <[email protected]>
2025-02-04 20:34 ` Re: old OS Tom Lane <[email protected]>
2025-02-04 20:58 ` Re: old OS Adrian Klaver <[email protected]>
2025-02-04 21:12 ` Re: old OS Ron Johnson <[email protected]>
0 siblings, 3 replies; 5+ messages in thread
From: Marc Millas @ 2025-02-04 20:27 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: Christophe Pettus <[email protected]>; [email protected] <[email protected]>
Hi Tom,
the data in the redhat 6.5 machine is NOT in Postgres, its in an old Oracle
instance, 4TB of it.
So I am working on a way to extract it to a file or, better to a pipe.
If I was able to get a local psql then, fine, i'll pipe the flow to it,
done.(almost...)
If no local postgres tool, as said, I will try to pipe data through the
network,
but this imply that data will be put exactly as psql, on the new machine,
will be able to 'ingest' it.
easy for most things, somewhat more boring for blobs...
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Tue, Feb 4, 2025 at 7:00 PM Tom Lane <[email protected]> wrote:
> Christophe Pettus <[email protected]> writes:
> > On Feb 4, 2025, at 09:49, Marc Millas <[email protected]> wrote:
> >> My question is: is there any possibility to find something ?
> >> and/or what is the latest psql available on a redhat 6.5 ?
>
> > Although I've not done so, it should be possible to build from source
> even on a system that old.
>
> Another workaround is to connect from a remote instance of psql.
> You'd probably need to modify the server's pg_hba.conf and perhaps
> poke a hole in its firewall, but that's still easier than installing
> new software.
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: old OS
2025-02-04 18:00 Re: old OS Tom Lane <[email protected]>
2025-02-04 20:27 ` Re: old OS Marc Millas <[email protected]>
@ 2025-02-04 20:34 ` Tom Lane <[email protected]>
2 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2025-02-04 20:34 UTC (permalink / raw)
To: Marc Millas <[email protected]>; +Cc: Christophe Pettus <[email protected]>; [email protected] <[email protected]>
Marc Millas <[email protected]> writes:
> the data in the redhat 6.5 machine is NOT in Postgres, its in an old Oracle
> instance, 4TB of it.
> So I am working on a way to extract it to a file or, better to a pipe.
> If I was able to get a local psql then, fine, i'll pipe the flow to it,
> done.(almost...)
> If no local postgres tool, as said, I will try to pipe data through the
> network,
> but this imply that data will be put exactly as psql, on the new machine,
> will be able to 'ingest' it.
I'm not really following why this requires any processing to be done
locally on the old machine. You've got to shove the data over the
network sooner or later, so why not sooner?
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: old OS
2025-02-04 18:00 Re: old OS Tom Lane <[email protected]>
2025-02-04 20:27 ` Re: old OS Marc Millas <[email protected]>
@ 2025-02-04 20:58 ` Adrian Klaver <[email protected]>
2 siblings, 0 replies; 5+ messages in thread
From: Adrian Klaver @ 2025-02-04 20:58 UTC (permalink / raw)
To: Marc Millas <[email protected]>; Tom Lane <[email protected]>; +Cc: Christophe Pettus <[email protected]>; [email protected] <[email protected]>
On 2/4/25 12:27, Marc Millas wrote:
> Hi Tom,
>
> the data in the redhat 6.5 machine is NOT in Postgres, its in an old
> Oracle instance, 4TB of it.
Maybe?:
https://github.com/laurenz/oracle_fdw
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: old OS
2025-02-04 18:00 Re: old OS Tom Lane <[email protected]>
2025-02-04 20:27 ` Re: old OS Marc Millas <[email protected]>
@ 2025-02-04 21:12 ` Ron Johnson <[email protected]>
2 siblings, 0 replies; 5+ messages in thread
From: Ron Johnson @ 2025-02-04 21:12 UTC (permalink / raw)
To: pgsql-general
https://ora2pg.darold.net/
It can access remote Oracle databases, and migrate LOB columns to bytea.
Worked quite well for me on a database 3x that size.
On Tue, Feb 4, 2025 at 3:28 PM Marc Millas <[email protected]> wrote:
> Hi Tom,
>
> the data in the redhat 6.5 machine is NOT in Postgres, its in an old
> Oracle instance, 4TB of it.
> So I am working on a way to extract it to a file or, better to a pipe.
> If I was able to get a local psql then, fine, i'll pipe the flow to it,
> done.(almost...)
>
> If no local postgres tool, as said, I will try to pipe data through the
> network,
> but this imply that data will be put exactly as psql, on the new machine,
> will be able to 'ingest' it.
> easy for most things, somewhat more boring for blobs...
>
>
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mokadb.com
>
>
>
> On Tue, Feb 4, 2025 at 7:00 PM Tom Lane <[email protected]> wrote:
>
>> Christophe Pettus <[email protected]> writes:
>> > On Feb 4, 2025, at 09:49, Marc Millas <[email protected]> wrote:
>> >> My question is: is there any possibility to find something ?
>> >> and/or what is the latest psql available on a redhat 6.5 ?
>>
>> > Although I've not done so, it should be possible to build from source
>> even on a system that old.
>>
>> Another workaround is to connect from a remote instance of psql.
>> You'd probably need to modify the server's pg_hba.conf and perhaps
>> poke a hole in its firewall, but that's still easier than installing
>> new software.
>>
>> regards, tom lane
>>
>
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2025-02-04 21:12 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-04 18:00 Re: old OS Tom Lane <[email protected]>
2025-02-04 20:27 ` Marc Millas <[email protected]>
2025-02-04 20:34 ` Tom Lane <[email protected]>
2025-02-04 20:58 ` Adrian Klaver <[email protected]>
2025-02-04 21:12 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox