Hi!
Is it possible to backup a PostgreSQL database (or a specific table) using FME?
Solved
PostgreSQL backup
+6- Contributor
Best answer by virtualcitymatt
Yes, there are many options to use FME to perform a backup of a database or table.
with the SQLExceutor you can essentially perform any operatoins which you can via SQL.
You can also make system calls with FME using the SytemCaller. This is nice if you already have a script which runs a backup which you’d like to integrate or if you want to use the psql.exe directly.
Probably the easiest method it what
Here’s some more info from another user who had a similar question.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+22- Influencer
Hi,
I think this depends on what you think of as a backup. FME is able to read features and copy them over to another table or another file format. It might be able to copy the whole table without reading it with the sqlexecuter but I would need to look into it further.
🫠
+47- Celebrity
- Best Answer
Yes, there are many options to use FME to perform a backup of a database or table.
with the SQLExceutor you can essentially perform any operatoins which you can via SQL.
You can also make system calls with FME using the SytemCaller. This is nice if you already have a script which runs a backup which you’d like to integrate or if you want to use the psql.exe directly.
Probably the easiest method it what
Here’s some more info from another user who had a similar question.