Обсуждение: Azure Postgres PAAS

Поиск
Список
Период
Сортировка

Azure Postgres PAAS

От
Ron Watkins
Дата:
We are running Postgres on Azure PAAS environment, and need to find a way to load data. Currently, on our older IAAS solution we have a local filesystem on the database node, however with the PAAS solution there is no option for local filesystem.
Any suggestions?

--
Ron Watkins, AI7AK
602.743.5272

Re: Azure Postgres PAAS

От
Laurenz Albe
Дата:
On Mon, 2021-06-14 at 11:43 -0700, Ron Watkins wrote:
> We are running Postgres on Azure PAAS environment, and need to find a way to load data.
>  Currently, on our older IAAS solution we have a local filesystem on the database node,
>  however with the PAAS solution there is no option for local filesystem.
> Any suggestions?

Either move away from Azure, or use COPY ... FROM STDIN.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

Re: Azure Postgres PAAS

От
Adam Brusselback
Дата:
One option is to use a Cloud Shell terminal to install psql, and connect to your PAAS environment and use \copy, etc to load data as necessary. Plenty of options. You will just be doing it over the network when you are using a PAAS tool.