Feedback-ID: ibc4840b4:Fastmail
From: Padraic Renaghan <padraic@renaghan.com>
To: pgsql-jdbc@lists.postgresql.org
Subject: Re: jdbc connection multiple host
Date: Tue, 30 Jul 2024 08:35:31 -0400
Message-ID: <6BC75F21-E09C-43AE-8878-8321EA9ADB7A@renaghan.com>
In-Reply-To: 
 <CAHgTRfda83VNLbXqXOPOtauCLd5wubSPtgfoJ9Q_x1WAsZYrSw@mail.gmail.com>
References: 
 <CAHgTRfda83VNLbXqXOPOtauCLd5wubSPtgfoJ9Q_x1WAsZYrSw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="=_MailMate_BCD7059A-2BE8-4EEA-82F6-7A03DBE07778_="
Archived-At: 
 <https://www.postgresql.org/message-id/6BC75F21-E09C-43AE-8878-8321EA9ADB7A%40renaghan.com>
Precedence: bulk


--=_MailMate_BCD7059A-2BE8-4EEA-82F6-7A03DBE07778_=
Content-Type: text/plain; format=flowed; markup=markdown

See info here at bottom of [this 
page](https://jdbc.postgresql.org/documentation/use/#connection-fail-over)

> From: James Pang <jamespang886@gmail.com>
> Subject: jdbc connection multiple host
> Date: 2024-07-30 08:28 EDT
>
>  We plan to migrate Oracle to Postgresql databases. Application put
> multiple host:ip in connection string,
> jdbc://host1ip:port,host2:port/dbname , when host1 is accessible, it's
> preferred. when host1 is not accessible, host2:port is secondary.
>   how to do that through  Postgresql JDBC driver ?
>
> Thanks,
>
> James
--=_MailMate_BCD7059A-2BE8-4EEA-82F6-7A03DBE07778_=
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html>
<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/xhtml; charset=3Dutf-8"=
>
</head>
<body><div style=3D"font-family: sans-serif;"><div class=3D"markdown" sty=
le=3D"white-space: normal;">
<p dir=3D"auto">See info here at bottom of <a href=3D"https://jdbc.postgr=
esql.org/documentation/use/#connection-fail-over" style=3D"color: #3983C4=
;">this page</a></p>
<blockquote style=3D"margin: 0 0 5px; padding-left: 5px; border-left: 2px=
 solid #777777; color: #777777;">
<p dir=3D"auto">From: James Pang <a href=3D"mailto:jamespang886@gmail.com=
" style=3D"color: #777777;">jamespang886@gmail.com</a><br>
Subject: jdbc connection multiple host<br>
Date: 2024-07-30 08:28 EDT</p>
<p dir=3D"auto">We plan to migrate Oracle to Postgresql databases. Applic=
ation put<br>
multiple host:ip in connection string,<br>
jdbc://host1ip:port,host2:port/dbname , when host1 is accessible, it's<br=
>
preferred. when host1 is not accessible, host2:port is secondary.<br>
how to do that through  Postgresql JDBC driver ?</p>
<p dir=3D"auto">Thanks,</p>
<p dir=3D"auto">James</p>
</blockquote>

</div>
</div>
</body>

</html>

--=_MailMate_BCD7059A-2BE8-4EEA-82F6-7A03DBE07778_=--